OTBI
Discussion List
-
Fusion R12 Upgrade -BI | Icons appearing as dots ( . )Summary After upgrading to R12 Fusion, the BI icons like "Add" (+) and "Delete"(x) are appearing as dots (.)Content After upgrading to R12 fuion, the icons like "Add" (+… -
Performance Document Status with drill down capabilitySummary How to create drill down capabilityContent Hi. We are in the middle of our performance review process. I created a report (bar graph chart) for Leaders to use to…User_2025-01-28-20-43-56-568 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
OTBI limitationsSummary What are the main OTBI limitations compared to BI Publisher?Content Hi Folks, Is there any place where I can find the list of restrictions on using OTBI? For exa…Alvaro Couto 177 views 12 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
GL Balances to Journals Drill Down at parent/child levelSummary GL Balances to Journals Drill Down at parent/child levelContent We have built a Balances analysis in OTBI which can drill down to any level within the 8 segments…User_2025-01-29-22-21-49-698 132 views 1 comment 0 points Most recent by Sam Solomun Reporting and Analytics for ERP
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 98 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 94 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Customizing a standard reportSummary Customize option is not visibleContent Hi, I'm trying to customize "General Ledger Trial Balance Report ".I want to copy and save it under my custom folder for e…Armagan Sahin-57534 230 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Running an uploaded .RTF reportSummary Edited report cannot be run in the financial reporting centerContent Hi, I've downloaded a standard trial balance report and edited it.But when I try to run it I…Armagan Sahin-57534 35 views 1 comment 2 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da…Prudence K 88 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM
-
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an…Vivek Pathak-71652 23 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 76 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f…Prudence K 157 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Ability to report on historic versions of the Org Tree using OTBISummary Ability to report on historic versions of the Org Tree using OTBIContent Hello Team, Does OTBI has the ability to report on historic version of Org tree? I tried…Suveer Tn 83 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 94 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM -
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Tables and Views against OTBI Subject AreasContent Hi, Is there any resource available to refer Tables and Views against OTBI Subject Areas? Because referring OER is quite time consuming. Thanks and Regards AchalaAchala Munasinghe 101 views 3 comments 0 points Most recent by Vinit Kumar-47692 Reporting and Analytics for HCM
-
Absence and assignment details as of an effective dateContent Hi, I'm building an anaylsis in the Absence Real Time Subject Area using fields from the Worker folder and some key information from the Assignment Absence Detai…Louise Proctor-67515 65 views 3 comments 0 points Most recent by Louise Proctor-67515 Reporting and Analytics for HCM
-
performance document - get date of transferContent Hello, I am trying to find when a performance document have been transferred to a new manager. Is someone know in with table (bi publisher or otbi) I can get the…User_2025-01-25-01-33-46-269 41 views 4 comments 1 point Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Limit Prompt Choice List Values by UserSummary I'd like the choice list values for my prompts to be only the values the logged in user should see.Content My dashboard prompts are Business Unit, Department Nam…User_2025-01-25-00-37-41-739 91 views 2 comments 2 points Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
Using Two Subject Matter AreasSummary When I add the additional subject matter area (Workforce Management- Work Relationship) and then add rehire recommendation, I get an error.Content Hello All, I a…User_2025-03-07-21-07-25-805 52 views 4 comments 0 points Most recent by User_2025-03-07-21-07-25-805 Reporting and Analytics for HCM
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe…
-
Finding Active Assignments with Inactive ManagersContent I need to find Active Assignments where any of the Matrix Managers are inactive. (though I'd settle for line managers) I could create an analysis of Inactive ass… -
Effective Dated Headcount Report with SalaryContent Attempting to create an effective dated Headcount report with salary details that reports data as of a prompted point in time. Able to create the report to inclu…User_2025-01-28-08-31-49-398 136 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Hierarchy Traversal in BI Data Model ReportContent Please refer to the images attached. Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the orga…
-
Report showing Employee's Line Manager and Business Unit DirectorContent Hi All, I am struggling to create a report showing an Employee's direct Line Manager and Business Unit Director. When I create it, I get the hierarchy for that e…Aaron Leggett 106 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Competency ReportContent Morning all, I'm looking to build a basic report that shows the competencies we have built against each job profile, but I'm struggling to find what subject area…User_2025-01-28-05-39-23-766 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Date subtraction in eText templateContent Hi All, I am facing issues in date manipulation in the eText Template. Seeded date functions are not working and traditional date subtraction are not returning v…User_2025-01-25-06-20-12-259 507 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM