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
-
Duplicate Rows on DM/ReportContent Hi all - We want to build one data model and then use that to build multiple reports. This will help us ensure that if we update the code, we are updating all of… -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b… -
Employee Self Service Transaction reportContent Hi, I`m trying to find the subject area for self service transactions - we need to ensure that for a period of time some employees aren`t putting through self se…User_2025-02-06-11-18-47-896 51 views 3 comments 1 point Most recent by User_2025-02-06-11-18-47-896 -
Subject area for individual compensationContent Hi , I`m trying to build a report for bonus payments that we make to employees for various bonus plans we have - recognition, excellence etc. I can not find this…User_2025-02-06-11-18-47-896 70 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896
-
How to ensure a Manager is not seeing their own data when viewing a dashboard reportSummary Is there a way to ensure a Manager can't see their own data when viewing a dashboard report?Content Is there a way to ensure a Manager can't see their own data w…
-
Listagg Function on Business Intelligence Subject AreasSummary How to use Listagg Function on Subject areas on BI ReportsContent Hi Team, I have converted an OTBI an analysis to a BI Report. I would like to use Listagg funct…
-
Password security for scheduled report outputSummary Password security for scheduled report outputContent HI Team, We have some sensitive HR BI reports and we are trying to schedule those reports to send the output… -
OTBI Catalog and Data Model Management Best PracticeSummary Trying to find Best Practice on storing Data Models within Custom FolderContent Hello, New to the forum and I have a question regarding Management of Data Models…
-
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
Restricting Access to OTBI Dashboards / Reports not Working as ExpectedSummary Restricting Access to OTBI Dashboards / Reports not Working as ExpectedContent Hi, We use Custom Roles and have configured the following: - Employee Role: No Acc… -
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue … -
Changed username and now user cannot login to OTBISummary Changed username and now user cannot login to OTBIContent Hello, We had to change the username for an existing user and now the user is unable to login to OTBI. …
-
Prompt - put conditions on promptSummary I use Display Name and want to filter only employeesContent Hi, I need to limit the prompt on "Display name" to active employees only. I added a SQL statement bu…
-
Table that stores the BI scheduleSummary Table that stores the BI scheduleContent Can any one help us with the table that stores the scheduled jobs/reports in BI Publisher? We would like to get a report…
-
Dashboard BI Publisher Report SecuritySummary Dashboard not retaining user securityContent I have created a dashboard report from a BI Publisher report using a data model. During testing, I have noticed the … -
How to: Translate BI Publisher Report ParametersSummary I wish to know if it is possible to translate BI Reports parameters based on user environment language.Version Oracle BI 11.1.1.9
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…
-
Nice look and feel outcome when NO result in OTBISummary How to display a nice page in case of NO result in OTBIContent Hi, do you know if there is some way to display a courtesy page if no result in a OTBI analysis? T…
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w… -
OTBI CapabilitiesSummary OTBI CapabilitiesContent Hi Experts, I hope some of you will agree that although OTBI has advanced features and capabilities still some consultants prefer to use… -
Can we query the list of custom BI reports and OTBI analysis in our instanceSummary The requirement is to pull the report name,report path, parameters and other corresponding attributes of a reportContent Hi, The requirement is to pull the repor…
-
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 56 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…
-
Dashboard Prompt from BI ReportSummary Dashboard Prompt from BI Report does not workContent I have created a dashboard from a BI Report. I have attempted to set up a prompt but it isn't working. Can s…
-
Employees Hired in the Last 7 DaysContent Hi Guys, I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement int… -
Onboarding ReportSummary BI Publisher Onboarding ReportContent Hello. We have surveys under Onboarding and we need to report on the results. I have written this in BI Publisher but I am …
-
COUNT of new hires and veteransSummary Calculate the count of 2 custom fieldsContent Hi Team, I am calculating the count of employees who are new hires and veterans. Below is the query used which is n…
-
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…
-
How to make default value by sandboxSummary I want to make a value for Change Action ReasonContent Hi all, I want to make default value for action reasons in transfer page by using sandbox. I have attached…