My Oracle Support Banner

Encountered Error "ORA-01403: no data found" - While Applying Prepayment on a Standard Invoice (Doc ID 2949301.1)

Last updated on JULY 04, 2023

Applies to:

Oracle Financials for India - Version 12.2 and later
Information in this document applies to any platform.


Error thrown while applying prepayment on a Standard Invoice.

Below Error encountered during application :

ORA-01403: no data found

Then Clicking on 'Details' will show below error.

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-04063.

1. Navigate to India Local Payables --> Invoices --> Entry --> Invoice.
2.Create Prepayment Invoice and attach TDS.
3. Validate the Invoice.
4. Now similarly create standard Invoice and attach TDS.
5. Validate the Invoice.
6. When trying to apply prepayment, observe system is throwing error.


 Issue encountered after applying GST patch 34522155:R12.JAI.C


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

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