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
-
Talent data by Assignment Manager without a HR roleSummary Which additional duty do I need for a manager w/o a HR role to see his talent review data?Content Hey All, On our test boxes I have created a simple table with t…User_2025-01-23-22-38-50-675 35 views 1 comment 0 points Most recent by User_2025-01-23-22-38-50-675 -
In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Summary In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Content Hi All, In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE… -
Calculating the Number of Business DaysSummary Count the number of Business Days between 2 datesContent I constantly get requests to provide reporting based on Business Days rather than Calendar Days. Calcula… -
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published … -
Some Users cannot see Leavers despite Correct RolesContent Hi all, got a weird one! I developed some leavers reports a few months ago and they worked perfectly for me and for users when they tested them. The report is no… -
Calculations not working inside pivot tableSummary Using a pivot table to remove multiple rows caues calculations not workContent Hello all, I have an analysis that is pulling from 3 subject areas and is set up t… -
After Release 13 Upgrade Reports and Analytics icon is missingSummary Reports and Analytics icon missing after Rel13 UpgradeContent We are recently upgraded our Test POD to Relaese 13 ,after upgraded Reports and Analytics icon miss… -
Find all workers which are missing emergency contactSummary How to create a report which present the employees that missing an emergency contactContent Hi, Someone has an idea how to create a report in OTBI of all the emp… -
Crossing Subject AreasSummary Certain dimensions will not populate even though I have linked by measures.Content I have created this report and I have been having the hardest time populating … -
Custom Profile Content Types in OTBISummary Custom Profile Content Types in OTBI (Workforce Profiles - Person Profile Real Time)Content We have created some custom profile content types in HCM Cloud under … -
Worker Address History in OTBI!Summary Worker Address History ReportContent Hi All, Do we have any Primary Address History for a Worker available in OTBI SA's? I am only able to get the Real Time Addr… -
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a … -
Issue with Bins and Case StatementSummary Issuing a CASE statement against hire and term bins from Action Name fieldContent Due to our decentralization I cannot utilize the assignment event measures when…User_2025-01-28-08-47-04-905 34 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 -
Person IdentifiersSummary Person IdentifiersContent Hello, In which subject area (if at all) we can find the " Manage Person Identifiers for External Applications" Thanks, Michal -
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…User_2025-01-25-04-02-13-126 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Pass Parameters from OTBI to BI DatamodelSummary Pass Parameters/Prompts from OTBI to BI DatamodelContent I have created a OTBI Report with a presentation variable. I would need a pipe delimiter file. So I adde… -
Adding a Detail Report Behind a Performance tileSummary Adding a Detail Report Behind a Performance tileContent Hi, I am looking into how I can make a performance tile interactive so a user can click on the number on … -
Unable to use Organization field with person profileSummary Trying to use organization field with person profile data (education) in OTBIContent Hello I want to include Organization details (Organization Level 02 Name) in… -
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s… -
User Account Information TableSummary Required User Account Header Information with BI queryContent Hi, I'm want to create BI report to get all USER information in Oracle Cloud. Need to capture below… -
HR Manager Name & Person Number in OTBI SA's?Summary HR Manager Name & Person Number in OTBI SA's?Content Hi All, I am trying to report the name of HR Manager & Person Number for a Worker. Is the HR Manager & Perso…User_2025-07-18-02-05-33-261 44 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 -
OTBI and Extended LookupsSummary Visa categories' extended names no longer appearing in OTBI analysesContent Hi, has anyone else who records 'Visa Categories' (as Extended Lookups) experienced a…User_2025-01-29-19-59-51-150 91 views 14 comments 1 point Most recent by User_2025-01-29-19-59-51-150 -
Connecting Business Unit to Employee DetailsContent Hi everybody, I am struggling with a (seemingly) easy OTBI task: I am using two Subject areas: WORKFORCE MANAGEMENT - PERSON REAL TIME and WORKFORCE MANAGEMENT -… -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
HCM Cloud Dashboards for Salary and TurnoverSummary I am looking for HR dashboards for Headcount, Salary, Absence and TurnoverContent I am looking for HR dashboards for Headcount, Salary, Absence and Turnover. I d… -
Is there any OTBI Subject area to generate the Delegation Details - Delegate Role,Delegate and ProxySummary How to create one OTBI report for Delegate and Proxy User and the Delegation DetailsContent Hi All, Could you please let me know if there is any way to create OT… -
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a… -
How to fetch Person Type from Assignment Details from Fusion TablesSummary How to fetch Person Type from Assignment Details from Fusion TablesContent Hi, I need to fetch Person Type (which shows value: 'Regular' in front-end Employee Ma… -
Employee Record in OTBI?Summary Which SA has Empl RCD?Content Hello All, Which Subject Area contains the Employee Record (Empl RCD) attribute? Thanks, Nikhil NelluriUser_2025-07-18-02-05-33-261 37 views 7 comments 0 points Most recent by User_2025-07-18-02-05-33-261 -
Approval Status in the Goal ReportContent I have created an OTBI analysis based on Goal Status Overview Real Time subject area. After running the report identified that goal approval status is not showin…User_2025-01-28-21-18-43-496 141 views 5 comments 0 points Most recent by User_2025-02-04-23-22-13-274