Transactions Workbench Issue: Unable to Apply Receipt Against Invoice That Has a Regular Credit Memo Applied (Doc ID 1917608.1)

Last updated on AUGUST 11, 2022

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

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.