"AuditTrail Update Tables" Program error
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')