My Oracle Support Banner

Audit Trail For Sourcing Negotiation Team Members Gets Error APP-FND-00016 On Table PON_NEG_TEAM_MEMBERS (Doc ID 2192087.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms

Audit Trail for Sourcing Negotiation Team Members table PON_NEG_TEAM_MEMBERS gets error APP-FND-00016.  This occurs when trying to generate audit trail information for table PON_NEG_TEAM_MEMBERS, by running concurrent program AuditTrail Update Tables.  The following error occurs:

ERROR

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

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 <DATE> <TIME>

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

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

----->Expand Rows
INSERT INTO FND_AUDIT_COLUMNS (TABLE_APP_ID, TABLE_ID,COLUMN_ID,STATE,SEQUENCE_ID, SCHEMA_ID, LAST_UPDATE_DATE,LAST_UPDATED_BY, LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE) VALUES ( 396, 87739, 757145, 'P', -1, <VALUE>, SYSDATE,0,0,0,SYSDATE)

UPDATE FND_AUDIT_TABLES T SET T.STATE = 'P' WHERE T.TABLE_APP_ID = 396 AND T.TABLE_ID = 87739

commit

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')

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

Action: Define primary key information for table. Auditing cannot occur on tables without primary
keys.
APP-FND-00016: No primary key information exists for table PON_NEG_TEAM_MEMBERS_A, audit table not made.

----->Update Pending Columns
----->Adding ROW_KEY
**Starts**<DATE> <TIME>
----->Alter Shadow Table
ALTER TABLE PON_NEG_TEAM_MEMBERS_A ADD (AUCTION_HEADER_ID NUMBER )
ALTER TABLE PON_NEG_TEAM_MEMBERS_A ADD (AUCTION_HEADER_ID NUMBER )
ORA-00942: la tabla o vista no existe

Error fatal en fdasql, cerrando...
Error en fdaacl, continuando...



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to System Administrator > Security > AuditTrail > Groups.
2. Run the "AuditTrail Update Tables" for table PON_NEG_TEAM_MEMBERS
3. See the error

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.