Download Plan Scenario Fails With Error ORA-00942
Last updated on MARCH 07, 2018
Applies to:Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
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.
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
The issue can be reproduced at will with the following steps:
1.Run 'Download Plan Scenario' workflow
2. See the error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms