Compile ABC analysis Concurrent Program (INCAAC) Failing with Error 'ORA-01555: snapshot too old'

(Doc ID 1998071.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Concurrent: INCAAC - Compile ABC analysis
Concurrent: INCAAP - Purge ABC information

Symptoms

Compile ABC analysis concurrent program (INCAAC) completes with Error and with the following message in the request log.

ERROR
----------------------------------------
[
ERROR = ORA-01555: snapshot too old: rollback segment number 1 with name "_SYS
SQL = insert into MTL_ABC_COMPILES(INVENTORY_ITEM_ID,ORGANIZATION_ID,INVENTO
]

STEPS
----------------------------------------
The issue can be reproduced at will with the following steps:
1. Go to Inventory: (N) Request : Run
2. Select Program 'Compile ABC analysis'
3. Submit

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