Passing Logged in User details to HCM Extract
Do you know that you can get the Logged In User details in HCM Extract? Why the seeded functions which return user details in BIP does not work in advanced filter directly? Read on to know more details.
SQL Query to find changes within a specific timeframe
List of Functions to convert date to a different timezone and use them in SQL Query to get the required information. Read on to know more details.
SQL Query to find the Position Incumbents
Do you know how to build query to find out the Position Incumbents? Position Incumbents are nothing but the employees hired into the Position. Read on to know more details.
Deleted Data Report using Audit Functionality
Do you know that you can fetch deleted data for business objects in Fusion if Auditing is turned ON? Read on to know more details.
OTBI Subject Areas to Table Field Mapping
Do you know the mapping of subject areas to the database table and columns? Read on to know more details.
How to convert HCM Extract Export XML to Readable format?
Can you read through the HCM Extract Export XML file? Do you know you can do it easily with the help of XSL tool? Read on to know more details.
Running the latest extract version using Payroll Flow
Have you faced issues with multiple versions of extracts? How do you migrate the extract changes to other instances when the target instance already has the extract? Read on to know more details.
Hiding XML nodes in HCM Extract Output
Do you know how to hide the XML tags on HCM Extract output? Can you hide all tags or is there any restriction? Read on to know more details.
SQL Query to find pending approval transactions from Workflow tables
Have you used the approval related tables to fetch the In Progress/Approved/Withdrawn transactions? Can you do another transaction on the business object which has an in process approval? Read on to know more details.
Access contents of UCM file using BI Report
Do you know that you can get the contents of the text files uploaded to UCM in BI Report? Read on to know more details.