My Oracle Support Banner

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 SEPTEMBER 19, 2019

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

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
Cause
Solution
References


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