Fusion : Data Missing After an Incremental Load via File Based Loader (Doc ID 1638482.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, File Based Loader

ACTUAL BEHAVIOR
---------------
Below observations after performed FBL load from source system to Fusion, (The current load which is an incremental load through FBL and did the earlier loads through Hr2HR.)

1) Location BO: When customer load the Location Data into Fusion, Tables PER_LOCATION (Parent Table) and the PER_LOCATION_DETAILS_F_VL (Child Table) will be populated. However, in spite of us not loading LOCATION BO in the last incremental run through FBL, all the data populated before the incremental load in PER_LOCATION_DETAILS_F_VL (child table) got deleted.

2) Department BO: There were 1177 unique departments as attached in xyz pod before the incremental load, however after the incremental load, only 26 unique departments which are present in the current FBL load are present in xyz pod and the earlier departments were deleted.

The above are the observations for Location and Department details not available in the employment page for few employees.


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