10394365: Cannot Setup Audit Trail For Table Je_pt_ra_cust_trx_exts (Doc ID 1323116.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for EMEA - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Portugal Localizations for AP

When attempting to run FNDATUPD module: Audit Trail Update Tables to create an Audit Trail on table JE_PT_RA_CUST_TRX_EXTS the following error occurs:

ERROR
-----------------------

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

APP-FND-00016: No primary key information exists for table JE_PT_RA_CUST_TRX_EXTS_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**29-DEC-2010 16:14:19
----->Alter Shadow Table
ALTER TABLE JE_PT_RA_CUST_TRX_EXTS_A ADD (CERTIFICATION_NUMBER VARCHAR2(80))
ALTER TABLE JE_PT_RA_CUST_TRX_EXTS_A ADD (CERTIFICATION_NUMBER VARCHAR2(80))
ORA-00942: table or view does not exist

Fatal error in fdasql, quitting...
Error in fdaacl, continuing...
----->Drop Triggers
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AI
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AI
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_AI' does not exist
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_AIP
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_AIP
ORA-04043: object JE_PT_RA_CUST_TRX_EXTS_AIP does not exist
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AD
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AD
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_AD' does not exist
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_ADP
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_ADP
ORA-04043: object JE_PT_RA_CUST_TRX_EXTS_ADP does not exist
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AU
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AU
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_AU' does not exist
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_AUP
DROP PROCEDURE JE_PT_RA_CUST_TRX_EXTS_AUP
ORA-04043: object JE_PT_RA_CUST_TRX_EXTS_AUP does not exist
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AC
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AC
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_AC' does not exist
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AH
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AH
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_AH' does not exist
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AT
DROP TRIGGER JE_PT_RA_CUST_TRX_EXTS_AT
ORA-04080: trigger 'JE_PT_RA_CUST_TRX_EXTS_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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created Audit Group (Navigation: Security > Audit Trail > Groups) with the below values
Application = European Localizations
Audit Group = PT VAT CERTIFICATION
Description = PT VAT Certification - Audit Trail of Signature Table
Table = JE_PT_RA_CUST_TRX_EXTS

2. Setup Audit Table (Navigation: Security > Audit Trail > Tables). Added all 10 columns for table JE_PT_RA_CUST_TRX_EXTS

3. Verified that Audit is enabled for application "JE" (Navigation: Security > Audit Trail > Install).

4. Submitted the program "Audit Trail Update Tables".

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