My Oracle Support Banner

Null Pointer Exception When Evaluating Expression Actuals Received in an OTM Agent For OMD Action (Doc ID 831909.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 5.5.03 to 5.5.05.06 [Release 5.5]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 5.5.03, When attempting to send in an Order Release Update with RC as transaction code by removing a Ship Unit, the following error occurs:

ERROR
Cannot delete the SHIP_UNIT_LINE record. A S_SHIP_UNIT_LINE record references it in its
SHIP_UNIT_GID, SHIP_UNIT_LINE_NO column.
java.sql.SQLException: ORA-02292: integrity constraint (GLOGOWNER.FK_SSUL_SHIP_UNIT_LINE) violated
- child record found

java.sql.SQLException: ORA-02292: integrity constraint (GLOGOWNER.FK_SSUL_SHIP_UNIT_LINE) violated
- child record found

* at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)*
* at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)*
* at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)*

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Integrate EBS with OTM and send in a Delivery from EBS to OTM with more than one line
2. Plan the Order in OTM
3. Then in EBS remove a line and send the delivery into OTM. In OTM, see that the Order change
fails to get processed

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.