My Oracle Support Banner

AUDIT Can’t Be Enabled For CLL_F036_AP_SUPPLIER_SITES_EXT Table (Doc ID 2615754.1)

Last updated on JANUARY 09, 2020

Applies to:

LAD Add-on Localizations - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Brazil, LAD Add-on Localizations - LAD-GTR

ACTUAL BEHAVIOR
---------------
Audit cannot be enabled for the CLL_F036_AP_SUPPLIER_SITES_EXT table.

 

EXPECTED BEHAVIOR
-----------------------
Audit should be enabled for the CLL_F036_AP_SUPPLIER_SITES_EXT table.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: System Administrator
2. Navigation: Concurrent > Requests
3. Submit program AuditTrail Update Tables
4. When you run the program, the following error can be seen in the log file:

 

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

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.

 Please note that the CLL_F036_AP_SUPPLIER_SIT_A table is the audit table of the CLL_F036_AP_SUPPLIER_SITES_EXT table.

 

BUSINESS IMPACT
-----------------------
Table update history could not be tracked for the CLL_F036_AP_SUPPLIER_SITES_EXT table.

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.