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.
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.
- Chose a business unit which is configured as Inventory business unit, but not configured as Order Management business unit.
Create an Express Issue (Inter Unit Transfer) on the business unit from point 1.
Launch IN_FUL_DEL and it fails with the error ORA-01407.
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!