My Oracle Support Banner

Transactions Workbench: Using AR_CM_API_PUB.APPLY_ON_ACCOUNT API on CLOSED Invoices and Receive Error - ORA-01403: No Data Found in Package AR_CM_API_PUB Procedure Apply_On_Account (Doc ID 1617961.1)

Last updated on MARCH 14, 2022

Applies to:

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

Symptoms

Attempting to When Trying To Use  Ar_cm_api_pub.apply_on_account API  On CLOSED Invoices the following error occurs:

1. APPLY : ORA-01403: no data found
2. ORA-01403: no data found in Package AR_CM_API_PUB Procedure Apply_on_account

NOTE: 
The Credit Memo application to closed invoices is working properly in the Transactions Applications window, after the Show Closed Invoice Check Box is checked. 
Navigate Tools and Check Show Closed Invoices.

Cause

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
Symptoms
Cause
Solution


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