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 SEPTEMBER 06, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms