Transactions Workbench Issue: Unable to Apply Receipt Against Invoice That Has a Regular Credit Memo Applied
Last updated on MAY 04, 2018
Applies to: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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms