Transactions Workbench Issue: Unable to Apply Receipt Against Invoice That Has a Regular Credit Memo Applied
(Doc ID 1917608.1)
Last updated on FEBRUARY 03, 2019
Oracle Receivables - Version 12 and later Information in this document applies to any platform.
You are not able to apply a Receipt against an Invoice (that has a regular credit memo applied to it) at Line Level, Using Public API.
Running the AR_RECEIPT_API_PUB.Apply_In_Detail API, on an Invoice, which has a 0$ Credit Memo applied, the application throws an error:
API Return status : U Applied Message: , ARP_PROCESS_DET_PKG.INITIALIZTION ORA-0000: normal, successful completion, APPLY : ORA-06502: PL/SQL: numeric or value error: character to number conversion error, ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package AR_RECEIPT_API_PUB Procedure Apply_In_Detail,
Steps to Reproduce: 1. Create an Invoice with 2 lines of type LINE and 3 tax lines for each line type of LINE 2. Create a Receipt. 3. Apply a 0$ credit to the Invoice created, Actions/Credit crediting tax and lines. 4. Run the PI AR_RECEIPT_API_PUB.Apply_In_Detail and apply to line # 1 5. See the error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!