R12: AP: Force Approval In Payables Invoice Brings Up An Error Message ORA-01403: No Data Found

(Doc ID 2353488.1)

Last updated on JANUARY 26, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Invoices



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:



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


STEPS
-----------------------
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


Changes

 

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