EMM: Maintenance Management Preventive Maintenance Process Error - Cannot Insert Value NULL Into Column PJC_DAYS (Doc ID 2097061.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the Maintenance Management Preventive Maintenance process (WM_PM) the following error occurs.

ORACLE:
ORA-01407: cannot update ("EMDBO"."PS_WM_PM_MTR_TAO4". "PJC_DAYS") to NULL

SQL SERVER:
SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'PJC_DAYS', table 'FIDEV.dbo.PS_WM_PM_MTR_TAO4'; column does not allow nulls. UPDATE fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement Failed
SQL stmt:
UPDATE PS_WM_PM_MTR_TAO4
SET NEXT_RDG = LAST_WO_RDG + INTERVAL_MTR,
PERCENT_DUE = ABS(ROUND(((((100.0000) * (CURRENT_RDG - LAST_WO_RDG))) / (INTERVAL_MTR)),0)),
PJC_DAYS = DATE DIFF(DAY,DATE_FROM,{fn CURDATE()}),
NEXT_DUE_DT = DATEADD(DAY,(DATEDIFF(DAY,DATE_FROM,{fn CURDATE()}) / ABS(ROUND(((((100.0000) * (CURRENT_RDG - LAST_WO_RDG))) / (INTERVAL_MTR)),0)) * 10


REPLICATION STEPS
1. Go to AM > Service & Maintenance > Asset Meter Information > Establish Meter Reading.
2. Select BU US001, Asset 000000100L01. Establish meter for an asset. Add an initial Meter Reading.
3. Go to MM > Preventive Maintenance > PM Schedule Management Setup > Schedule. Create a PM Schedule Id for the asset with Meter Reading.
4. Run the Preventive Maintenance (PM) process and check that the PM Work Order (WO) is created successfully.
5. Retire the asset. Click "Go" and "Save".
6. Create a new Meter Reading entry:
         a. enter Meter Reading against the created PM WO
         b. enter another Meter Reading entry.
7. Create a PM Schedule for another valid In Service Asset with meter information.
8. Run the WM_PM Preventive Maintenance process for both PM schedules at the same time.
9. The PM process finishes with error: ORA-01407: cannot update ("EMDBO"."PS_WM_PM_MTR_TAO4". "PJC_DAYS") to NULL.

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