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