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 AUGUST 11, 2022

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!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 5. Identify Possible Data Corruption
 Still Have Questions?

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