In Plan Options - Demand Schedules - Cannot Choose Item Level Ship To Consumption For A Demantra Scenario In SPP (Doc ID 2239352.1)

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.

Symptoms

12.2.5

PROBLEM
-------------
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

EXPECTED BEHAVIOR
----------------------------
Be able to choose item level in SPP plan

BUSINESS IMPACT
----------------------
cannot consume this forecast by item in SPP

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