Tuesday 1 January 2013

Receipt API's in Oracle APPS R12


Receipt API in Oracle Receivables

Autolock box provides a functionality to create receipts using interface method. Recent versions of oracle applications, especially 11.5 onwards, Receipt API is getting used as they are flexible to the user’s need, and customization across all kinds of interfaces, loading.
Here are the receipt APIs used in 11i applications:

ar_receipt_api_pub.Create_cash
ar_receipt_api_pub.Apply
ar_receipt_api_pub.Unapply
ar_receipt_api_pub.Reverse
ar_receipt_api_pub.Apply_on_account
ar_receipt_api_pub.Unapply_on_account
ar_receipt_api_pub.Activity_application
ar_receipt_api_pub.Activity_unapplication
ar_receipt_api_pub.Apply_other_account
ar_receipt_api_pub.Unapply_other_account
ar_receipt_api_pub.create_misc
ar_receipt_api_pub.set_profile_for_testing
ar_receipt_api_pub.Apply_Open_Receipt
ar_receipt_api_pub.Unapply_Open_Receipt


I already have added sample script for receipt creation and application in earlier post.
**********************************************************

The World of receipt API's
To integrate with Oracle apps there are 10 API's, such as:
a) Creating a cash receipt
b) Applying it to a debit item
c) Creating a cash receipt and applying it to a debit item in one pass
d) On-account application
e) Unapplying the On-Account application
f) Unapplying the receipt application to a particular transaction
g) Reversing the receipt
h) Create a Miscellaneous receipt
i) Create a cash receipt activity application
j) Unapplies a cash receipt activity application

The 10 Receipt API's:
1 AR_RECEIPT_API_PUB.CREATE_CASH : This is for creating a single cash receipt, as in case of manually created cash receipts.
2 AR_RECEIPT_API_PUB.APPLY : Applies a cash receipt if used in (1) to a particular installment
of a debit item. The application can also be a cross currency application.
3 AR_RECEIPT_API_PUB.CREATE_AND_APPLY : This API's can be used in place of 2 sepearte call as in (1) & (2) above. This will Creates a cash receipt and applies it to a specified installment of a debit item in one pass.
4 AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT : Does an On Account application for a cash receipt.
5 AR_RECEIPT_API_PUB.UNAPPLY_ON_ACCOUNT : Unapplies the On-account application on the specified receipt.
6 AR_RECEIPT_API_PUB.UNAPPLY : This unapplies the application of a particular installment of a debit item against the specified cash receipt.
7 AR_RECEIPT_API_PUB.REVERSE : This is used to reverses the specified receipt.
8 AR_RECEIPT_API_PUB.CREATE_MISC : This is used to creates a Miscellaneous receipt
9 AR_RECEIPT_API_PUB.ACTIVITY_APPLICATION : This is used to creates an activity application on a cash receipt
10 AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : This API used to unapplies a particular activity application on a cash receipt.

No comments:

Post a Comment