"Cannot update the AUDIT_TRAIL record. AUDIT_OBJECT_TYPE_GID must reference a valid AUDIT_OBJECT_TYPE record." Error With Order Movement Audit (Doc ID 1148769.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.06 to 6.1.3 - Release: 5.5 to 6.1
Information in this document applies to any platform.

Symptoms


An Audit Trail is configured for Order Movements. When this audit is triggered the following error is encountered:

Cannot update the AUDIT_TRAIL record. AUDIT_OBJECT_TYPE_GID must reference a valid AUDIT_OBJECT_TYPE record.
java.sql.SQLException: 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