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 ->Create Cash Receipt (Scenario 1)

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

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

dgreybarrow 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

dgreybarrowWhy Receipts API are in demand

  • For Migration in Transformation/re-implemenation project , company want to bring old receipts to newer system. Except Lockbox, there is no other way other than API.
  • Integration :Some sectors like retail, healthcare , Telco need direct Integration with third party POS based system like (WINCOR etc)
  • Need for excel based upload interface : Majority of collection for companies are in third and fourth week of the month , and all entry should go into system thus need for excel based receipt upload cann't be denied. The business need for having receipt WEBADI is still not supported by Oracle.

dgreybarrow 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

  • When you tag customer/transaction it is identified
  • Where there is no customer attached to receipt it is unidentified.

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

dgreybarrowWhich 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.

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'; --'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 , 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 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.

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

Case 1 Receipt API Oracle

We will some other API usage in another post.

Related Posts

Posted in Oracle Receivable | 1 Comment »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
One Response
  1. ando0098 Says:

    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

Leave a Comment

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