OTBI
Discussion List
-
OTBI Active Assignment between date rangeSummary OTBI Active Assignment between date rangeContent I am attempting to isolate a population based on date range. Anyone who had an active assignment between date x …Nicolas Trojack-24006 139 views 3 comments 0 points Most recent by Nicolas Trojack-24006 Reporting and Analytics for HCM -
OTBI Report to show the internal promotions and external hires for the same positionContent Hi All, We have a requirement in OTBI to display No. of employees who are promoted to "Director" internally vs No. of employees who got hired as a "Director" (By…Visu 139 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Manager Hierarchy Drill Down ReportSummary Need an OTBI Report to Drill down based on the Manager Selection. The detailed table should be dynamic to increase the columns data based on selection promt mana…User_2025-01-23-22-36-48-692 367 views 24 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis from Top to Bottom Mgr HiearchySummary Need an OTBI Analysis for the Mgr Hierarchy from Top to Mottom based on the selected ManagerContent Hi Team. We have requirement to print the below Manager Hiear…User_2025-01-23-22-36-48-692 104 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
A new Dashboard publishing with SecuritySummary Hi, I have created a new dashboard which we want to publish as an HR dashboard.Content Hi, I have created a new dashboard which we want to publish as an HR dashb…User_2025-01-29-01-34-30-592 174 views 6 comments 0 points Most recent by AbulKhair Reporting and Analytics for HCM
-
A solution for exporting reports from one environment to another when versions are differentContent Hi, I've been trying to transfer reports and dashboards across environments recently, but have come into this error: Incompatible version when reading object "Ca…Billy Dix 33 views 5 comments 0 points Most recent by User_2025-01-23-22-38-50-675 Reporting and Analytics for HCM
-
As of Date Presentation VariableContent Hi Is it possible to create a presentation variable for a date to get a report from the past? For instance, I need a report to show what the data was on the 1st …Aaron Leggett 143 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Flexfields are not working (after the upgrade to R12) any longerSummary Flexfields are not working (after the upgrade to R12) any longerContent Hi All, Since we are on R12, my flexfields for cost center and company code are not worki…User_2025-01-23-22-38-50-675 46 views 5 comments 1 point Most recent by User_2025-01-23-22-38-50-675 Reporting and Analytics for HCM
-
performance and Talent - Goal Management goal plan createdSummary I am attempting create a report to show me those assigned to a goal plan. I am not having any luck. any idea?Content i am using the field count of distinct worke…Nicolas Trojack-24006 84 views 4 comments 0 points Most recent by Nicolas Trojack-24006 Reporting and Analytics for HCM
-
Unable to view OTBI Report Parameters/Prompts from CWB PlanContent Hi All, I have created custom Compensation OTBI Report as per the requirement. I uploaded report in "/Custom/Human Capital Management/Compensation" folder and at…Visu 61 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Salary Basis vs FLSA vs Payroll Name AuditSummary We need to audit when there is a mismatch on these fieldsContent Hi - we have an ask to provide an audit on employees that have a mismatch in their data: * FLSA …Prudence K 91 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Common Alignment for both RTF and PDF not working in LettersSummary Common Alignment for both RTF and PDF not working in LettersContent Hi, I have developed one appointment letter, when i run this report the alignment of RTF Temp…User_2025-01-28-00-11-59-141 52 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
SQL Function to allow more than 4000 charactersSummary Need SQL Function to allow more than 4000 charactersContent Hi, I have built sql custom report and my requirement is to bring employee overall comments using BI …User_2025-01-28-00-11-59-141 41 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Pivot Table Issues with Position NamesContent Hi all, We have a position in an organisation analysis which works perfectly but when we try and pivot the table to show a higher level view, the position names …User_2025-01-28-07-12-45-467 75 views 7 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
Showing Percentages in a Bar PivotSummary Is there a trick to show percentages on a scroll over of a bar pivot with actual values?Content Hello all, I am using OTBI to develop some reports and the user p…Nicolas Trojack-24006 88 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Add Trimestre prompt in BI publisher depending on assingment tableSummary I want to add a prompt in bi publisher report which is Trimestre and depends on per_all_assignments_m (effective_start_date)Content Hello, How can i define on sq… -
getting odbc error when trying to run dashboard downloaded from Cust ConnectSummary getting error: Failed to load(Odbc driver returned an error (SQLExecDirectW).)Content downloaded analytics some time ago from Customer Connect - "sample OTBI Das…John Sale 64 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Goals - Not Assigned/Tasked to EmployeesContent Good Day, Is there a way we can pull a list back within an analysis to show all employees that have 'NOT' been given a goal for mid/end of year review from the P…User_2025-01-28-07-12-45-467 71 views 10 comments 0 points Most recent by User_2025-01-29-01-27-20-754 Reporting and Analytics for HCM
-
Translate Bi Publisher and OTBI report ?Summary Columns , title and values can be translated in OTBI and BI Publisher reports?Content Hello, Is it possible to translate columns in reports and title and values …User_I6AXL 55 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 179 views 2 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
What is the significance of Role Type = ManagerSummary Need to understand why almost every Performance and Goals related subject area uses Role Type = ManagerContent In every Subject Area associated to Performance or…Sivakumaran Muthusamy-Oracle 51 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Slow performance in OTBI AnalysisSummary Slow performance in OTBI AnalysisContent Hello, I have created some Analysis in OTBI. I see that are very slow or they go in time out. The reports have 4 attribu…Giuseppe 1234 216 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM
-
Combine Multiple RowsSummary How do I combine multiple rows for a person into one row?Content We have a report that pulls in our terminations for the day. There are some employees that are s…Prudence K 103 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Users cannot run BIP reportsSummary Users cannot run BIP reportsContent Employees with our custom role cannot run a BIP reports, however, I am able to run the same reporting using delivered employe…AbulKhair 58 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
how can i get individual PDRs onto my PDR report?Summary PDRsContent Hi I have created a PDR report which brings back the lines for the last 3 years of every employees PDR (personal development review) using Workforce …User_2025-01-29-02-09-34-137 10 views 0 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
I am having trouble creating a report, please helpSummary Trouble with reportContent Hi, I am having trouble with creating a report to show Headcount on one line and FTE on another line and salary costs by year in a tab…User_2025-01-29-02-09-34-137 54 views 7 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
Dashboards with No Data Analysis ReportsContent GoodDay, i have created numerous amounts of dashboards and analysis reports in R11 and R12. My only query/issue is when you use the prompts to filter down on sai…User_2025-01-28-07-12-45-467 87 views 3 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
How to include the name of the logged-in user generating the report in the header?Content Hi, I need to create the user field that executes the report in the header of these, in what area of the report does it allow me to include this value? Header Ex…Mirtha Antequera Borges 68 views 2 comments 0 points Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM -
Can Security Roles cause Duplicates in OTBI Analysis?Summary Troubleshooting Duplicates in AnalysisContent I have a user who is running a custom Analysis and getting duplicate and triplicate employee records returned. When…User_2025-01-28-17-24-53-863 71 views 2 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Extract OBI permission of a UserSummary Extract OBI permission of a UserContent Hello, I want to extract all OBI permission and Duty for a user. Is there a delivered functionality to extract this from …Giuseppe 1234 36 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM