OTBI
Discussion List
-
Using AsofDate variable as a Dashboard promptSummary: Using AsOfDate variable as a Dashboard prompt Content (required): We have several OTBI reports that run using AsOfDate as the prompt variable. I would like to a…Denise Izzi 61 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How should I format the phone number in sql?HOW CAN I FORMAT THIS QUERY AS '+55 111 222 33 11' SELECT CASE WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 3) = '+55' THEN LTRIM (RTRIM ((PPH.SEARCH_PHONE_N…Cansel Karasoy 82 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Need subject area and column details for Start / Stop operationSummary: When start and Stop operations are used on Work Order - Operation, need to capture these duration in OTBI Analyses. Which column can be used to fetch this info?…Meera K Ganapathy-Oracle 31 views 4 comments 0 points Most recent by Meera K Ganapathy-Oracle Manufacturing -
OTBI Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Created OTBI report with only 1 field but the report errors Content (required): The Subject Area is Workforce Management - Person Real Time, and the field is % …Anna-MariaP 383 views 2 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM
-
Change Date format in OTBI reportSummary: Hi, I would like to know how can I change the Date format in OTBI reports. Currently in reports that I create, date format comes up as MM/DD/YYYY. However, I wo… -
How to Parse or Match specific string within a CASE statementSummary: A Dimension "Job"."job description" returns 'group1.group2.group3.group4'. All four groups are characters of varying length eg 'customer service.customer suppor… -
Exact Privilege for Human Resource Analyst Role to view own data in the OTBI reportSummary: Hello, Does anyone know what is the exact privilege required for Human Resource Analyst Role to view own data in the OTBI report. It appears that there are nume…Hazel De Castro 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 81 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Headcounts not tieing up with active assignmentsSummary: When we check the headcount for a specific year, on the Line Manager dashboard, the number is far less when compared to the number of persons with active assign…Amrita Gupta-Oracle 81 views 5 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 31 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 -
Looking for the OTBI Subject Area for eLearning Catalog ResourcesSummary I need to pull a report to get data on our SCORM coursesContent I need to pull a report that will give me data on our SCORM courses. I am not really finding ever… -
Replay Event: SCM – OTM: New Analytics Subject Area - Transportation Operational IntelligenceSummary: SCM – OTM: New Analytics Subject Area - Transportation Operational Intelligence Content (required): Location: Replay Event Version (include the version you are …Maria Matheny-Oracle 53 views 2 comments 1 point Most recent by AnandSharma Transportation Management -
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 51 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…
-
Logging licence number with course completionSummary: Is there a way to capture a licence number along with a course completion, which can then be reported on through OTBI? Content (required): Our Security staff re… -
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 31 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Account Analysis report SQL Code requiredSummary: Account Analysis report SQL Code required Content (required): Account Analysis report SQL Code required. We need to customize this report based on Natural Accou… -
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 64 views 2 comments 0 points Most recent by Tiesha Jones Reporting and Analytics for HCM
-
Dynamic recipient email to be picked from OTBI analysis columnsSummary: We prepared an OTBI report where tasks to be started on the current date, task owner, task owner email, and project manager email is displayed. We need to sched…Santhi Sree 355 views 7 comments 0 points Most recent by Mona Mantry Reporting and Analytics for ERP
-
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 151 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 271 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 956 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 11 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 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM