My Oracle Support Banner

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.