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 SEPTEMBER 26, 2023
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.
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
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
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