On the responsive Position UI, the position screens shows the Pending Worker and Worker record as an incumbent and the FTE goes in negative. Below SQL can be used to identify such persons:
There are different requirements where one wants to get number of active/inactive work relationships in a legal entity. Below SQL query can be run to get these counts:
Below query can be used to extract the document record from content server.
Oracle HCM allows special characters to be used in fields like Person Names/ Department Names/ Jobs etc. But in reporting, there may be a requirement to change the special characters (like ý, ě, ž, ů etc) to normal English characters. CONVERT function can be used for such requirements. Output:
Below is a sample file to create Pending Worker record using HDL: ReadyToConvert Flag on Work relationship is used to convert the Pending worker record to Employee record. If this flag is set to Y, it will appear in NewPerson Dashboard with Automatic conversion marked as Yes. Run Convert Pending Workers Automatically Process will pick the…
Many a times while trying to use Post method using REST API, we encounter – ” The specified operation is not supported for the invoked HTTP method. Please check the URL and the headers.” Cause of this error is incorrect header parameters/ missing header parameters while making a call to REST API. To fix the issue:…
Below query can be used to pull actions and configured actions for these reasons along with action type:
Once Jobs data is loaded/created, you can use below SQL to extract the setup data for Jobs:
Below query can be used to extract checklist configuration details:
There is no easy way in OTBI to find list of jobs which don’t have a model profile associated with them. This can be achieved easily using BIP query. Sample Query:
In your test environments, you may encounter issues where you want to DELETE positions data. You can use below script for that:
Oracle has released a new subject area for Areas of Responsibility. Subject Area Name – Workforce Management – Areas of Responsibility This has simplified the process of extracting AoR data using OTBI. To get any data in this subject area, you should run “Refresh Representative Data” ESS process. The process should be run post any…
Query for bank details: Query for bank branch details: Query to extract Internal bank accounts: select * from ce_bank_accounts Query to extract External bank accounts:
Sometime for data migration, it is required to get a dump of all the absence reasons configured in Fusion HCM in order to validate the data being loaded. Below query can be used to extract the setup data for absence reasons:
