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
-
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t… -
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col… -
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
CreateException:Index 6 out of bounds for length 6 in BIP reportsSummary: CreateException:Index 6 out of bounds for length 6 when I add 7th RTF template to the report I am getting below error and I am not able to delete extract RTF an…
-
GET_VALUE_SET not returning any value in Fast FormulaSummary: Hi, I am using the Value Set of Table type in Absence Accrual Matrix formula but it is not returning any value in Fast Formula though scenario is valid. Expecte…
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
SQL for Payroll Element Calculation FactorsSummary: Hi all, does anyone have any SQL that extracts element calculation factors? Element Name, Calculation Step, Calculation Value Definition, Range Values etc… Than…
-
Tracking relatives in the same companySummary: I'm interested to know if anyone has tracked relatives or other relationships of employees working in the same company. We want to avoid having relatives workin… -
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…
-
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
Inhibition of downloading a specific reportSummary: Hi all, we would like to know if it is possible to inhibit the ability to download a report. Also, it would be helpful to know whether this functionality can be…
-
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin… -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use … -
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?Summary: I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manag…
-
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…
-
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …
-
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'… -
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any…
-
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…
-
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…
-
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …
-
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…
-
Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…
-
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…
-
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…
-
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need …