My Oracle Support Banner

BUE: ORA-01400: cannot insert NULL into ("AHL"."AHL_APPLICABLE_MRS1"."REPETITIVE_FLAG") in Package AHL_UMP_ProcessUnit_PVT Procedure Process_Unit_PVT (Doc ID 2007529.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

When attempting to run the Build Unit Effectivities (BUE) program as a part of the Preventive Maintenance process to create service requests and task based on service contract schedules, the program fails with the following error


ERROR
ORA-01400: cannot insert NULL into ("AHL"."AHL_APPLICABLE_MRS1"."REPETITIVE_FLAG") in Package AHL_UMP_ProcessUnit_PVT Procedure Process_Unit_PVT


STEPS
1. Responsibility : Preventive Maintenance
2. Navigate to Reports and Programs / Building Unit Effectivities
3. Select a maintenance requirement or contract number and submit the program (AHLPMUEFF module: Building Unit Effectivities (Preventive Maintenance) )


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.