Planning ODS Load Takes Long Time Inserting Data Into MSC_SOURCING_TRANSACTIONS (Doc ID 1166063.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:MSCPDC - Planning ODS Load

***Checked for relevance on 13-Dec-2016***


Symptoms

Find that the Planning ODS Load program is taking a long time to complete. The statements taking the longest time are:

insert into MSC_SOURCING_TRANSACTIONS( INVENTORY_ITEM_ID, ORGANIZATION_ID,
SOURCE_ORG_ID, TRANSACTION_DATE, TRANSACTION_QTY, TRANSACTION_TYPE)
SELECT inventory_item_id, organization_id, source_org_id,
transaction_date, transaction_qty ,2 FROM
MRP_AP_INTER_ORG_TRXS_V@APSPRD_PRD x where x.inventory_item_id is not
null

insert into MSC_SOURCING_TRANSACTIONS( INVENTORY_ITEM_ID, ORGANIZATION_ID,
TRANSACTION_DATE, TRANSACTION_QTY, TRANSACTION_TYPE) SELECT
inventory_item_id, organization_id, transaction_date,
transaction_qty , 1 FROM MRP_AP_INNER_ORG_TRXS_V@APSPRD_PRD x where
x.inventory_item_id is not null

insert into MSC_SOURCING_TRANSACTIONS( INVENTORY_ITEM_ID, SUPPLIER_ID,
SUPPLIER_SITE_ID, TRANSACTION_DATE, TRANSACTION_QTY, TRANSACTION_TYPE)
SELECT inventory_item_id, SUPPLIER_ID,nvl(SUPPLIER_SITE_ID,-1),
transaction_date, transaction_qty ,3 FROM
MRP_AP_PO_SUPPLIER_TRXS_V@APSPRD_PRD x where x.inventory_item_id is not
null

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