Audit Trail Did Not Create Audit Row Within GTM License Master Resulting in Error: "Cannot update the AUDIT_TRAIL record." (Doc ID 1964926.1)

Last updated on APRIL 27, 2015

Applies to:

Oracle Global Trade Management - Version 6.3.3 to 6.3.7 [Release 6.3]
Information in this document applies to any platform.

Symptoms

An Audit is configured on the GTM License object. When an action is performed triggering this audit (such as GTM LICENSE - MODIFIED), an Audit row should be created  Within GTM License Master, however this action did not create the row.

Thie following  illustrates how this issue occurs:


1. Navigate to Trade Compliance Management -> License Management -> License Manager
2. Search for License: xxxxxxxxxx
3. Edit and change the Effective Date (any change is fine)
4. Click Finished

A review of the log of this process, shows:
2014-12-03 13:27:11.944 811038 Error Exception Cannot update the AUDIT_TRAIL record. [AUDIT_OBJECT_TYPE_GID] must reference a valid AUDIT_OBJECT_TYPE record. java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_AT_AUDIT_OBJECT_TYPE_GID) violated - parent key not found

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