You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error in OTM JSON PATCH API (GLOGOWNER.FK_SUL_ORLGID) violated - parent key not found

in Transportation Management 1 comment

Summary:

I try to modify order release (ORE) via OTM JSON PATCH API and received the error: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (GLOGOWNER.FK_SUL_ORLGID) violated - parent key not found.

Modification creates a new order release line (ORL) and connected order release ship unit line (SUL), and deleting old ORL and connected SUL.

New and old SULs are within existing order release ship unit.

ORE shipUnitOrigin = RS. Order Configuration: Order Base/Release Creation = Ship Unit, Ship Unit Calculation = SU_IGNORE_LINES.

My expectation is that JSON PATCH operations are executed strictly in order as they are in the payload:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!