My Oracle Support Banner

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.

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


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