Create Jobs From Depot Repair - ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_SUPPLY_TYPE")
(Doc ID 2899721.1)
Last updated on SEPTEMBER 30, 2022
Applies to:Oracle Depot Repair - Version 12.2.11 and later
Information in this document applies to any platform.
On : 12.2.11 version, Repair Execution
After applying any Depot Repair patch with the file $CSD_TOP/patch/115/sql/csdvhvjb.pls version 120.65.12020000.54 or higher.
Creating Jobs from Depot Repair is not adding components to WIP jobs.
The profile option "CSD: Default Service Order Item as Material on Job" is set to YES at both Site Responsibility Level for the Depot Repair responsibility.
The following error is found in the FND Debug logs.
ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_SUPPLY_TYPE").
The issue can be reproduced at will with the following steps:
Create a Job from the Depot Repair Responsibility
View the job from Jobs tab "Components button " the material is not populating the items under Components
Applied a Depot Repair patch with $CSD_TOP/patch/115/sql/csdvhvjb.pls version 120.65.12020000.54 or higher.
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