My Oracle Support Banner

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

Last updated on AUGUST 18, 2018

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.