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 MAY 06, 2022

Applies to:

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


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

Cannot delete the SHIP_UNIT_LINE record. A S_SHIP_UNIT_LINE record references it in its
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(*
* at oracle.jdbc.ttc7.TTIoer.processError(*
* at oracle.jdbc.ttc7.Oall7.receive(*

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


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

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