Extract Data For Oracle Supply Chain Planning Cloud In Net Change Mode Is Taking Longer
(Doc ID 2742160.1)
Last updated on JANUARY 07, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.8 and later
Information in this document applies to any platform.
On : 12.2.8 version, Data Collections
Extract data for Oracle Supply Chain Planning Cloud in Net Change Mode is taking Longer
The Extract data for Oracle Supply Chain Planning Cloud in Net Change Mode is taking Longer almost 24 hours to complete. The long running SQL is:
FROM MSC_ADCL_DEMAND_FORECASTS_V WHERE organization_code IN (select mp.organization_code org_code from msc_instance_orgs ins , mtl_parameters mp where ins.organization_id=mp.organization_id and ins.enabled_flag=1 and ins.sr_instance_id = 21 ) AND (RN0 > 754177009 OR RN1 > 754177009)
In target mode it is taking an hour, it should finish around the same time also with net change mode.
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