Download Plan Scenario Fails With Error ORA-00942 (Doc ID 1188713.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms


On : 7.3.0 version, LoadData

Workflow, 'Download Plan Scenario' fails with error.

Though the workflow fails, the data is properly stored in supply_plan table.


ERROR
FATAL workflow.general: ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CORE_LOG", line 45
ORA-06512: at "APPS.FND_CORE_LOG", line 456
ORA-06512: at "APPS.FND_PROFILE", line 110
ORA-06512: at "APPS.MSD_DEM_COMMON_UTILITIES", line 51
ORA-06512: at "APPS.MSD_DEM_SOP", line 6
ORA-06512: at line 1


STEPS
The issue can be reproduced at will with the following steps:
1.Run 'Download Plan Scenario' workflow

2. See the error.

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