Planning Data Pull Worker Takes a Long Time and Then Fails with ORA-01555 Pulling Data From MRP_AN2_SALES_ORDERS_V (Doc ID 2879609.1)

Last updated on DECEMBER 02, 2023

Applies to:

Symptoms

On : 12.2.10 version, Data Collections

Planning Data Pull Worker is taking a long time to complete and eventually failing with the following error

ERROR
-----------------------
13-JUN 07:57:11 : Coming here :40820194
13-JUN 11:36:21 : Error pulling data from MRP_AN2_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
13-JUN 11:36:21 : Error_Stack...
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
ORA-06512: at "APPS.MSC_CL_PULL", line 7045
ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-02063: preceding line from ASCPPROD_TO_ERPPROD.US.ORACLE.COM
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1090
ORA-06512: at "APPS.MSC_CL_PULL", line 6236

13-JUN 11:36:21 : Error_Backtrace...
13-JUN 11:36:21 : ORA-06512: at "APPS.MSC_CL_PULL", line 7045
ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1090
ORA-06512: at "APPS.MSC_CL_PULL", line 6236
ORA-06512: at "APPS.MSC_CL_PULL", line 1825

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility:  Advanced Supply Chain Planner
2. Navigation:  Collections > Oracle Systems > Standard Collection
3. Enter the parameters for the Planning Data Pull and Planning ODS Load concurrent programs
4. Submit the request

Cause

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