Rapid Planning Supply Demand Query For Ineligible Orders Does Not Return All Orders (Doc ID 2127504.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Rapid Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Planning Engine in CRP

Users are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 19549533 - key RP files

$$Header: engine.zip 120.134.12020000.116 2015/10/30 01:49 ruijia ship $
$Header: RPAdmin.zip 120.5 2009/12/22 23:12 nyellank ship $
$Header: RPUIDomainTemplate.zip 120.0.12020000.2 2013/08/23 05:50 $
$$Header: ui.zip 120.206.12020000.107 2015/10/29 02:12 zhtian ship

Users are not getting all status = ineligible rows to show up in Supply Demand view. Users Searched in RP UI for a given plan as follows
Organization = UBD:WEI org id = 85
Order Type = Work order
Release Status = Ineligible
They run this query and this exported 16 rows

Now they query with
Item = T07-0533 (item id = 75671
Organization = UBD:WEI org id = 85
Order Type = Work order
Release Status = Ineligible
They run this query and it returns a row. However this item/work order did not show in the output of the previous query abvove

The UI logs don't show anything helpful. Couldn't find any research hits to help either


EXPECTED BEHAVIOR
-----------------------
Expect all rows to be shown in the query for ineligible work orders


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open plan in RP UI
2. Query general data and get rows returned
3. Query with more specific criteria and row is returned that did not show in the previous query

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