Get the info of Attachments loaded to UCM
Do you know how to get the documents information that have been uploaded to UCM using SQL Query? Read on to know more details.
All posts on Sample SQL Queries
List of functions available in per_extract_utility package
Do you know the list of available functions in per_extract_utility seeded pl/sql package? These functions can be used in sql query to avoid unnecessary joins to tables. Read on to know more details.
SQL Query to fetch the Document of Records
Do you know the underlying tables which store the Document of Records Information? Will the file gets uploaded to UCM? Can we access it from UCM? Read on to know more details.
SQL Query to fetch Cancelled Work Relationship and Reverse Termination
Do you know that we can fetch the cancelled work relationship details and who has cancelled it and at what time the transaction has been done? Read on to know more details.
Difference between PER_ALL_ASSIGNMENTS_M and _F tables
Do you know which table to use while building query on assignment information? PER_ALL_ASSIGNMENTS_M or PER_ALL_ASSIGNMENTS_F or PER_ALL_ASSIGNMENTS_M_? Read on to know more details.
SQL Query to get Payroll Element Entries
Do you know how to write SQL Query to get the assignment level payroll element entries? Read on to know more details.
SQL Query to get Position and Job Valid Grades
Do you know how to query the valid grades for Position and Job business objects? Read on to know more details.
Dynamic Output and Bursting for BI Report
Do yo know how to achieve the dynamic output file name in BI Reports? Have you tried bursting feature to get the dynamic file name? Read on to know more details.
SQL Query to get Scheduled Process Job History
Do you know how to get the Scheduled Processes history from underlying tables? How to get the BI Report Job History? Read on to know more details
SQL Query to get the Time in Job and Position
Do you know how to get the Time in Job and Position information of an employee from the assignment information in Fusion HCM using BI Report? Read on to know more details