Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Step by Step :Using Receipt API ->Creating cash and apply (Scenario 2)

Posted on May 2nd, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Previous tutorial

dgreybarrow What is senarios here

The senario for discuss here is "Create And Apply Receipt"

This debit item could be for the same customer or related customer, or for an unrelated customer, depending on the Allow Payment of Unrelated Transactions system option.

dgreybarrowWhich API is being used

By using the following Procedure Ar_receipt_api_pub.Create_and_apply you can create a cash receipt and same time you can apply it to a specified installment of a debit item.

dgreybarrow Step to use the API

You have to perform these steps in order to get API executed

Step 1 : Identification of some mandatory and key column of API

Once you identify the key and mandatory column , you have 50% done. What is recomended for you to check the API version in irep with your EBS version.

Here is the example.

Case 1 Receipt API Oracle Parameter

Step 2 : Idetify and the mandatory column and must do pre-requsite setup for receipt.

Your Payment method , underline bank, respective accounting details must be pre-requiste step up for creating a receipt in Oracle.

The mandatory requirement is Customer master with valid bill to and a valid transaction that must be open.

Step 3: You need to initialize the apps_initialize pacakge

For this you have to follow these steps:

Run the query 1

  1.  
  2. SELECT USER_ID FROM FND_USER
  3. WHERE USER_NAME='USER_NAME';
  4.  

Run the query 2

  1.  
  2. SELECT application_id FROM fnd_application
  3. WHERE application_short_name LIKE 'APPL_SHRT_NAME';
  4.  

Run the query 3

  1.  
  2. SELECT RESPONSIBILITY_ID
  3. FROM FND_RESPONSIBILITY
  4. WHERE APPLICATION_ID=222;
  5.  

Run the query 4

Run this script in your Toad or Sql*Plus Client , this will initialize the apps, else you can aso directly call fnd_global.apps_initialize(1290,51118,222) before calling API.

Step 4: Use this script in Toad or sql*plus and once the procedure executed correctly Oracle will issue a receipt id. Here is script , that you can use for creating Receipt.This is been tested in 11i . With little modification you can use in R12. Here is api code in text file.

dgreybarrow Finally Verification

Make sure you API executed correctly , once done you can check the receipt creation from Receipt workbench screen. What you have to do, just search the Receipt number and verify the details are correctly been populated or not.

Navigate to Receivables

Receipts : Receipts.

Query for Receipt Number 'HUB-TEST2'(As Example discussed above). The below screen shows the created cash receipt

case 2 a

case 2 b

Related Posts

Posted in Oracle Receivable | 5 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
5 Responses
  1. Step by Step :Using Receipt API ->Apply On Account (Scenario 3) | OracleApps Epicenter Says:

    […] Step by Step :Using Receipt API ->Creating cash and apply (Scenario 2) […]

  2. Step by Step :Using Receipt API ->Reverse Receipt (Scenario 4) | OracleApps Epicenter Says:

    […] Step by Step :Using Receipt API ->Creating cash and apply (Scenario 2) […]

  3. john Says:

    good article..the script works..thanks

  4. Robert Says:

    ok

  5. Aadi Says:

    Using Receipt API Pub, is there anyway to bring in the legacy batch number?

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.