Oracle Applications E-Learning Lab

AR_CASH_RECEIPT_API.PUB  is the API to create receipts in Oracle , And below is the sample API code. Mandatory Input Parameters for API Currency Amount Receipt Method Id  Customer Id  Customer Site Use id  Org Id  Query to derive Receipt Method id           SELECT   receipt_method_id            FROM   ar_receipt_methods           WHERE   name = <Receipt Method Name > Query to derive Cust Account and Site Use id  SELECT   hca.cust_Account_id, hcsu.site_use_id   FROM   HZ_PARTIES HP,          HZ_CUST_ACCOUNTS HCA,          HZ_CUST_ACCT_SITES_ALL HCAS,          HZ_CUST_SITE_USES_ALL HCSU  WHERE       HP.PARTY_ID = HCA.PARTY_ID          AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID          AND HCAS.CUST_aCCT_SITE_ID = HCSU.CUST_aCCT_SITE_ID          and hp.party_name=<Customer Name>          AND hcsu.org_id = <ORG ID> <Code Begins > DECLARE    l_return_status     VARCHAR2 (1);    l_msg_count         NUMBER;    l_msg_data

In Order to create Receipts in Oracle , The following navigation needs to follow Navigations :  Receivables Manager à Receipts à Receipts Enter the Receipt Method name , which has been created in previous tutorial . Once Receipt Method selected , Remittance Bank details gets auto populated.  After entering the Receipt Method details , enter customer details for which receipt needs to be created  Once Customer information and Receipt amount information entered not click on APPLY button to apply amount towards receipts  Once you click on Apply button there are various receipt application method activity  in which you can apply receipt amounts 1.You can apply Receipt amount  against customer Trx_Number which gets populated in the Lov 2.Receipt Amount can be applied ON ACCOUNT if trx_number unknown 3.Receipt Write off is another receipt application activity which used adjust the receipt amount. 1.Receipt Amount applied against selected invo