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

Last updated on MARCH 08, 2017

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.
***Checked for relevance on 26-Dec-2013***


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

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