Enterprise Asset Management - EBS (MOSC)

MOSC Banner

Create forecast program inserts records into 'EAM_FORECASTED_WORK_ORDERS' table. Any idea how record

edited Feb 28, 2019 4:14AM in Enterprise Asset Management - EBS (MOSC) 1 commentAnswered

Hi All,

Can you please throw some light on how records in EAM_FORECASTED_WORK_ORDERS gets purged?

On creating a forecast in Maintenance workbech, records get inserted in this table.

As per etrm:

"This table stores all the forecasted work orders that can be converted into actual work orders. Records in this table are created by the preventive maintenance scheduler. Records are removed when user exits the process."

In our PROD instance also this table is holding records for last 5-6 days. The records are not getting removed when user exits the process, wanted to  know the process/action purging or deleting records from this table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center