Extract Data For Oracle Supply Chain Planning Cloud In Net Change Mode Is Taking Longer
(Doc ID 2742160.1)
Last updated on JULY 05, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.8 version, Data Collections
ACTUAL BEHAVIOR
---------------
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:
d8vp7sx3xkffd
SELECT *
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)
EXPECTED BEHAVIOR
-----------------------
In target mode it is taking an hour, it should finish around the same time also with net change mode.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |