'Planning Data Pull Worker' Fails With ORA-12801 Error While Pulling Data From MRP_AP_HARD_RESERVATIONS_V (Doc ID 2988061.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Symptoms

When attempting to run complete refresh data collections, Planning Data Pull Worker fails with the following error:

Nav: Advanced Supply Chain Planning (R) -> Collections -> Oracle Systems -> Standard Collections -> Enter the parameters and Click on Submit

30-SEP 05:19:32 : Procedure MSC_CL_DEMAND_PULL.LOAD_HARD_RESERVATION started.
30-SEP 11:38:20 : Error pulling data from MRP_AP_HARD_RESERVATIONS_V to MSC_ST_RESERVATIONS.
30-SEP 11:38:20 : ORA-12801: error signaled in parallel query server P003, instance lx03031.xxxxxxx.net:CSBP6092 (2)
ORA-01555: snapshot too old: rollback segment number 387 with name "_SYSSMU387_4202801906$" too small
30-SEP 11:38:20 : ORA-12801: error signaled in parallel query server P003, instance lx03031.xxxxxxx.net:CSBP6092 (2)
ORA-01555: snapshot too old: rollback segment number 387 with name "_SYSSMU387_4202801906$" too small
30-SEP 11:38:20 : Error_Stack...
30-SEP 11:38:20 : ORA-12801: error signaled in parallel query server P003, instance lx03031.xxxxxxx.net:CSBP6092 (2)
ORA-01555: snapshot too old: rollback segment number 387 with name "_SYSSMU387_4202801906$" too small
ORA-06512: at "APPS.MSC_CL_PULL", line 7048
ORA-06512: at "APPS.MSC_CL_PULL", line 7025
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1355
ORA-06512: at "APPS.MSC_CL_PULL", line 6354

30-SEP 11:38:20 : Error_Backtrace...
30-SEP 11:38:20 : ORA-06512: at "APPS.MSC_CL_PULL", line 7048
ORA-06512: at "APPS.MSC_CL_PULL", line 7025
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1355
ORA-06512: at "APPS.MSC_CL_PULL", line 6354
ORA-06512: at "APPS.MSC_CL_PULL", line 1825

Cause

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