1,578 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
- Security Matrix – Users and their Roles
- 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
- SQL Query to fetch Flattened Organization Hierarchy Tree
- SQL Query to get the HDL file from staging tables
- SQL Query to get User last login information
- 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
- Most Frequently Used SQLs for List of Values (LOVs)
- Most frequently used Date, Number and String functions
- Bursting attachment to Email along with html content in body
- How to get the Payroll Balance details in BI Report?
- Scheduling BIP Report using SOAP Services?
- Etext template tips and tricks – Part 1
- How to get Position Hierarchy in SQL Query?
- SQL Query to get Source System IDs for all Business Objects
- Etext template tips and tricks – Part 2
- Test/Preview/Troubleshoot eText templates
- Fix for BI reports generating stale/old data due to Cache options
- Creating Excel templates and troubleshooting them
- SQL Query to fetch Supervisor Direct and Indirect reportees
- Refresh Manager Hierarchy Process in Fusion HCM
- SQL Query to fetch employee person and assignment info
- Fix for SQL query time out error in BI Reports
- Creating Zipped PDF file output from BI Report
- Display Person Image on BI Report
- SQL Query to get the Time in Job and Position
- Configure FTP Server and use it in BI Report and Extract
- Resolve Folder not accessible in BI Catalog issue
- SQL Query to get Scheduled Process Job History
- Displaying Person Images in OTBI Analysis
- Dynamic Output and Bursting for BI Report
- Migration of Objects – BI Reports
- SQL Query to get Position and Job Valid Grades
- SQL Query to get Payroll Element Entries
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
Learning HCM Data Loader:
- Basics of HCM Data Loader in Fusion
- Sample CostAllocationAccount.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
Learning Fast Formula:
- Redesigning PBL to HDL Transformation Formula
- Using Flow Schedule Fast Formula to Schedule Extracts
- Bulk Compile Fast Formulas in Fusion
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
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
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
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
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
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….