Fusion Extract Process is Not Writing All History Rows on Grade (Doc ID 1987602.1)

Last updated on NOVEMBER 23, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 

Not all history rows for Grade Rate are retrieved from FT_EXTRACT process.  The issue is with the SQL query.  Only a few rows are returned although the query should be returning complete history. Due to this there will be gaps in the dates of the extract for an object.

STEPS

1) Navigate to Main Menu > Workforce Administration > Collective Processes > Fusion Integration > Talent/Workforce Compensation > Send HR Data to Fusion

2) Enter any new or existing Run Control ID.

3) Select outbound configuration.

4) Run ‘Job Grade Rate’ transformation Process.

Some history rows for Grade Rate are not retrieved from FT_EXTRACT process.


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