My Oracle Support Banner

CMRO-VWP Update Material Schedule Error: ORA-01400: cannot insert NULL (Doc ID 2602828.1)

Last updated on OCTOBER 29, 2019

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Visit Work Package

ACTUAL BEHAVIOR
---------------
Update VWP material Schedule return error:
Error: ORA-01400: cannot insert NULL into ("AHL"."AHL_WO_OPERATIONS_TXNS"."WORKORDER_OPERATION_ID") in Package AHL_PP_MATERIALS_PVT Procedure UPDATE_MATERIAL_REQST

EXPECTED BEHAVIOR
-----------------------
Expect not to get error when updating VWP material Schedule

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Route Disposition List
2.Create MR, associate Route
3. Create VWP, Associate MR to VWP.
4. Plan Visit Update Schedule Quantity, Return Error:Error: ORA-01400

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.