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
-
Using Subject ID in Transaction AdministrationSummary How do I use Subject ID to join to other Subject Areas to identify employee impacted by transaction by nameContent I would like to create an OTBI report on faile… -
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 25 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas… -
OTBI Anchoring date variationSummary Try to change Anchoring date in Performance Subject AreaContent Hi all we try to change in our OTBI reports the Anchoring Date of Performance Subject area: 1) Wo… -
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
Adding Action Occurrence Created By column in OTBI ReportSummary Adding Action Occurrence Created By column in OTBI ReportContent Hi Experts, We have an OTBI report. In that report our business requested to add 'Action Occurre…
-
Report to Find When a Payroll Relationship was updatedSummary Report to Find When a Payroll Relationship was updated and it includes the old and new payroll relationshipContent Hi, Wondering if anyone has a report that show…
-
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H… -
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a… -
Creating a BI Publisher report having parameters with LOV selection (selecting more than one value)Summary Creating a BI Publisher report having parameters with LOV selection (selecting more than one value) is causing error.Content Creating a BI Publisher report havin…
-
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed …
-
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…
-
Identify if comma is present in a fieldSummary How to do that in OTBI?Content Hi, we need to embed the following logic into OTBI report (CASE WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_nam…
-
OTBI Bursting ReportSummary Bursting report is not splitting out rows to recipientsContent Hello! I have an OTBI bursting report for absence balances. I've included a column with the user n… -
how to create a page in UI and add dashboard into it in release 20BSummary how to create a page in UI and add dashboard into it in release 20BContent Hi, how to create a page in UI and add dashboard into it in release 20B. 20B is very d… -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than…
-
Dashboard with Prompts using LSQLSummary Write analyses for Dashboard with Prompts using LSQLContent Is there a way to write analysis using LSQL(more complex, which would have outer joins etc.) which ca…
-
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
Learning - Reporting on RecommendationsSummary Would like to report on who recommended learning items and to whomContent I would like to create a report to show who recommended learning items and to whom. I h…User_2025-01-25-05-06-07-246 57 views 3 comments 0 points Most recent by User_2025-01-25-05-06-07-246
-
BI report Name change and path changeSummary Impact AnalysisContent Team, We have a request to change report name and path of few reports . These reports are scheduled already. Just wanted to know what woul…
-
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20A
-
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …
-
Matrix Manager - Additional DetailsSummary Reporting on additional details of Matrix ManagerContent Hello Reporting Guru's! I'm wondering if anyone has found a way to report on a matrix manager's details … -
Reports got failed when scheduled in DEV3 completed in DEV2Summary Reports got failed when scheduled in DEV3 completed in DEV2Content Some of our reports got failed when scheduled in DEV3. On analysis we could see that the Data …
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…
-
Identify users logged into the applicationSummary Identify users logged into the applicationContent Hi All, does anyone know if there is a report or process that can be run to check which users are logged into t… -
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo…
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 61 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…