This is a master article listing all the Fusion HCM articles listed on this website. You can use these links to go through all the posts which are of interest to you. There has been lot of informative content created over the last couple of months and I will keep doing it going forward as well.
Table of Contents
Learning BI Publisher:
- How to get the return value of Table Valueset in FF from SQL Query?
- How to get the count of data loaded using HDL for business objects?
- How do we extract the Grade Ladder step rates?
- How do we reduce RTF template size when many images exist in the template?
- How to find the Lookup Type for an attribute that supports HDL load?
- How to modify the reports/value sets for Payroll table changes in 24A?
- How to resolve “Template type etext is not yet supported” error for BI Report?
- PI Cube – FREE SQL Developer-like tool for Oracle Cloud
- How to get input parameter values from the last successful run of the BI Report?
- How to fetch the changes since the last scheduled run for the BI Report?
- How to fetch Payslip XML from backend tables for a specific Pay Period
- How to fetch Balance Initialization and Adjustments for employees?
- How to fetch Payroll Run Results when employees have multiple assignments?
- How do we extract the Payslip Information for DOR tables?
- How to get the Lookup codes for a specific country and exclude the country if it’s excluded?
- How to fetch Balances without any feeds?
- How to fetch Payroll Run Results with all input values for elements?
- How to fetch Positions without Costing Information?
- What is the difference between Split By and Deliver By in BI Publisher Bursting?
- How to get the POD or Instance Name in BI Report?
- How to repeat Table Header on all pages and avoid row split into the next page in BI Publisher?
- How to display No Data Found in BI Report when there is no matching data found?
- How to fetch the current logged-in Users list?
- How to fetch the Delegated or Proxy Users?
- How to fetch Grade Ladder details and Grades in Ladder?
- How to extract Grade Rate details from backend tables?
- How to resolve FA-SAAS SQL Guardrails for Long-Running BI Reports and Queries?
- How to remove the blank line when the attribute doesn’t have value in the letter type RTF template?
- How to get the Flow Instance Name using Payroll Action ID from BI History?
- How to resolve the “The value isn’t valid for the attribute PersonId” error while loading the Element Link Costing?
- 40 Important functions that can be used with XML tags in RTF
- How to fetch Element Definition load errors using SQL Query?
- How to get the count of data loaded from multiple tables post-data conversion?
- How to resolve date values having date function getting reset after 23B update?
- How to get the Audit History of the changes done by a user?
- How to get list of Fast Formulas used in HCM Extract?
- How to generate pipe delimited output from BI Report using a dummy template?
- How to pass multiple values as default for an Input parameter in BI Report?
- How to extract the Sandbox, features enabled, and published status?
- How to fetch the Employee Degrees from the Skills and Qualifications screen?
- How to check the Approval Rule status using BI Report?
- How to get Dynamic Default for Payroll Period LOV based on the system date?
- How to extract the Element Eligibility Info from Element Config?
- How to fetch the Employee Social Insurance Calculation Card details for AE legislation?
- How to get the list of all BI Reports from an instance?
- SQL Query to fetch Costing of Payroll information
- SQL Query to fetch Costing of Persons information
- SQL query to fetch Position Costing information
- How to bulk inactivate the Document Types using HDL?
- SQL query to pull Time cards that are not approved status
- How to customize seeded payroll extracts to add additional fields?
- How to customize the seeded VETS 4212 report to add additional fields?
- How to convert Rows to Columns using etext template
- SQL query to pull the EEO Information
- SQL query to pull Absence Accruals not run as of input date
- SQL Query to pull the HDL Loaded and Error Records
- SQL Query to extract Absence Plan Configuration
- How to fetch Pension Automatic Enrollment Calculation Card Info for UK Legislation?
- How to download the Payslip XML?
- How to resolve the error with imported catalogs from the old BI version?
- How to find the version of Fusion instance and BI Publisher?
- How to add additional attributes to Payslip using Information elements?
- How to update the Final Close Date FINC on Assigned Payroll?
- How to find special characters in a column?
- How to pull UK Calculation Card Info?
- How to fetch Third Pary and Third Party Payees?
- How to extract document types for all legislations?
- How to get JSON output from BI publisher report?
- How to fetch Enterprise HCM Information?
- How to retrieve Payroll balance Initialization Errors?
- How to load Position Costing using HDL?
- How to extract the Prescreening Questions and Answers filled in by the Candidate?
- How to get the Offerings and Opt-In features in Cloud applications?
- How to extract the list of Alerts from Alert Composer?
- How to load Performance Rating and Career Potential using HDL in Talent Profiles?
- How to fetch the Tax Reporting Unit info from the Calculation Card?
- How to Migrate the Role Mappings from one instance to another using HDL?
- How to find assignments without calculation card associations?
- How to extract the City, County, State, Zip Combination Geo Codes from Vertex?
- SQL Query to extract Element Configuration Information
- SQL Query to extract Eligibility Profiles and the Eligibility Criteria
- SQL Query to fetch Absence Plan Configuration
- How to access PII Information secured using VPD from BI Report?
- SQL Query to fetch Delivery Option details for HCM Extracts
- SQL Query to find the mapping between Business Unit and Reference Data Set
- SQL Query to fetch the Learner Course Progress Report
- SQL query to fetch Payslip and W-2 delivery preferences
- SQL Query to fetch employees with missing bank account
- SQL Query to fetch Assignment Level Element Entries
- How to use the Sensitive Data Access Audit feature from 21B?
- How to Invoke BI Publisher and OTBI Analysis using Web Services?
- SQL Query to fetch HCM Data Loader Load Summary
- SQL Query to fetch Pending Job Requisitions
- SQL Query to fetch Fast Formulas used in HCM Extract
- SQL Query to fetch Recruiting Location Hierarchy
- SQL Query to get Element Costing Information
- How to pull the Payroll Elements Listing Report using SQL Query?
- How to find the contexts required for a Payroll Balance and Dimension
- SQL Query to get the User status and assignment information
- SQL Query to pull Legal Employer and Enterprise Hire Dates
Learning HCM Extracts:
- Advanced Edit not available for HCM Extracts from 24D
- How to enable Advanced Edit for HCM Extracts in 24A?
- How to query the HCM Extract Errors?
- How to get list of Fast Formulas used in HCM Extract?
- SQL Query to fetch Delivery Option details for HCM Extracts
- How to capture Vendor name in HCM Extracts post 21D update
- How to enable Error/Warning Notifications for HCM Extracts/ Payroll Flows
- Sample Flow Schedule Fast Formulas for ready reference
- Sample Extract Criteria Fast Formulas for ready reference
- HCM Extracts Infographics
- How to generate CSV output from BI Reports/HCM Extracts?
- Resolve Fast Formula not compiled issue in HCM Extracts
- Renaming HCM Extracts is a possibility from 20D
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh
- Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
- Resolve HCM Extract No data error when using bursting
- Implementing Bursting feature for HCM Extract
- HCM Extracts Design and Run Time Diagnostics Reports
- How to handle Daylight Savings timings for HCM Extract schedules
- How to handle FF not compiled error for HCM Extracts
- Passing Logged in User details to HCM Extract
- Deleted Data Report using Audit Functionality
- How to convert HCM Extract Export XML to Readable format?
- Running the latest extract version using Payroll Flow
- Hiding XML nodes in HCM Extract Output
- Payroll Flow and HCM Extracts Mapping for Payroll Module
- Achieve complex requirements using Custom Global Reports Data Model
- SQL Query to find scheduled HCM Extracts
- HCM Extracts Dynamic Output Filename guide
- Top 50 Interview questions and answers on HCM Extracts
- Fix for assertion failure error in HCM Extracts
- How to link/connect the User Entities in HCM Extracts
- How to view the output of HCM Extract run by other users?
- Most frequently used User Entities in HCM Extracts
- Using Table based Valueset when DBI is unavailable
- Basics of Changes Only Functionality in HCM Extract
- Skip Output file of HCM Extract when no data is fetched
- Scheduling and Cancelling an existing schedule of HCM Extract
- Importing Changes Only HCM Extract post 20A update
- New features in HCM Extracts in 19B release
- Configure GMFZT logging for an HCM Extract
- Resolve A system error occurred during processing in Extracts
- Basics of HCM Extracts in Fusion HCM
Learning HCM Data Loader:
- What is a Progression Grade Ladder and how to load it using HDL?
- How to load/delete the status processing rule for elements using HDL?
- How to Bulk Load Educational Establishments using HDL?
- How to resolve AdjustedFTE change on Worker HDL post 23B upgrade?
- How to load Calculation Card for US legislation?
- How to load Worker.dat with minimum objects and attributes for Non-HCM?
- How to update Element attributes/properties using PayrollElementDefinition.dat HDL?
- Resolve HDL Error: The values Element Name, LDG are not valid for the attribute ElementTypeId.
- How to load Payroll Elements using PayrollElementDetails.dat HDL?
- How to bulk inactivate the Document Types using HDL?
- How to Schedule HCM Data Loader HDL Files?
- SQL Query to pull the HDL Loaded and Error Records
- How to load Time Card Required Flag on the Payroll Relationship screen using HDL?
- How to load and delete AssignedPayroll information using HDL?
- How to load Pipeline Requisitions using HDL?
- How to set field values to NULL using HSDL?
- How to modify the Person Number after hiring the employee?
- How to delete Calculation Cards using HDL?
- How to resolve HDL Error – HRC-1035375A Connection To The WebCenter Content Server Couldnt Be Established?
- How to load Element Entry and Costing Info using ElementEntryWithCosting HDL file?
- Comparison of HDL, HSDL, and APIs for Data Load
- SQL Query to fetch HCM Data Loader Load Summary
- Have you used HCM Data Loader Dashboard?
- How to load Payroll Balance Definition using HDL?
- We can still load ElementEntry business object using PBL till 22A
- How to add SET commands in HDL file using HDL Transformation Formula?
- How to Scramble the Salary information post P2T Refresh?
- How to update Termination Record using HDL?
- How to Reverse Terminate employees using HDL?
- How to Convert Pending Worker to Employee using HDL?
- Ready to use Worker Sample HDL files for multiple scenarios
- How to load Global and Local Names using HDL?
- Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
- HCM Data Loader Error Report
- HDL Transformation Formula using HSDL Template for UDT Load
- HDL transformation Formula Flow changes in 20C
- How to use escape and new line characters in HDL file
- How HDL Transformation Formula works with ElementEntry Sample
- Basics of HDL Transformation Formula Part 1
- How to ROLLBACK Element Entry HDL Load?
- Top 50 HCM Data Loader Interview Questions
- Update Source Keys using HDL for business objects
- How to send/stop welcome email notifications to users using HDL
- Invoke HCM Data Loader using SOAP Service
- SQL Query to get Scheduled Process Job History
- Useful Excel to HDL DAT File Converter
- Resolving Assignment Name and Job Name not in sync issue
- Generate HDL file for failed business object Lines
- New Deadline for Payroll Batch Loader 20D Nov 2020
- Sample HCM Data Loader (HDL) files for all Business Objects
- Cancel an existing Work Relationship using HDL for employees
- SQL Query to get Supervisor Change HDL for Assignment
- SET Operations on HDL file in Fusion
- Defining Source System Owner for HCM Data Loader
- Configuring HCM Data Loader Parameters
- How to load CostAllocationAccountV3.dat HDL file?
Learning Fast Formula:
- How to get the return value of Table Valueset in FF from SQL Query?
- How to fetch the Contexts required for DBIs in Fast Formula?
- We can still load ElementEntry business object using PBL till 22A
- How to add SET commands in HDL file using HDL Transformation Formula?
- Sample Flow Schedule Fast Formulas for ready reference
- Sample Extract Criteria Fast Formulas for ready reference
- Sample Extract Rule Fast Formulas for ready reference
- PBL to HDL Transformation Formula running to Error from 20D or 21A
- HDL Transformation Formula Samples for Multiple Business Objects
- Passing Parameter values from Flow Instance to HDL Transformation Formula
- Automated Parallel Processing technique for BI Report
- HDL Transformation Formula Skip Header Record
- HDL Transformation Formula, User Defined Table(UDT) Load
- HDL transformation Formula Flow changes in 20C
- PBL to HDL Migration without custom HDL Fast Formula
- Basics of HDL Transformation Formula Part 1
- Bulk Compile Fast Formulas in Fusion
- Using Flow Schedule Fast Formula to Schedule Extracts
- Redesigning PBL to HDL Transformation Formula
Learning Personalization’s:
- How to Change Label Text using User Interface Text Feature?
- How to use EL Expressions to conditionally display/hide fields/icons in Fusion HCM?
- SQL Query to fetch Descriptive Flexfield information from an instance
- Accessing Payroll Process Configuration task
- Introduction to User Defined Table (UDT) in Fusion HCM
- Using Aggregate functions in Table based Valueset
- How to bulk load Profile Option values?
- SQL Query to get the Valueset and Lookup Values
- Basics of Valuesets in Fusion HCM
- Basics of Flexfields in Fusion HCM
- Enabling Audit for Business Objects in Fusion Applications
Learning OTBI Analytics:
- Want to learn Oracle OTBI Reporting?
- How to view the OTBI Usage and Performance Metrics?
- Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
- Information on Subject Areas and List of Seeded BI/OTBI Reports
- Troubleshoot OTBI by identifying Physical SQL Query behind it
- OTBI Subject Areas to Table Field Mapping
- Migration of Objects – OTBI Analytics
- OTBI Direct Database Query feature removal and fix Obsolete
- How to access flexfields in OTBI Subject Areas?
- SQL to fetch 200+ rows – Direct Database Query – Obsolete
Learning Security:
- How to fetch Person Security Profile Config info?
- How to fetch the data role and attached security profiles?
- How to Migrate the Role Mappings from one instance to another using HDL?
- How to resolve HDL Error – HRC-1035375A Connection To The WebCenter Content Server Couldnt Be Established?
- How to access PII Information secured using VPD from BI Report?
- SQL Query to fetch Data Roles and Security Profiles
- How to modify the Welcome Email Notification for new users?
- How to Mask Work Email Address in Dev or Test instance post P2T Refresh
- New Features for Security Console in 21B
- Importance of User and Role Access Audit Report
- How to create Data Role based on Job Role
- Extend Password Expiration Date for Integration User Accounts
- Applying Fusion Application Data Security to BI Publisher Reports
- SQL Query to fetch IP Ranges setup for LBAC
- Limitations/issues faced with LBAC
- How to disable Single Sign-on or LBAC option?
- Using Role Mappings and Auto-provisioning Rules
- Making a user read-only using Administrator Profile Values
- Enabling Location Based Access Control (LBAC)
Learning Scheduled Processes:
- What does Reconcile Integration Keys for Oracle Fusion Objects process do?
- HCM Extracts Design and Run Time Diagnostics Reports
- Bulk load Roles to Users using HDL
- How to send/stop welcome email notifications to users using HDL
- Refresh Manager Hierarchy Process in Fusion HCM
- List of tables which are impacted by Scheduled Processes
- Important scheduled processes and their usage?
- Accessing flexfields in OTBI Analytics
- Generate flexfield database items
- Importance of Update Person Search Keywords Process
Learning Web Services:
- Invoke HCM Data Loader using SOAP Service
- Most frequently used WSDL/End Points for Web Services
- REST APIs to load, get, update and reset password for users
- SOAP Services for performing file operations in UCM
Learning Other Features:
- How to get the list of all files in a folder as well as sub-folders in Windows?
- How to load Worker.dat with minimum objects and attributes for Non-HCM?
- How to Audit Configure HCM Data Loader parameters?
- SQL query to pull Time cards that are not approved status
- Byte Sized learning videos by Oracle from 22D
- How to find special characters in a column?
- How to roll back the Balance Initialization process?
- How to pull UK Calculation Card Info?
- How to get the list of all HDL Business Objects and child Objects
- How to Convert Numbers to Text in BI Report using RTF?
- How to create custom alerts using Alert Composer?
- Cloud Customer Connect moved to Oracle Communities
- Introducing Fusion HCM KB Tools on Oracle APEX
- Sample Extract Criteria Fast Formulas for ready reference
- Payroll Element Entry Table Relationships ERD
- Core HR Workforce Structures Table Relationships
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
- Sangam20 Oracle Users Group Conference
- Oracle HCM Cloud Quick links for essential functionality
- SQL Developer like Tool for Oracle Cloud, That too for FREE
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- SQL Query to get the Flattened User Defined Table (UDT) Information
- Areas of Responsibility (AOR), Its usage, Data Load and Report
- Payroll Actions and their usage in Fusion
- Bulk load Roles to Users using HDL
- Bypass the FROM Clause limit in Table based Valueset
- Legal Employer and Enterprise Service Dates in Fusion
- Difference between PER_ALL_ASSIGNMENTS_M and _F tables
- FREE Oracle Fusion Demo Instance (VISION) Access
- Setting default preferences for all users and overriding them
- Top 10 FREE useful tools for Fusion Consultants
- Important Oracle documentation links for Fusion HCM
- Hiding input parameters on BI report
- Learning Fusion HCM Technical Skillset
- Modified Task/Action Names in Fusion HCM 20A
- Configuring Payroll Process Configuration Groups
- Use Utility to Upload, Download and Delete files from UCM
- Introduction of Cloud Customer Connect Forum
- Table Naming Convention in Fusion Applications
- Most frequently used Tables list in Fusion HCM
- Mapping of fields on Application pages to Lookup Codes
If you have any questions, please feel free to reach out to me by posting in comments section.
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
hi good info thanks
Thanks for your compliment Raja. Keep following for latest updates.
Great Compilation Sri Thank you….