- OracleApps Epicenter - http://www.oracleappshub.com -

Step by Step :Using Receipt API ->Create Cash Receipt (Scenario 1)

Long time back , I had a post discussing AR Receipting , API's avaiability and integration [1] with POS based system. This post is sort of tutorial outlines the specifications and the methodology for using the various Receipt APIs.

Functional Importance of Receipt API's

Oracle receipt APIs provide an extension to existing functionality of creating and manipulating receipts through standard AR Receipts forms and lockboxes.

Most of the public receipt API caters to the following basic functionality via different API calls:

  1. Creating a cash receipt.
  2. Applying a cash receipt to a debit item.
  3. Creating a cash receipt and applying it to a debit item in one pass.
  4. On-account application.
  5. Unapplying the on-account application.
  6. Unapplying the receipt application to a particular transaction.
  7. Reversing the receipt.
  8. Activity application, such as Receipt Write-off.
  9. Creating a miscellaneous receipt.
  10. Other account application, such as Claim Investigation.
  11. Receipt-to-receipt application.
  12. Creating a cash receipt and an on-account application in one pass.

These API potentially used when you are using two major products like AR and Trade managment.

Which API's is not supported

  1. Creating a Batch Receipt

Why Receipts API are in demand

What is senarios

The senario which going to discuss here is "Create Cash Receipt "

In Reality a cash receipts may be created as identified (with a customer/Transaction) or as unidentified (without a customer).This routine is called to create cash receipts for the payment received in the form of a check or cash.

The key is

Moreover Receipt that you are going to create must have a Payment method , which have underline account details for identified and unidentified account.

Which API is being used

By using the following procedure Ar_receipt_api_pub.Create_cash you can create a single cash receipt, as in the case of manually created cash receipts.

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.

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'; --'AR';
  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 thisscript [2] , this will set the apps environment.

Alternatively you can use fnd_global.apps_initialize(1290,51118,222) before calling API.

Step 4: run the

script [3] in Toad or sql*plus and once the procedure executed correctly Oracle will issue a receipt id.

This is been tested in 11i . With little modification you can use in R12. Here is api code in text file.

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-TEST1'(As Example discussed above). The below screen shows the created cash receipt

We will some other API usage in another post.

1 Comment (Open | Close)

1 Comment To "Step by Step :Using Receipt API ->Create Cash Receipt (Scenario 1)"

#1 Comment By ando0098 On June 7, 2010 @ 3:46 am

Hello
Thank you for this detailed description, it helped me a lot to understand the API.
My problem is that I’m trying to develop the methods necessary to integrate receipt and accounting writing with EBS, but I think there is a difference between the receipt of which I speak and receipt that you mentioned.
Because the receipt for me means the receipt of items, cons for you reception means receiving of money (if I understand your example).
My question is this the same thing?
If not can you help me to find the needed tables for the integration of receipt and accounting writing?
Thank you in advance