Apply On-Account Credit Memo’s to Invoices using AR_RECEIPT_API_PUB
Posted by anilrpatil on October 24, 2009
Automation of manual activities is the norm and that’s where Oracle Standard API’s helps me a lot. The Business scenario for my client is as follows
1. The Client imports feeder system transactions data into Oracle Receivables using RA INTERFACE
2. Credit Memo’s are imported as On-Account Credit Memo’s because there is not enough matching data available in the feeder system that would allow creating Credit transactions against the Invoices through autoinvoice.
3. The Credit Memo number and the related transaction number are maintained in a custom staging table.
4. The requirement was to be able to apply these On-Account Credit Memo’s to the Invoices.
Click here to read our solution
[Keywords: On-Account Credit Memo, AR_RECEIPT_API_PUB]
Krishna said
Hi Anil,
1st let me say thank you for your awesome stuff. I have similar requirement,I need to bring credit memos(not on account credit memos) and apply to invoice from legacy system.
My question is why we need to create a receipt with 0 amount, can’t we apply credit memo directly to invoice with API. I am planning to use ARP_PROCESS_APPLICATION.CM_APPLICATION private API.
But please let me know if there are any other API’s or methods to create and apply the credit memos to Invoice asap. This is very urgent, I really appreciate if you can reply and if you can send some sample code.
Thanks
Krishna