My Oracle Support Banner

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:

Oracle Advanced Supply Chain Planning - Version to 12.2.10 [Release 12.2]
Information in this document applies to any platform.


12.2.10 120.1.12020000.203

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

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

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


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

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