AME Error ORA-06512 APPS.APP_EXCEPTION When Manager Terminated
(Doc ID 807464.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Internet Expenses - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
An expense report is submitted using AME. There are 3 approvers for the report. Approver1 receives
the approval notification and successfully approves. AME routes report to Approver2. Before Approver2 approves the notification, Approver1 is terminated in HRMS and Approver1's application account is end dated. Approver2 clicks on the approval notification for the report and receives the error:
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_WEB_AME_PKG", line 828
ORA-06512: at line 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7
...
Notes
(i) If end date is removed from Approver1's application account, then the error does not happen
and Approver2 can access and approve the notification.
-- Steps to Reproduce ###
1. Create an expense report.
2. The report should go to A, B and then to C.
3. After submitting the report, it went to A.
4. A approved the report
5. A was then terminated so A's user record was end dated which made A as inactive
6. The report now errors.
.
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 |