My Oracle Support Banner

Pending WIP Transaction ORA-01400 cannot insert NULL into WIP_REQUIREMENT_OPERATIONS WIP_ENTITY_ID (Doc ID 1503429.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Oracle Work in Process - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

There is a pending WIP Transaction that cannot be reprocessed/resubmitted.

The following error appears in mtl_material_transactions_temp


SOURCE_CODE    WIP Backflush
TRANSACTION_MODE   3
TRANSACTION_SOURCE_ID   <NULL>
ERROR_CODE     Transaction processor error
ERROR_EXPLANATION  An error occurred while updating the job's operations. ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_ENTITY_ID") in Pac

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