Data Imported Through File Is Not Updated Into OSC (Doc ID 2235794.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Activity Management

Data imported through file import is not updated into OSC

ERROR
-----------------------
Line 232 of Process_Log_300000110903437.xls shows the following error:
DEBUG ODI STEP:Session Name: GROUPBOOKING_C(33476502) 7.Step Name:Initialize_Default_GROUPBOOKING_C Inserts:0 Updates:0 Deletes:0 Duration:1527 Errors:0 Error Message:ODI-1226: Step Initialize_Default_GROUPBOOKING_C fails after 1 attempt(s).
ODI-1240: Flow Initialize_Default_GROUPBOOKING_C fails while performing a Integration operation. This flow loads target table GROUPBOOKING_C_IMP.
ODI-1228: Task Initialize_Default_GROUPBOOKING_C (Integration) fails on the target ORACLE connection ORACLE_FUSION.
Caused By: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 92 with name "_SYSSMU92_313449145$" too small

at oracle.jdbc.driver.T4CTTI

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Sales Cloud application
2. Navigate to Setup and Maintenance > Task: Manage File Import Activities
3. Import Group Booking data

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, data is not imported as expected.

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