My Oracle Support Banner

FAPPS: Demand Management: Demand Plan Is Completing In Warning (Doc ID 2597516.1)

Last updated on DECEMBER 02, 2019

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.18.05.0 to 11.13.19.04.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms



Demand Plan is completed in warning

ERROR
-----------------------
ERROR: Manager failed for all profiles. See reported errors below, last one most significant
- Running in Net change mode on All population - - Query validation failed: Proport table validation failed. No active combinations Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( select * from MSC_DATA_585131_DYD where ship_forecast_status = 1 and rownum=1 ) - Query validation failed: Proport table validation failed. No active combinations Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( select * from MSC_DATA_585131_DYD where ship_forecast_status = 1 and rownum=1 ) - Running in Net change mode on All population - - Query validation failed: Proport table validation failed. No active combinations Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( select * from MSC_DATA_585131_DYD where book_forecast_status = 1 and rownum=1 ) - Query validation failed: Proport table validation failed. No active combinations Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( select * from MSC_DATA_585131_DYD where book_forecast_status = 1 and rownum=1 ) -
10/03/2019 11:13:57.920 - releaseConnection() - released connection from AM: weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@48d2f12f
10/03/2019 11:13:57.921 - releaseConnection() - Releasing AM: oracle.apps.scm.advancedPlanning.planningAnalytics.dmEngineManagerPublicModel.publicModel.applicationModule.dmEngineManagerAMImpl@27ded7e6


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
>Create and Run demand plan
Getting above error.




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.