APP-FND-00016 On Table PON_NEG_TEAM_MEMBERS (Doc ID 2192087.1)

Last updated on NOVEMBER 03, 2016

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 10-SEP-2009 08:10:42

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

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

----->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, 900, 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**17-AGO-2016 18:46:06
----->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

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms