Last updated on MARCH 01, 2017
Applies to:Oracle Service Parts Planning - Version 12.2.5 and later
Information in this document applies to any platform.
We are publishing a Demantra Scenario to SPP as a Demand Schedule, and we are not able to select the Item level Ship to Consumption for that Demand Schedule.
We are only given the options for Demand Class, Customer Class, and Customer.
For the same Demand Schedule in ASCP we can select Item. We are able to select Item level Ship to for other Demantra Schedules in SPP.
Trace shows that form determines internally which levels are available and then sends query to lookup with variables/values to retrieve.
in ZIP file - Trace_Files.zip
we see steps and options in Trace Files.pptx
and for ASCP - in file - eraps3d_ora_15732_502679353_0215_134552.trc
select lookup_code,substr(meaning,1,100) meaning from fnd_lookups where lookup_type = 'MSC_SHIP_TO' and lookup_code in (6,4,10,7)
in SPP in file - eraps3d_ora_24463_502679353_0215_132652.trc
select lookup_code,substr(meaning,1,100) meaning from fnd_lookups where lookup_type = 'MSC_SHIP_TO' and lookup_code in (:1, :2, :3)
binds are 4, 9, 10
Be able to choose item level in SPP plan
cannot consume this forecast by item in SPP
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms