Total Visits: 288
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 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
- SQL Query to pull Assigned Payrolls Information
- How to resolve column splitting into multiple rows issue in BI Publisher?
- SQL Query to get the Payroll Definition Config Information
- SQL Query to find Worker Count by Person Type
- How to fetch the flattened Supervisor Hierarchy for employees using SQL Query?
- How to translate BI Report Output to other languages?
- SQL Query to identify person relationship with Organization
- How to add Hyperlink to the RTF template?
- SQL Query to extract Business objects and attributes enabled for Auditing
- How to Download and install BI Publisher Plugin for MS Word and Excel?
- How to display HTML formatted text using HTML2FO function and RTF template?
- How to Reverse Terminate employees using HDL?
- SQL Query to fetch ORC Candidate Job Application Status
- How to Export Jobs from one POD to another using HDL?
- SQL Query to get Unique and Active Line Managers Names
- Personal Payment Method, its importance and query for Active Employees
- SQL Query to pull the Payroll Balance Feeds
- SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship Screen
- SQL Connect: A Robust alternative to TOAD and SQL Developer for Oracle Cloud
- SQL Query to get the modified fields from the Assignment table using Audit functionality
- How to Create BI Report using static Excel file .xls
- How to Create BI Report using static CSV file
- How to skip the blank line at the end of the output file using etext
- SQL Query to get the Object Group Employees
- How to use Regular Expressions in SQL Query?
- How to Resolve issues with User-Level Report Timezone on BI Report?
- How to generate CSV output from BI Reports/HCM Extracts?
- Oracle HCM Cloud Data Dictionary Tables
- Query for Rehire Recommendation Flag
- Customize Notification Templates and solve issue with Refresh Time
- Accessing Reports in My Folders of other users (Locked/No more exist)
- What is the alternative for DATA_CACHE which is being deprecated from 21A?
- How to get the LDG associated with Legal entity?
- How to deal with Datetimes stored in Database as UTC timezone?
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh
- BI Publisher Audit and Execution Reports
- Passing Message Tokens for Messages in BI Report for Dynamic Notification
- Run BI Publisher Report from Custom Payroll Flow Pattern
- Adding External PDF attachments to bursted PDF output
- Using Dummy Bursting Query in BI Report to achieve dynamic filename
- Automated Parallel Processing technique for BI Report
- Security Matrix with User and Role Mappings
- SQL Queries to pull Action Type, Action, Action Reason and Action Reason Usages
- SQL query to pull Work Schedules for Assignments/Legal Employers
- Applying Fusion Application Data Security to BI Publisher Reports
- Introduction to Seeded LDAP Request Reports
- Skip Schedule using Schedule Triggers in BI Publisher
- How to use IF IF-ELSE OR AND conditions in RTF template BI Publisher
- SQL Query to get the Dropped Dependents from Benefits Coverage
- Assignment tables PER_ALL_ASSIGNMENTS_M and _F differences
- SQL Query to fetch Bank, Branches and External Bank Accounts
- Deep Links and their usage in BI/OTBI Reports
- SQL Query to find changes within a specific timeframe
- SQL Query to find the Position Incumbents
- Deleted Data Report using Audit Functionality
- SQL Query to find pending approval transactions from Workflow tables
- Access contents of UCM file using BI Report
- Get the info of Attachments loaded to UCM
- List of functions available in per_extract_utility package
- Auto Fit Contents in Excel output with RTF template in BIP
- How to get list of all BI Reports from a folder/instance
- SQL Query to fetch the Document of Records
- SQL Query to fetch Cancelled Work Relationship and Reverse Termination
- Top 50 BI Publisher Reporting Interview Questions
- Variables and its usage in RTF template
- SQL Query to get Payroll Element Entries
- SQL Query to get Position and Job Valid Grades
- Migration of Objects – BI Reports
- Dynamic Output and Bursting for BI Report
- Displaying Person Images in OTBI Analysis
- SQL Query to get Scheduled Process Job History
- Resolve Folder not accessible in BI Catalog issue
- Configure FTP Server and use it in BI Report and Extract
- SQL Query to get the Time in Job and Position
- Display Person Image on BI Report
- Creating Zipped PDF file output from BI Report
- Fix for SQL query time out error in BI Reports
- SQL Query to fetch employee person and assignment info
- Refresh Manager Hierarchy Process in Fusion HCM
- SQL Query to fetch Supervisor Direct and Indirect reportees
- Creating Excel templates and troubleshooting them
- Fix for BI reports generating stale/old data due to Cache options
- Test/Preview/Troubleshoot eText templates
- Etext template tips and tricks Part 2
- SQL Query to get Source System IDs for all Business Objects
- How to get Position Hierarchy in SQL Query?
- Etext template tips and tricks Part 1
- Scheduling BIP Report using SOAP Services?
- How to get the Payroll Balance details in BI Report?
Trending Content
Learning 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
- List of User Entities, DBIs, Routes and Contexts from R13 19D
- 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:
- 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
- Sample CostAllocationAccountV3.dat HDL file
- Basics of HCM Data Loader in Fusion
Trending Content
Learning 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?
- How to Bulk Load Valueset Values
- How to Bulk Load Lookup Types and Lookup Codes
- SQL Query to fetch Descriptive Flexfield information from an instance
- Resolve EDIT button is grayed out on Assignment screen
- 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:
- 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:
- 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:
- 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
- Monthly Status Report – Thank you for your support
- 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.
Trending Content
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….