My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2019

Applies to:

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



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.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.