The Historical Data In The Forecasting Tables Are Not Getting Cleared
(Doc ID 2243954.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
A forecasting tool generates thousand lines of forecast daily. This is in addition to normal
forecasting done by the planners . As a result, the size of the seeded table has been increasing
and can potentially impacting performance. When the users exit the Maintenance Workbench,
the data in the temp table is not automatically deleted. This is standard behavior that is not working.
Wen exiting Maintenance Workbench, the data should automatically be deleted.
The issue can be reproduced at will with the following steps:
1. Run forecast tool or forecasting via the planner.
2. Run Maintenance workbench and exit.
3. The temp table (eam_forecasted_work_orders_v) data is not automatically deleted once the user exits.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document