Automation – Bulk password reset
Your organization acquires a new company. All the employees to be converted to new company and user accounts to be created. bulk user creation can be done through HDL. However,…
4 ways to export dashboard to excel – OTBI 101
3 possible ways to export an OTBI dashboard to excel. 1. Export to excel using standard layouts - Manually select Page Options on the Dashboard page toolbar, select Export to Excel, and then Export Current Page, Export Entire Dashboard 2. Export to excel, using a custom export layout - create a layout to use instead of standard layouts 3. Use Agents to deliver a dashboard page as Excel format. 4. Create a OTBI analysis and design its layout according to the desired excel layout/format. Include a link to this analysis in the main dashboard
URLs – Oracle HCM Cloud
set of URLs, to easily access technical components such as UCM server, BI Server, OTBI dashboards, XMLP Server links, BIP report links, GO URLs All these URLs to be memorized and/or bookmarked by every Oracle HCM Cloud - Technical Consultant needs.
how to auto refresh a dashboard – OTBI 101
OTBI dashboard shows a run time snapshot of data from cloud, which becomes stale after sometime, as and when the users try and create data. So, to update the dashboard end user should always refresh the dashboard. In this article, we will see how to auto-refresh an OTBI dashboard.
Hide a Section in OTBI – OTBI 101
Select a section you want to hide Go to format section -> expand Additional custom CSS style write display:none;
Report Time Zone and Date issues – BIP 101
Reports display the time according to the time zone preference selected here. You can override this setting when creating a scheduled report job. Note that the time displayed on the user interface and reflected in report processing times is governed by the BI Publisher server time zone.
how to get list of HCM extracts scheduled by a user
best practice is to schedule HCM Extracts using a service account. To know if there are any HCM Extracts scheduled by a non-service user, follow the instructions in the article.
HCM Extracts – tips & tricks
#1. Fast way to rollback extracts: Navigate to Payroll -> checklist -> click on the extract run -> process details -> View Process results-> rollback#2. Best ways to schedule an…
PGP encryption in Fusion BI Publisher
Are you inclined to use HCM Extracts feature, just because it has features like output file encryption, built in SFTP integration point then think again... if your main goal is…
Pagination in BI reports
Pagination is a technique to limit the no of records shown per page. for example, 100 records are fetched from the database or Oracle HCM Cloud, report output should split…