Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
BI publisher not workingSummary Unable to use BI publisher in ExcelContent Hi folks! I need to modify a Excel Template for a Oracle Cloud report. It seems that my BI publisher is not working pr… -
Error uninstall Oracle BI Publisher Desktop 1670:Unable to Load module with error code:1114Summary: We are trying to uninstall Oracle BI publisher Desktop , but we are getting below error 1670: Unable to load module c:\Users\Admin... Error Code: 1114 Could you…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
How to create date range parameter i.e. Date from and Date to in OTBI report?Summary: How to create date range parameter i.e. Date from and Date to in OTBI report? Content (required): We want to fetch payment details from specific date range in O…
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…
-
User folder not visible in right pane due to system limitation of 300 folders at a timeSummary: Per Doc ID 2443757.1 users folder permission can be set by navigating to folder. However though I can see the user folder in left pane can't navigate to the sam…
-
How to Calculate Payroll ReversalsSummary: How to include payroll reversal values in calculation Content (required): We have BI publisher report that calculates Payroll distribution for all of our employ…
-
Workforce Management - Absence Real Time Subject Area not returning any dataContent Workforce Management - Absence Real Time Subject Area displays 'No Data found' . Can someone who has used this Subject Area please let me know the roles that hel… -
Create LOV for countries defined in the system and few more custom valuesSummary: Can we create an LOV that will include all countries already defined in the system plus few more custom values. Content (required): Version (include the version…
-
Value of a LOV is restricted depending on logged in userSummary: How can we restrict the values included in an LOV depending upon the logged in User Content (required): Version (include the version you are using, if applicabl…
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l… -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Table name to query the Delegation Approval rule and categorySummary Table name to query the Delegation Approval rule and categoryContent I have a requirement to create a report for Delegation Approval Rule and category informatio… -
How to burst different notifications to different mail IDs based on exit interview responsesSummary: How to burst different notifications to different mail IDs based on exit interview responses Content (required): We have implemented the Offboarding Process in …
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…
-
HCM - Administrator Role for Report Scheduling in HCMSummary: Create an Admin record in HCM for Report Scheduling Content (required): Is there a way to create a user account in HCM that can be used as a central scheduler f…
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…
-
Release 13 Version 20B: Steps to enable and create an infoletSummary Release 13 Version 20B: Steps to enable and create an infoletContent Hi All, Please find attached herewith, a step by step documentation with screenshots on how … -
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec… -
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 43 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the… -
Is there a UE that can fetch LE details including LE addressSummary: Requirement is to get all active LEs and their respective address along with Bank Details for the UE. Content (required): I tried using the below UE but it does…
-
Can we get offering old and new status?Summary: Hi All, I am working on a report where the requirement to get the old and the current status of the offering. I queried mentioned below tables to get the status… -
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…