The Program Extract Data for Oracle Supply Chain Planning Cloud is Hanging While Extracting Sales Order Booking And Shipping Data (Doc ID 2976111.1)

Last updated on DECEMBER 15, 2023

Applies to:

Symptoms

The Program "Extract data for Oracle Supply Chain Planning Cloud " Running Longer

NAV: Advanced Planning Administrator(R) - /View / Requests / Submit a new request -- choose "Extract data for Oracle Supply Chain Planning Cloud" and set parameters for Shipment and Booking History Entity and launch.
It never completed, even after 2 days.

Ran SQL from Note 280295.1 - 8. Longops_check.sql - Good for monitoring long running SQL session where single SQL ID is taking time OR finding long running SQL on system

Ran SQL for 3 different attempts and SQL ID was different each time.
Example output from longops
SQL_ID - 2ywur6cvsc7t5
REMAIN MINS 8287.8
ELAPSED MINS 478.22
TOTAL MINS 8766.02
%_COMPLETE 5.46
MESSAGE - Table Scan: INV.MTL_SYSTEM_ITEMS_B: 69609 out of 1275977 Blocks done

Standard RDBMS AWR did not capture the SQL in SQL statistics as expected, it appeared only in ASH report section where it suggests to run DBMS_SQLTUNE, And this diagnostic could not find the SQL_ID

Cause

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