My Oracle Support Banner

Audit Trail On POS_SUPP_PROF_EXT_B No Primary Key Available (Doc ID 1478172.1)

Last updated on JUNE 19, 2019

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Other Issues

When attempting to enable audit trail on POS_SUPP_PROF_EXT_B table, the following error occurs.

ERROR
-----------------------
Error log message
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')

APP-FND-00016: No primary key information exists for table POS_SUPP_PROF_EXT_B_A, audit table not made.

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
----->Update Pending Columns
----->Adding ROW_KEY
**Starts**25-JUN-2012 14:58:42
----->Alter Shadow Table
ALTER TABLE POS_SUPP_PROF_EXT_B_A ADD (N_EXT_ATTR8 NUMBER )
ALTER TABLE POS_SUPP_PROF_EXT_B_A ADD (N_EXT_ATTR8 NUMBER )
ORA-00942: table or view does not exist

Fatal error in fdasql, quitting...
Error in fdaacl, continuing...
----->Drop Triggers
DROP TRIGGER POS_SUPP_PROF_EXT_B_AI
DROP TRIGGER POS_SUPP_PROF_EXT_B_AI
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AI' does not exist
DROP PROCEDURE POS_SUPP_PROF_EXT_B_AIP
DROP PROCEDURE POS_SUPP_PROF_EXT_B_AIP
ORA-04043: object POS_SUPP_PROF_EXT_B_AIP does not exist
DROP TRIGGER POS_SUPP_PROF_EXT_B_AD
DROP TRIGGER POS_SUPP_PROF_EXT_B_AD
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AD' does not exist
DROP PROCEDURE POS_SUPP_PROF_EXT_B_ADP
DROP PROCEDURE POS_SUPP_PROF_EXT_B_ADP
ORA-04043: object POS_SUPP_PROF_EXT_B_ADP does not exist
DROP TRIGGER POS_SUPP_PROF_EXT_B_AU
DROP TRIGGER POS_SUPP_PROF_EXT_B_AU
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AU' does not exist
DROP PROCEDURE POS_SUPP_PROF_EXT_B_AUP
DROP PROCEDURE POS_SUPP_PROF_EXT_B_AUP
ORA-04043: object POS_SUPP_PROF_EXT_B_AUP does not exist
DROP TRIGGER POS_SUPP_PROF_EXT_B_AC
DROP TRIGGER POS_SUPP_PROF_EXT_B_AC
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AC' does not exist
DROP TRIGGER POS_SUPP_PROF_EXT_B_AH
DROP TRIGGER POS_SUPP_PROF_EXT_B_AH
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AH' does not exist
DROP TRIGGER POS_SUPP_PROF_EXT_B_AT
DROP TRIGGER POS_SUPP_PROF_EXT_B_AT
ORA-04080: trigger 'POS_SUPP_PROF_EXT_B_AT' does not exist
----->Create Standard Triggers
APP-FND-00016: No primary key information exists for table , audit table not made.

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
Fatal error in fdagcn, quitting...
Fatal error in fdactr, quitting...
commit

commit

----->Delete Invalid Columns
commit

update fnd_audit_groups g set g.state='E' where g.state = 'R' and not exists (select NULL from fnd_audit_tables t where t.audit_group_id = g.audit_group_id and t.audit_group_app_id = g.application_id and t.state != 'E')

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable audit trail on POS_SUPP_PROF_EXT_B table .
2 Create the audit group
3 Install audit for POS schema.
4. Run concurrent program "AuditTrail Update Tables"

Cause

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
Symptoms
Cause
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.