My Oracle Support Banner

Encountered Error ORA-01403: No Data Found Error - While Applying Prepayment on a Standard Invoice (Doc ID 2949301.1)

Last updated on MAY 19, 2023

Applies to:

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

Symptoms

Error thrown on apply prepayment in Payables.

ERROR
-----------------------
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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
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.

Changes

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

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
Changes
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.