My Oracle Support Banner

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

Last updated on JULY 23, 2019

Applies to:

Oracle Payables - Version 12.1.1 and later
Oracle Application Object Library - Version 12.1.1 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

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
Goal
Solution
References


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