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
-
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 43 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
-
OTBI Performance Tile Filter : How to get difference between 2 datesSummary OTBI Performance Tile Filter : How to get difference between 2 datesContent Hi, Currently, when I try to put a OTBI filter to get difference between 2 dates, it …
-
Inactive Departments and Attrition Reporting ErrorSummary Issue once departments are made inactive we are no longer able to report on leavers.Content Following a restructure we have made a number of departments inactive…User_2025-01-23-20-43-34-115 36 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OSummary Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OTBI AnalysisContent Hi, Do we have a separate 'Worker Number'…
-
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s… -
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t… -
OTBI Security by Line ManagerSummary OTBI Security by Line ManagerContent MY OTBI security by Manager doesn`t work. I have the Line manager person profile secured by Manager hierarchy, but the Line …User_2025-01-30-21-52-52-008 285 views 17 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Oracle Report Jam at OHUG 2018 in Vegas - 2 weeks to go!!!Content About half the slots are already taken, book now to secure your slot. Highlights Sign up to guarantee some in-depth 1:1 report building using Oracle Transactiona… -
Oracle Report Jam at OHUG 2018 in Vegas - 2 weeks to go!!!Content About half the slots are already taken, book now to secure your slot. Highlights Sign up to guarantee some in-depth 1:1 report building using Oracle Transactiona…
-
FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Summary FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Content Hi All, I have formed the below query in BI Publisher Data Mod…
-
Connecting Goal Status Overview to Assignment Real Time Subject AreasSummary No fact table exists error when trying to connect themContent We have setup a flex field at the assignment level and are trying to report on goal campaign attrib… -
Report to record absence balancesContent I need to create an OTBI report to show absence balances. But I could not able to find correct subject areas. Both Workforce Management, Accural and absence real…User_2025-01-28-21-18-43-496 136 views 10 comments 0 points Most recent by User_2025-01-28-21-18-43-496
-
Chart Legend ColorsSummary Is there a way to change the chart colors in OTBI?Content I cant find or figure out how to change the colors on my bar chart. Any help would be greatly appreciat…User_2025-01-28-08-47-04-905 55 views 3 comments 1 point Most recent by User_2025-01-28-08-47-04-905
-
Contacts ReportSummary I would like to create a reports with contacts detailsContent Hi, I tried to create a report via OTBI that includes all the contacts with the following details -…
-
Duplicate RowsSummary When bring multiple emails / phones, it brings them in on one line and then creates an additional line with one of the attributesContent UPDATE: With everyone's … -
Fetching Gross Pay YTD for a terminated employee in BI ReportSummary Fetching Gross Pay YTD for a terminated employeeContent Hi, I am able to fetch Gross Pay YTD till last payroll process date but not after that. I require to fetc…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to… -
Custom report tablesContent We have a requirement to create a custom report to get division wise PD tasks status for following details. Appreciate someone can let us know the tables to refe…User_2025-01-28-21-18-43-496 56 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Benefit CreditsSummary We need a report that would display Benefit CreditsContent We need a report that would display Benefit Credits by Person Number on the left access and each benef…User_2025-01-29-19-59-40-005 44 views 1 comment 0 points Most recent by User_2025-01-29-19-59-40-005