Preventive maintenance Work Orders are not getting generated ORA-01403 in CST_EamJob_PUB (Doc ID 344895.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 11.5.8 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance 27-APR-2015***

Goal

When attempting to generate PM work orders based on a cut off date the following error occurs:

PM Suggestion Date=2006-03-18 00:00:00.0
RunningContext Start Date=2005-12-11 00:00:00.0

Error message:The entity with header id (1) generated the following error(s).

In EAMPMSDU module: Generate Preventive Maintenance Work Orders (log file)
when no work orders are generated when the cut off date within undefined GL periods:
ORA-01403: no data found in Package CST_EamJob_PUB Procedure Compute_Job_Estimate : l_stmt_num - 35

 

Solution

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