My Oracle Support Banner

R12: AP: Force Approval In Payables Invoice Brings Up An Error Message ORA-01403: No Data Found (Doc ID 2353488.1)

Last updated on JUNE 09, 2018

Applies to:

Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.


When input a Standard Invoice and validate the invoice, the Invoice "General" Tab shows the Approval Status as Required. I then "Force Approve" the invoice and the error comes up as follows:

ORA-01403: no data found
FRM-40735: DO_FORCE_APPROVAL trigger raised unhandled exception ORA-01422.

The issue can be reproduced at will with the following steps:
1. Responsibility Payables Manager
2. Navigation: Menu > Enter > Invoices
3. Tab General > Force Approval
4. Error mentioned above appears


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.