My Oracle Support Banner

ORA-01407 Error Process IN_FUL_DEL Fails At Step IN_DEL_LIB.Cmp4Bill.FrtPrdOM (Doc ID 2425754.1)

Last updated on JULY 21, 2018

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Process IN_FUL_DEL fails at step IN_DEL_LIB.Cmp4Bill.FrtPrdOM

The delivery confirmation process fails if the Inventory business unit is not also configured as an Order Management business unit, when a freight product is defined on the Inventory BU.
Step IN_FUL_DEL fails at step IN_DEL_LIB.Cmp4Bill.FrtPrdOM performs an update from the BUS_UNIT_TML_OM but checks the existance of a row in BUS_UNIT_TML_IN and the update fails with ORA-01407 error.

Replication steps:

  1. Chose a business unit which is configured as Inventory business unit, but not configured as Order Management business unit.
  2. Create an Express Issue (Inter Unit Transfer) on the business unit from point 1.

  3. Launch IN_FUL_DEL and it fails with the error ORA-01407.

 

Error message:


File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708  Error Position: 30  Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_OM_DELORD_TAO4"."INV_ITEM_ID") to NULL

Process 43257 ABENDED at Step IN_DEL_LIB.Cmp4Bill.FrtPrdOM (SQL) -- RC = 1407 (108,524)


Changes

 

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