The Historical Data In The Forecasting Tables Are Not Getting Cleared
Last updated on MARCH 16, 2017
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.
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