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

Last updated on FEBRUARY 01, 2017

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.

Cause

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 hundreds of Community platforms