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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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