Opening Approval Notification indicates Requisition Does Not Exist Or is Deleted and Get Exception Errors ORA-01403 and ORA-06512 at POR_AME_APPROVAL_LIST

(Doc ID 1568589.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Approval List and Workflow

When attempting to open approval notification users encounter an error.

Error
 

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException:
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.POR_AME_APPROVAL_LIST", line 2576
ORA-06512: at line 1
..
## Detail 0 ##
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.POR_AME_APPROVAL_LIST", line 2576
ORA-06512: at line 1


Further research showed Requisition data cannot be found on table level and not displayed in both iProcurement and Purchasing.
Due to this issue, users cannot approve document.


Steps To Reproduce

1. Log in as approver.
2. Open notification.
3. Get the reported error.




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