Posts

Showing posts from June, 2014

Sample Code for API AR_CASH_RECEIPT_API.PUB by Pranay Tiwari

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

AR Receipts : Receipt Creation Tutorial by Pranay Tiwari

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