SQL Query to fetch Descriptive Flexfield information from an instance
Do you know how to fetch the configured Descriptive Flexfields from an instance? Do you know in which table and attribute the data resides?
Bypass the FROM Clause limit in Table based Valueset
Do you know that you can bypass the FROM Clause character limit of 240 in table based valueset using a workaround? Read on to know more details.
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.
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.
Basics of HDL Transformation Formula Part 1
Do you know the HDL Transformation Formula in Fusion HCM? What are the use cases of it? How to use it? FAQs on it? Read on to know more details.
Legal Employer and Enterprise Service Dates in Fusion
Do you know the Legal Employer and Enterprise service dates on Work Relationships? How are they derived and what is the significance of each of them? Read on to know more details
Auto Fit Contents in Excel output with RTF template in BIP
Do you know how to set dynamic width for columns in excel output using RTF template? This works along with keep values in same column setting. Read on to know more details.
How to ROLLBACK Element Entry HDL Load?
Do you know that from 19D Oracle has released ROLLBACK feature for HDL Business objects starting with Element Entry Business Object? Read on to know more details.
How to get list of all BI Reports from a folder/instance
Do you know how to get the list of reports in a folder or get all custom reports list from an instance? 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.