My Oracle Support Banner

R12: AP: Getting Error ORA-06512: at "APPS.AP_WEB_AME_PKG", line 828, While Trying to Approve the Expense Report Via the Approval Notification (Doc ID 2456426.1)

Last updated on APRIL 01, 2024

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.

Purpose

This document explains how to troubleshoot / debug ORA errors on server-side API AP_WEB_AME_PKG while approving an Expense Report.

Getting the below error message when trying to approve an expense report using the workflow approval notification:

oracle.apps.fnd.framework.OAException: 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.

Steps to reproduce:

  1. Login into Applications using an iExpenses reponsibility.
  2. Create a new Expense Report and submit for approval.
  3. Approver finds the workflow approval Notification in the Worklist.
  4. Open the Approval Notification.
  5. Click on [Approve]

 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Code Involved
 Troubleshooting


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