The Historical Data In The Forecasting Tables Are Not Getting Cleared (Doc ID 2243954.1)

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.

Symptoms


ACTUAL BEHAVIOR

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.

EXPECTED BEHAVIOR

Wen exiting Maintenance Workbench, the data should automatically be deleted.

STEPS

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.

Cause

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