Technology Stack - EBS (MOSC)

MOSC Banner

"AuditTrail Update Tables" Program error

edited Aug 20, 2021 11:34AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

I trying to enable HR Audit in Oracle Application R12.1.1 . I have set the tables which I want to be audited but once I run "AuditTrail Update Tables", it ends with following error.

+---------------------------------------------------------------------------+

Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDATUPD module: AuditTrail Update Tables

+---------------------------------------------------------------------------+

Current system time is 10-AUG-2014 12:39:31

+---------------------------------------------------------------------------+

----->Expand Rows

commit

DELETE FROM FND_AUDIT_TABLES WHERE STATE = 'X'

DELETE FROM FND_AUDIT_COLUMNS C WHERE C.STATE = 'P' AND NOT EXISTS (SELECT NULL FROM FND_AUDIT_TABLES T WHERE T.TABLE_APP_ID = C.TABLE_APP_ID AND T.TABLE_ID = C.TABLE_ID AND T.STATE !='X')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center