My Oracle Support Banner

Query validation failed: Proport table validation failed. No active combinations Expecting: 1, Got: 0 (Doc ID 2434636.1)

Last updated on DECEMBER 03, 2018

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

S&OP Plan failing at Child Job Start Demand Planning Engine Manager


ERROR
08/06/2018 7:46:04.551 - Arguments - planId: 300000022693270,execution ID: 300000028967098, profiles: 6731,4731, filters: 0, Refresh Option: 1, refreshOptionList: 0#WDC=0#WDM=0, request ID: 296122, Priority Base: 1, Version: 4.27
08/06/2018 7:46:04.552 - VO PARAMETERS ARE: null - null - null - null
getDBConnection: Start
Successfully created root application module
getDBConnection: End
08/06/2018 7:46:04.626 - getOverides() - Returned overides:
08/06/2018 7:46:04.632 - After getting service connection
08/06/2018 7:46:04.636 - Got manager service obj
08/06/2018 7:46:04.637 - Service returned: oracle.j2ee.ws.client.jaxws.WsClientProxyInvocationHandler@293e0387
08/06/2018 7:46:04.638 - Got service method for method:updateEngineRunDate, parameters: [Ljava.lang.Class;@2659a938, servicemethod: public final int com.sun.proxy.$Proxy653.updateEngineRunDate(long,int,java.lang.String) throws oracle.jbo.service.errors.ServiceException
08/06/2018 7:46:04.987 - Service invoked, returning: :1
08/06/2018 7:46:05.178 - UpdateProgress - 1, Status: 1
08/06/2018 7:46:07.969 - Run plan returned:: #Version=4.27#Status=ERROR#Branches=-1#Code=428#SetID=0#Tables=MSC_DATA_17012_DYD#Message=Running in Full mode on All population - - Refresh selected - Query validation failed: Proport table validation failed. No active combinations Expecting: 1, Got: 0, Bind Variables: [], SQL: select count(*) from ( select * from MSC_DATA_17014_DYD where ship_forecast_status = 1 and rownum=1 ) - Divider query retrieved no tasks (rows). SQL : SELECT COUNT(*), L_PRD_38_ID,

STEPS

1.Load Shipment History To Measure Shipments History

2.Launch S&OP Plan

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.