R12 : Customer Interface (RACUST) Ends with Error - ORA-01555: Snapshot Too Old: Rollback Segment Number 2 (Doc ID 1600379.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to run Customer Interface and it completes with the following error:

ORA-01555: snapshot too old: rollback segment number 2

Concurrent Log
---------------------------------------------------------------------------
Receivables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RACUST module: Customer Interface
---------------------------------------------------------------------------
Current system time is 20-SEP-2013  05:26:07
---------------------------------------------------------------------------
>>racudc: updating customers.
Current system time is 20-SEP-2013  05:26:57
racudc: updated 85 partiesracudc: Partyrel 1 parties
racudc: ORA-01555: snapshot too old: rollback segment number 2
racudc: Error updating customers.
Current system time is 20-SEP-2013  07:16:18
---------------------------------------------------------------------------

Alert Log:
---------------------
Fri Sep 20 06:37:56 2013
ORA-01555 caused by SQL statement below (SQL ID: 6k6z7pcjy1v44, Query Duration=4242 sec, SCN: 0x0004.7d3a8e9a):
INSERT INTO HZ_PERSON_PROFILES ( PERSON_PROFILE_ID , PARTY_ID , PERSON_NAME , LAST_UPDATED_BY , CREATION_DATE , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , CREATED_BY , LAST_UPDATE_DATE , PROGRAM_ID , PROGRAM_UPDATE_DATE , PERSON_FIRST_NAME , PERSON_LAST_NAME , PERSON_NAME_PHONETIC , TAX_REFERENCE , JGZZ_FISCAL_CODE , EFFECTIVE_START_DATE , CONTENT_SOURCE_TYPE , PERSON_FIRST_NAME_PHONETIC , PERSON_LAST_NAME_PHONETIC , ACTUAL_CONTENT_SOURCE , OBJECT_VERSION_NUMBER , VERSION_NUMBER ) SELECT HZ_PERSON_PROFILES_S . NEXTVAL , PER . PARTY_ID , PER . PERSON_NAME , :B5 , SYSDATE , :B4 , :B3 , :B2 , PER . CREATED_BY , SYSDATE , :B1 , SYSDATE , PER . PERSON_FIRST_NAME , PER . PERSON_LAST_NAME , PER . PERSON_NAME_PHONETIC , PER . TAX_REFERENCE , PER . JGZZ_FISCAL_CODE , SYSDATE , 'USER_ENTERED' , PER . PERSON_FIRST_NAME_PHONETIC , PER . PERSON_LAST_NAME_PHONETIC , 'SST' , 1 , NVL ( PER . VERSION_NUMBER , 1 ) + 1 FROM HZ_PERSON_PROFILES PER WHERE TRUNC ( PER . EFFECTIVE_START_DATE ) <> TO_DATE ( :B6 , 'MM/D

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