Planning Data Pull Worker Erroring With ORA-01555: Snapshot Too Old: (Doc ID 1506458.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

Launch Target Refresh Collection with PO/PR set to Yes

MSCPDPW module: Planning Data Pull Worker

Procedure LOAD_PO_PO_SUPPLY started.
Error pulling data from MRP_AP_PO_PO_SUPPLY_V to MSC_ST_SUPPLIES.
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-02063: preceding line from DP_SOURCE
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-02063: preceding line from DP_SOURCE

Location APS is Installed? Decentralized

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms