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
-
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…
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…
-
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who… -
Is it possible to initiate HCM BI Publisher Reports from a batch script on a seperate server?Content We are hoping to integrate HCM to a custom EPM implementation using BI Publisher extracts.We are hoping to integrate HCM to a custom EPM implementation using BI … -
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…
-
Having more than 1000 values in List of Values for Parameters in BIP ReportSummary Need to have all option in Parameter for Manager Name in BIP ReportContent When we tried to have Manager Name Parameter with Select All value option in BIP Repor…User_2025-02-04-17-42-01-535 742 views 7 comments 0 points Most recent by User_2025-02-04-17-42-01-535
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto… -
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w…