OTBI
Discussion List
-
job name changeSummary OTBI analysis to show job name historyContent Hi, I've searched the forum and sharing centre for this but can't see anything, so apologies if answered elsewhere.…User_2025-02-08-05-56-00-229 40 views 3 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM -
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count …Rob F 35 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Customer Data DumpSummary Seeded Customer dump reportContent All - Is there a seeded out of the box report that can create a dump of all customer related attributes?Hari Thyagaraj 22 views 2 comments 0 points Most recent by Hari Thyagaraj Reporting and Analytics for SCM -
In a back to back sales order when sales order line is changed/cancelled, don't cancel WO if it hasSummary In a back to back sales order when sales order line is changed/cancelled, don't cancel WO if it has started/releasedContent In a back to back sales order when sa…
-
Unable to report from subject area 'Workforce Talent Review - Talent Review Tasks Real Time'Summary No results from OTBI sa 'Workforce Talent Review - Talent Review Tasks Real Time'Content Hello, Can anyone please help? I am unable to get any data from the subj…SantoshKumarBhairi 53 views 17 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Conditional formatting on Pivot table - heat mapContent I have created a report to look at the amount of annual leave taken so far in the year by different teams. I am having trouble putting the conditional formatting…User_2025-02-06-11-18-47-896 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 39 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Active Job Titles & Salary RangesSummary pulling in all active job titles with salary rangesContent I have created an analysis using the 'Compensation - Salary Details Real Time'. The purpose of this an…Shelly Feyerherm 73 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to find a report in analytics (Balance Exception Report)Summary How to find an base report in the analytics tool to see if it can be customized.Content Hi All, My users have asked if it is possible to add the Assignment Statu…User_2025-02-04-08-51-08-912 20 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Workstructure and Employee Incumbent Report using Subject AreaSummary Workstructure and Employee Incumbent Report using Subject AreaContent Hi Friends, I am aware it is possible to get Workstruture and Incumbent Details using a cus…AshishERPCloud 31 views 12 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Duplicate LinesSummary What function or formula is best to useContent Hi, I have numerous OTBI Analysis reports that will have 2 or 3 lines per employee because certain columns will co…User_2025-02-05-22-44-35-842 51 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Reporting on benefit plan elections and plan ratesSummary Reporting on benefit plan elections and plan ratesContent Does anyone have a report to share on plan / option elections along with the employee and employer cost…
-
How to limit Nationality in report?Summary Multiple nationalities for some employees - I only want the the main or primary nationalityContent Hi, I've attached the XML - can anyone modify the report so th…User_2025-02-05-22-44-35-842 26 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Mapping the instructors in the Oracle HCM Core HR and LMSContent Dear Community, We are now configuring the LMS and we found out that when we want to link an external instructor to a course, this person needs to have an employ…
-
Help with creating a formula on analysis for OLC Learning - by learning item by learnerSummary I have created a formula on Initial Due Date to return the number of days a course is In Progress - Overdue but its calculating on the Completed courses as well.…
-
Address Mapping DocumentContent Hi all - I am working on an address report and have noticed that there are different layouts based on the location. For example, the US has States but the UK doe… -
Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderSummary Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderContent We have been trying to create few KPI's for Purchase Requisition work area and …User_2025-02-10-05-51-05-868 55 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Need Logic to create below KPI's for Purchase RequisitionsSummary Need Logic to create below KPI's for Purchase RequisitionsContent We have been trying to create few KPI's for Purchase Requisition work area and got struck on ho…User_2025-02-10-05-51-05-868 34 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Payroll Overpayment ReportContent Good Day, Has anyone actually built a Payroll Overpayment Report? i have spoken to internal developers and they haven't and searching on the internet has resulte…CB Trett 51 views 1 comment 1 point Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Reporting on Approval TransactionsSummary Trying to report on pending transactions to pull the data from the notifications onto one report. Struggling to find tables to show Current and Proposed Values a…User_2025-01-23-20-43-34-115 179 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Position Change Action ReasonSummary Position Change Action ReasonContent What is the record.field that holds the action reason on the position? (See screen shot.) I cannot find it in any of the pos…User_2025-02-04-16-58-40-850 54 views 8 comments 0 points Most recent by User_2025-02-04-16-58-40-850 Reporting and Analytics for HCM
-
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as…
-
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…User_2025-02-04-08-51-08-912 193 views 3 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Issue adding OTBI Report to a dashboard through "Link & Image" ObjectContent Hi all, I am adding all of our reports (OTBI & BIP) to a dashboard as links to be easy to find. However, for one OTBI report, I am getting an error: "Selected it…User_2025-02-05-05-51-12-049 57 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli… -
Budget data is not coming in queryContent Hello i upload budget in general ledger but is not coming in gl_balance table and i select atual_type is Budget "B" please advise Thanks MahgoubMahgoub S.Mohamed 41 views 1 comment 2 points Most recent by Anant Iyer-3611 General Ledger & Intercompany -
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 35 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM