My Oracle Support Banner

Data Extraction Worker For PRICE_LIST Is Failing With ORA-01555 After Running a Long Time (Doc ID 2887252.1)

Last updated on AUGUST 02, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

Data extraction worker for PRICE_LIST is failing in ERROR with following message.


ERROR
-----------------------
MSC_APCL_UTIL.ENTITY_PRE_PROCESS Error:ORA-12801: error signaled in parallel query server P002, instance locphxedvm-wliii1:EBSSCDB1 (1)
MSC_APCL_UTIL.ENTITY_PRE_PROCESS Error:ORA-12801: error signaled in parallel query server P002, instance locphxedvm-wliii1:EBSSCDB1 (1)
ORA-06512: at "APPS.MSC_APCL_DM_EXTRACT", line 4260
ORA-01555: snapshot too old: rollback segment number 830 with name "_SYSSMU830_3033504568$" too small
ORA-06512: at "APPS.MSC_APCL_DM_EXTRACT", line 4229

STEPS
-----------------------
1.  Responsibility:  Advanced Supply Chain Planner
2.  Navigation:  Other > Requests > Submit a New Request
3.  In the Name field, select 'Extract data for Oracle Supply Chain Planning Cloud'
4.  Ensure that the Price List parameter is set to Yes

 

Cause

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
Symptoms
Cause
Solution
References


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