3,314 total views
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.
Learning BI Publisher:
- Adding hyperlink in Email using BI Bursting
- Mapping of fields on Application pages to Lookup Codes
- Most frequently used Tables list in Fusion HCM
- Security Matrix – Users and their Roles
- SQL to fetch 200+ rows – Direct Database Query – Obsolete
- Execute Reports from Navigator without exposing the BI Catalog
- How to modify XML tags in BI Publisher Output?
- Using Session Variables in BI Reports to get logged in user info
- Table Naming Convention in Fusion Applications
- Enabling Audit for Business Objects in Fusion Applications
- SQL Query to fetch Flattened Organization Hierarchy Tree
- Basics of Flexfields in Fusion HCM
- Importance of Update Person Search Keywords Process
- How to access flexfields in OTBI Subject Areas?
- Basics of Valuesets in Fusion HCM
- Basics of HCM Data Loader in Fusion
- SQL Query to get the HDL file from staging tables
- SQL Query to get User last login information
- Sample CostAllocationAccountV3.dat HDL file
- Basics of HCM Extracts in Fusion HCM
- Generate flexfield database items
- Accessing flexfields in OTBI Analytics
- Configuring HCM Data Loader Parameters
- Defining Source System Owner for HCM Data Loader
- SET Operations on HDL file in Fusion
- SQL Query to get Supervisor Change HDL for Assignment
- Dynamic Date Parameters in BI Report
- SQL Query to get Geography Information
- Password Protect Excel Output in BI Publisher
- Prevent Merging Columns in Excel Output using RTF template
- SQL Query to get Fast Formula and related info
- OTBI Direct Database Query feature removal and fix – Obsolete
- Most Frequently Used SQLs for List of Values (LOVs)
- Most frequently used Date, Number and String functions
- Resolve “A system error occurred during processing” in Extracts
- Configure GMFZT logging for an HCM Extract
- New features in HCM Extracts in 19B release
- Important scheduled processes and their usage?
- Bursting attachment to Email along with html content in body
- How to get the Payroll Balance details in BI Report?
- List of tables which are impacted by Scheduled Processes
- Redesigning PBL to HDL Transformation Formula
- Importing Changes Only HCM Extract post 20A update
- Introduction of Cloud Customer Connect Forum
- Enabling Location Based Access Control (LBAC)
- Making a user read-only using Administrator Profile Values
- Scheduling BIP Report using SOAP Services?
- Use Utility to Upload, Download and Delete files from UCM
- SQL Query to get the Valueset and Lookup Values
- Cancel an existing Work Relationship using HDL for employees
Learning HCM Extracts:
- Basics of HCM Extracts in Fusion HCM
- Resolve “A system error occurred during processing” in Extracts
- Configure GMFZT logging for an HCM Extract
- New features in HCM Extracts in 19B release
- Importing Changes Only HCM Extract post 20A update
- Scheduling and Cancelling an existing schedule of HCM Extract
- Skip Output file of HCM Extract when no data is fetched
- Basics of Changes Only Functionality in HCM Extract
- Using Table based Valueset when DBI is unavailable
- Most frequently used User Entities in HCM Extracts
- How to view the output of HCM Extract run by other users?
- How to link/connect the User Entities in HCM Extracts
- Fix for assertion failure error in HCM Extracts
- Top 50 Interview questions and answers on HCM Extracts
- HCM Extracts Dynamic Output Filename guide
- SQL Query to find scheduled HCM Extracts
- Achieve complex requirements using Custom Global Reports Data Model
- Payroll Flow and HCM Extracts Mapping for Payroll Module
- Hiding XML nodes in HCM Extract Output
- Running the latest extract version using Payroll Flow
- How to convert HCM Extract Export XML to Readable format?
- List of User Entities, DBIs, Routes and Contexts from R13 19D
- Deleted Data Report using Audit Functionality
- Passing Logged in User details to HCM Extract
- How to handle FF not compiled error for HCM Extracts
- How to handle Daylight Savings timings for HCM Extract schedules
- HCM Extracts Design and Run Time Diagnostics Reports
Learning HCM Data Loader:
- Basics of HCM Data Loader in Fusion
- Sample CostAllocationAccountV3.dat HDL file
- Configuring HCM Data Loader Parameters
- Defining Source System Owner for HCM Data Loader
- SET Operations on HDL file in Fusion
- SQL Query to get Supervisor Change HDL for Assignment
- Cancel an existing Work Relationship using HDL for employees
- Sample HCM Data Loader (HDL) files for all Business Objects
- New Deadline for Payroll Batch Loader 20D Nov 2020
- Generate HDL file for failed business object Lines
- Resolving Assignment Name and Job Name not in sync issue
- Useful Excel to HDL DAT File Converter
- SQL Query to get Scheduled Process Job History
- Invoke HCM Data Loader using SOAP Service
- Send notifications to users to reset password using HDL
- Update Source Keys using HDL for business objects
- Top 50 HCM Data Loader Interview Questions
- How to ROLLBACK Element Entry HDL Load?
- Basics of HDL Transformation Formula – Part 1
- How HDL Transformation Formula works with ElementEntry Sample
- How to use escape and new line characters in HDL file
- HDL transformation Formula Flow changes in 20C
- HDL Transformation Formula using HSDL Template for UDT Load
Learning Fast Formula:
- Redesigning PBL to HDL Transformation Formula
- Using Flow Schedule Fast Formula to Schedule Extracts
- Bulk Compile Fast Formulas in Fusion
- Basics of HDL Transformation Formula – Part 1
- PBL to HDL Migration without custom HDL Fast Formula
- HDL transformation Formula Flow changes in 20C
- HDL Transformation Formula – User-Defined Table(UDT) Load
- HDL Transformation Formula – Skip Header Record
- Automated Parallel Processing technique for BI Report
Learning Personalizations:
- Enabling Audit for Business Objects in Fusion Applications
- Basics of Flexfields in Fusion HCM
- Basics of Valuesets in Fusion HCM
- SQL Query to get the Valueset and Lookup Values
- How to bulk load Profile Option values?
- Using Aggregate functions in Table based Valueset
- Introduction to User Defined Table (UDT) in Fusion HCM
- Accessing Payroll Process Configuration task
- Resolve EDIT button is grayed out on Assignment screen
- SQL Query to fetch Descriptive Flexfield information from an instance
- How to Bulk Load Lookup Types and Lookup Codes
- How to Bulk Load Valueset Values
Learning OTBI Analytics:
- SQL to fetch 200+ rows – Direct Database Query – Obsolete
- How to access flexfields in OTBI Subject Areas?
- OTBI Direct Database Query feature removal and fix – Obsolete
- Migration of Objects – OTBI Analytics
- OTBI Subject Areas to Table Field Mapping
- Troubleshoot OTBI by identifying Physical SQL Query behind it
- Information on Subject Areas and List of Seeded BI/OTBI Reports
Learning Security:
- Enabling Location Based Access Control (LBAC)
- Making a user read-only using Administrator Profile Values
- Using Role Mappings and Auto-provisioning Rules
- How to disable Single Sign-on or LBAC option?
- Limitations/issues faced with LBAC
- SQL Query to fetch IP Ranges setup for LBAC
- Applying Fusion Application Data Security to BI Publisher Reports
- Extend Password Expiration Date for Integration User Accounts
Learning Scheduled Processes:
- Importance of Update Person Search Keywords Process
- Generate flexfield database items
- Accessing flexfields in OTBI Analytics
- Important scheduled processes and their usage?
- List of tables which are impacted by Scheduled Processes
- Refresh Manager Hierarchy Process in Fusion HCM
- Send notifications to users to reset password using HDL
- Bulk load Roles to Users using HDL
- HCM Extracts Design and Run Time Diagnostics Reports
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:
- Mapping of fields on Application pages to Lookup Codes
- Most frequently used Tables list in Fusion HCM
- Table Naming Convention in Fusion Applications
- Introduction of Cloud Customer Connect Forum
- Use Utility to Upload, Download and Delete files from UCM
- Configuring Payroll Process Configuration Groups
- Modified Task/Action Names in Fusion HCM 20A
- Learning Fusion HCM Technical Skillset
- Hiding input parameters on BI report
- Important Oracle documentation links for Fusion HCM
- Top 10 FREE useful tools for Fusion Consultants
- Monthly Status Report – Thank you for your support
- Setting default preferences for all users and overriding them
- FREE Oracle Fusion Demo Instance (VISION) Access
- Difference between PER_ALL_ASSIGNMENTS_M and _F tables
- Legal Employer and Enterprise Service Dates in Fusion
- Bypass the FROM Clause limit in Table based Valueset
- Bulk load Roles to Users using HDL
- Payroll Actions and their usage in Fusion
- Areas of Responsibility (AOR) – It’s usage, Data Load and Report
- SQL Query to get the Flattened User Defined Table (UDT) Information
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- Most Frequently used Document IDs from Oracle Support
- SQL Developer like Tool for Oracle Cloud – That too for FREE
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….