My Oracle Support Banner

Depot Work Orders Error ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_SUPPLY_TYPE") (Doc ID 2897824.1)

Last updated on FEBRUARY 14, 2024

Applies to:

Oracle Depot Repair - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 and higher version, Repair Order Management

ACTUAL BEHAVIOR
---------------
Depot Repair Work Orders are created but the material lines are not defaulting to the Wip job.

The following error is found in the debug log:

ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_SUPPLY_TYPE")

 

Changes

 Applied patch 33916917:R12.CSD.C "ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION 01-JUN-2022" or the latest Depot CPU patch.

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.