R12 AP: "AuditTrail Update Tables" Concurrent Error (Doc ID 2269434.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Application Object Library - Version 12.1.1 and later
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Goal

Problem Summary
---------------------------------------------------
Concurrent "AuditTrail Update Tables" processing in error


Problem Description
---------------------------------------------------

The set audit table is AP (for example: "AP_EXPENSE_REPORT_HEADERS_ALL", "AP_EXPENSE_REPORT_LINES_ALL")

The audit trail is set up, and concurrent "AuditTrail Update Tables" processing ends in error.

=====================================================================================

FNDATUPD: AuditTrail Update Tables

 

----->Adding ROW_KEY
**Starts**18-MAY-2017 17:35:17
**SQL error and free**18-MAY-2017 17:35:17
ORACLE error 903 in FDPSTP

Cause: FDPSTP failed due to ORA-00903: invalid table name
ORA-06512: at "APPS.FND_AUDIT_UPDATE_PKG", line 73
ORA-06512: at line 1
.
The SQL statement being executed at the time of the error was: and was executed from the file 18-MAY-2017 17:35:17

----->Alter Shadow Table
ALTER TABLE GL_LEDGERS_A ADD (LEDGER_ID NUMBER(15,0))
ALTER TABLE GL_LEDGERS_A ADD (LEDGER_ID NUMBER(15,0))

=====================================================================================

 

Solution

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