2,543 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
- Variables and it’s usage in RTF template
- Top 50 BI Publisher Reporting Interview Questions
- SQL Query to fetch Cancelled Work Relationship and Reverse Termination
- SQL Query to fetch the Document of Records
- How to get list of all BI Reports from a folder/instance
- Auto Fit Contents in Excel output with RTF template in BIP
- List of functions available in per_extract_utility package
- Get the info of Attachments loaded to UCM
- Access contents of UCM file using BI Report
- SQL Query to find pending approval transactions from Workflow tables
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
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
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
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
- 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
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….