My Oracle Support Banner

"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 20, 2024

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

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
References


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