R12: OIE: With AME, Timeout Causes Expense Approval to be Stuck & Possible Error ORA-6512
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Internet Expenses - Version 12.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 02-FEB-2016
With AME, after an expense report approval notification timeouts several times in the Worklist, the notification is transferred to its supervisor. At this stage, when the supervisor attempts to open the Notification it errors out with :
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001:
ORA-6512: at "APPS.APP_EXCEPTION", line 72
ORA-6512: at "APPS.AP_WEB_AME_PKG", line 828
ORA-6512: at line 1
## Detail 0 ##
Also, issue can be encountered without the above error and expense report seems to be just stuck in workflow after timeout completes and expense report does not progress through Expenses workflow.
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