Fusion Global HCM: HCM Extracts FAQ and Troubleshooting Guide
(Doc ID 1637638.1)
Last updated on MARCH 18, 2024
Applies to:
Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.07.0 and laterOracle Fusion Payroll Interface Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Payroll - Version 11.1.9.2.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.5.0.0. The note has been reviewed and is current for release 11.13.20.07.0.
Purpose
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
Purpose |
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? |
How to find the PAYROLL_ACTION_ID for extracts that rolled back? |
Troubleshooting |
Troubleshooting with the Design and Runtime Diagnostics |
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 |
References |