OTBI
Discussion List
-
Display Values Across ColumnsSummary: I am querying voluntary deductions and using input value names of Amount, Percentage, Total Owed and Vendor Name. Because the Displayed Input Value is one colum…Julie Mandel 37 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Link between Balance and Primary details Element NameSummary: Link between Balance and Primary details element name Content (required): In Balance Definitions UI we have Primary Details Element Name. In which table/OTBI Su…
-
OTBI Termination Report - Adding Level 04 Manager NameSummary: Hello I created a report and I want to add "Level 04 Manager Name". I'm using the subject area Worker Management - Worker Assignment Real time and selecting Ass…KMore 61 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Last Paid DateSummary: Looking to pull a report on active employees that shows the last date they were paid/payslip was generated? Content (required): Version (include the version you…Jessica D 50 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Error during query in OTBISummary: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P Content (required): Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8T…
-
Interview Date filter to show only dateSummary: We have a OTBI dashboard created and one of the analysis within the same has filters created. There is a Interview start date filter, which is from the Intervie…User_2025-07-18-16-26-02-907 34 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Remove Alerts section from dashboardSummary: I created a dashboard with a prompt. When i run the dashboard the alert section is showing despite me not adding an alert section Content (required): How do i r…Tiesha Jones 60 views 2 comments 0 points Most recent by Tiesha Jones Reporting and Analytics for HCM
-
Is it possible to see pending workers' assignment details in Checklist OTBI reports?Summary: Is it possible to see pending workers' assignment details in Checklist OTBI reports? Content (required): When running a checklist OTBI report of open/closed tas…Alona Aronov-Oracle 154 views 4 comments 0 points Most recent by Alona Aronov-Oracle Reporting and Analytics for HCM
-
OTBI Export to Excel shows the blank values in the columnSummary: We have some reports in the payroll module. When users run the OTBI report (view results), they can correctly see the data in the output/viewer for all the colu…Ram Shankar 279 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Webinar - Introducing Logical SQLSummary This is the monthly OTBI best practice training webinar delivered by Oracle Development. Jan.27 training topic: how to use Logical SQL to control data join with …User720640-Oracle 951 views 12 comments 18 points Most recent by Srihari Murthy Reporting and Analytics for HCM -
Are the running records kept in the OIC environment like the scheduled reports?Hi, Is it possible to take the last runtime of the service I prepared in OIC and add a condition in this direction to my sql report?I s such information available? For e…Cansel Karasoy 16 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 54 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Examples of Termination reportsSummary: Content (required): Hello experts, please, could you share some examples of Worker Termination reports? Thanks in advance for your time! Kind Regards, Valerio V…Valerio Curzi 44 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report for getting list of all Customized objectsIS there a report which can list out all the objects on which either Page Customization or Customization via Designer Studio was done?
-
Payroll Deductions by Benefit PlansSummary: Looking to report on employee benefit deductions and their respective plan by pay period. Content (required): We have been tasked to report on employee pre-tax …
-
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…Rajib_Samanta 36 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to adjust a query to return only work email address and add Person NumberSummary: Hi, I'm looking for some help to adjust the below query to only return work email address (W1) and if possible add in Person Number Content (required): select E…Sharon Ferguson 767 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need formula for Date Paid is in last calendar monthSummary: I have a report using Subject Area Payroll - Payroll Balances Real Time. The report will run on the first day of every month and will capture the number of hour…
-
OTBI Report - Phone logicHi Team, I have one report have couple of assignment details, Now I have to add one column phone number. Criteria to fetch phone number is, If the work mobile number is …
-
Favourites window only fills half of screenSummary: In OTBI the favourites window only fills half of the screen Content (required): When entering OTBI the favourites window only fills half of the screen, bottom h…DennisOliver 38 views 4 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…RyanPE 38 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Error with Next 90 Day SyntaxSummary: I'm getting an error when I use the below formula to get the next 90 days form a specific date field in my filter. Content (required): The error I'm getting bel…
-
Dear Experts I want to check do we able to get the translated report in OTBI ScenerioSummary: We have built questionnaires with a translation of the language and prepared the report to see who attended the evaluation and their responses. Currently, we ca…Mohammed Tariq 35 views 2 comments 0 points Most recent by Rajeshkumar_Sekar06 Reporting and Analytics for HCM
-
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 55 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Manager hierarchy in Recruitment using OTBISummary: Need guidance on which field or logic to be used to include manager hierarchy in an OTBI recruitment report Content (required): OTBI Manager Hierarchy Recruitme…
-
Agent Completed with Warnings - Details?Summary I need to find details on the warnings of an agent failingContent Hi all, We recently upgraded to 19C and a group of our agents are now Completed with Warnings. …User_2025-01-31-00-25-12-234 107 views 8 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Parent Manager Job Name/TitleSummary: I have a report using Workforce Management - Worker Assignment Real Time and need to know if there is a way to add the Parent Manager Job Name (Title) to the re…JHaden3 60 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM