MPS Build Plan - Material Plan Does Not Display All Items In The Assembly Item Pick List (Doc ID 2834814.1)

Last updated on JANUARY 26, 2022

Applies to:

Symptoms

12.2.10

PlanningUIEar.zip 120.1.12020000.203

PROBLEM
-------------
Items missing in lookup for Assembly items in Build Plan - Material Plan

STEPS
--------
1. ASCP / Supply Chain Plan / Supply Planning Work Area (SPWA)
2. Choose Plan
3. Click Build Plan
4. In Material Plan, click Assembly item lookup and query all - get only 2 items, do not choose any and close lookup
5. Click Arrow and all 26 item/org combinations in this small test plan appear under Material Plan window and resource window also populates

EXPECTED BEHAVIOR
----------------------------
Able to choose any Assembly item in the plan via the Assembly Item lookup

Generated trace using steps from <Note 2049195.1>
The following fetches 2 rows

PARSING IN CURSOR #140174802465256 len=492 dep=0 uid=173 oct=3 lid=173 tim=16314406906020 hv=3432175439 ad='6120d208' sqlid='5t72w2g695pug'
SELECT * FROM (select distinct ic.sr_instance_id,
  ic.sr_category_id category_id, ic.category_name,
  i.inventory_item_id, i.item_name, i.description
from msc_item_categories ic, msc_system_items i
where i.plan_id = 1022 --Bind#0 value=1022 :bndPlanId
  and ic.category_set_id = 3001 --- Bind#1 VALUE=3001 :bndCategorySetId
  and i.sr_instance_id = ic.sr_instance_id
  and i.inventory_item_id = ic.inventory_item_id
  and i.organization_id = ic.organization_id) QRSLT WHERE ((1=1 and category_name in ('BUY.'))) ORDER BY item_name
..
LINE 32468
FETCH #140174802465256:c=206830,e=207290,p=2,cr=75889,cu=0,mis=0,r=2,dep=0,og=1,plh=766845424,tim=16314407121789

Cause

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