My Oracle Support Banner

Fusion Global HCM: HCM Extracts FAQ and Troubleshooting Guide (Doc ID 1637638.1)

Last updated on JUNE 03, 2021

Applies to:

Oracle Fusion Talent Review Cloud Service - Version and later
Oracle Fusion Global Payroll Interface - Version and later
Oracle Fusion Benefits - Version and later
Oracle Fusion Payroll Interface Cloud Service - Version and later
Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.
This note was created for Release The note has been reviewed and is current for release


The purpose of this document is to provide guidance to Fusion support engineers to troubleshoot issues related to Human Capital Management (HCM) Extracts.

Questions and Answers

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
Questions and Answers
 General Information
 What is an HCM Extract?
 Time constraints
 Existing documentation on Setup and Delivery Options
 Seeded Extract vs Copy
 What seeded Extracts should not be copied?
 How does patching effect seeded and custom HCM Extracts?
 Security roles
 What security roles are needed to create, view, update, delete and run HCM Extracts
 Does HCM Extract take into account application user security?
 UEs and DBIs
 Which User Entities (UEs) and Database Items (DBIs) to use?
 Extract Output
 How to archive extract files in SFTP folder generated by HCM Extract?
 How long the output files are available to be used after being extracted?
 How to add incremental sequence in each extract?
 Scheduling an Extract
 How to schedule an Extract?
 How to Set Up Multi-threading
 Extract is In Progress status after scheduled maintenance
 How to cancel scheduled Extract which is in 'Error' or 'In Progress' status?
 What happens to extract schedule during patching and planned downtime?
 Oracle Support does not provide custom HCM Extract code
 Where to view the log file
 How to turn on logging parameters GMFZT
 How to Export / Import Extract definition
 Extract fails - how to troubleshoot?
 Troubleshooting with the Design and Runtime Diagnostics
 Extract without delivery option fails
 Error: ORA-01555: Snapshot too old: rollback segment number 100 with name "_SYSSMU101_3929734814$" too small
 Error: ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #15
 ADF_FACES-60097 when submit the HCM Extract through the Data Exchange Menu
 Extract has poor performance
 Common Extract Issues
 Extract completed but output files are not generated, empty or cannot be viewed
 Extract completes successfully but XML is empty
 Extract runs successfully, user unable to view the output section and the output file
 Extract completes but output file has incorrect data
 Extract runs successfully but XML output does not retrieve few attributes
 Extract runs to Success but XML contains duplicate rows
 Changes only extract is generating a full file instead of changes only
 Extract in incremental mode picking up all element entries of employee instead of updated element entries of that employee
 Extract output has element entries attached to the wrong assignment
 CHANGES_ONLY extract with 'Changed and Marked Attribute' Option returns all attributes
 Extract fails with error
 Error: 'Extract definition invalid' and 'the root block is not linked to the hierarchy'
 Extract fails after an upgrade with error 'Formula EXT_VERT_FUSION_TO_EBS_HR_ASG_RECORD300000001333432_300000001333432 cannot be executed because it is not compiled'
 Extract runs for one employee but fails when submitted for all employees 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small'
 Extract completes successfully - how to view the output in BIP server?
 Delivery options gotchas
 Configure the server
 Important settings - Gotchas
 Delivery Option: PDF
 Delivery Option: E-mail
 Delivery Option: SFTP
 Delivery Option: CSV - file does not get produced
 Extract file generated in .CSV extension is not giving correct format output
 Extract runs into error after attaching Delivery Option
 a) Path or Template name
 b) Incompatible Output Types
 c) Modified Global Reports Data Model
 d) Security Settings
 If none of the extracts, processes and reports are running
 What if you still face the issue

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