Use the below query to extract the length of service of a worker. In case of rehires this becomes little tricky. Below query makes use of earliest hire date for length of service calculation. If Seniority dates are implemented, then you can avoid using below query:
Use the following query to extract department tree and its child departments. Please pass correct department name before executing:
GL Cost center Information can be maintained at Department Level. This information can be extracted using below SQL: To bulk upload GL Cost Centers Organization.dat HDL can be used. Please check the below link for more details: https://fusionhcmconsulting.com/2021/01/hdl-sample-hdl-to-load-gl-information-at-department-level/
In order to audit the BIP reports, AuditViewDB should be first configured in list of data sources. Follow the below steps to configure it: Login to your Fusion application instance (analytics). Click on Administration -> Manage BI Publisher -> Data Sources -> JNDI Connection 3. Click on Add Data Source and enter below details and…
Oracle provided a new functionality to include e signatures in checklist tasks. A custom report can be configured and upon e-signature and completion, it will be saved to worker’s document of records. You can follow the below document on my oracle support for detailed steps – 2611795.1 Below is the basic SQL query to start…
