Cannot Insert The Monitor_Agent Record To Milestones Which Are Time Based (Doc ID 417308.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5 CU1:
When attempting to to save a Milestone monitor template with a time based query, the following error occurs:

Cannot insert the MONITOR_AGENT record. AGENT_GID must be set.

java.sql.SQLException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."MONITOR_AGENT"."AGENT_GID")

error message glog.util.exception.CreateExceptionWrapper
Cannot insert the MONITOR_AGENT record. AGENT_GID must be set.
java.sql.SQLException: ORA-01400: cannot insert NULL into
("GLOGOWNER"."MONITOR_AGENT"."AGENT_GID")

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Copy Sell Shipment Milestone Template.
2. Enter SQL Update to Milestone Monitor.
3. Select time based saved query.
4. Attempt to save Milestone Monitor.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot create Milestone Template.


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