Category 81
Discussion List
-
BIP - Joining multiple data sets into one data set with SQLSummary: Am I able to LEFT join two separate data sets in BIP into one data set using SQL, rather then using the traditional field link functionality? Content (required)…Paul Morrissey 211 views 2 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM -
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… -
ORA-00911: invalid characterSummary: Hi Everyone! I am trying to retrieve a transaction. Below is the SQL Query SELECT a.TRANSACTION_ID,b.TRANSACTION_ID, DBMS_LOB.SUBSTR(a.data_cache,2000),DBMS_LOB…ShawShankk 807 views 14 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for HCM
-
How to connect oracle cloud HCM data from microsoft power bi reportSummary: How to connect oracle cloud HCM data from microsoft power bi report Content (required): How to connect oracle cloud HCM data from microsoft power bi report Vers…RIfdhy Zain 111 views 3 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM -
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 -
SQL function to convert number into descriptionSummary: Content (required): Hello experts, do you know if there is a way to convert an amount into description? For example, in addition to salary amount 40.000 we need…Valerio Curzi 61 views 2 comments 0 points Most recent by Gail Langendorf-Oracle 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…
-
Oracle HCM BI Tabel for manager compensation plan approval statusSummary: Content (required): Hello experts, could you suggest the BI tables allowing to track workforce compensation manager approval status? In other words, we should b…Valerio Curzi 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 52 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Identifying employees missing goalsSummary: We are creating an OTBI analysis to identify employees missing goals in the year 2022. As soon as we add goal plan information we are noticing that there is dro…
-
How to use latest version of Excel template for BIP ReportSummary: How to use latest version of Excel template for BIP Report Content (required): Currently we are using Excel 97-2003 Workbook (.XLS) as Excel Template Extension …Sujeeth Chinta 121 views 1 comment 0 points Most recent by Raghavan p-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 42 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 31 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
I have a requirement to add column to show Count of number of levels of direct and indirect reportsSummary: I have a requirement to add column to show Count of number of levels of direct and indirect reports I am not sure what logic to build. Please help. Content (req…Parul Sah 31 views 3 comments 0 points Most recent by Rajasekhar Bandaru-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 53 views 2 comments 0 points Most recent by Tiesha Jones Reporting and Analytics for HCM
-
Challenge with TIMESTAMPADD function not returning correct resultsSummary: When I add X number of years to a date field the formula produces a wrong date. Content (required): I build an OTBI analysis based on Workforce Management - Per…Maboagamo 61 views 13 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Does anyone have information about the Oracle stored procedure pay_balance_utility?Summary: Content (required): pay_balance_utility is mentioned in an Oracle doc but then the support team claims not to have access to any information about it. Version (…Scott Paulin 21 views 2 comments 0 points Most recent by Bhaskar Konar 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 141 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 273 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
CMP_PERS.CUSTOM_SEGMENT7 Oracle HCM table nameSummary: Content (required): Hello experts, in which Oracle HCM table can I find the attribute CMP_PERS.CUSTOM_SEGMENT7? Thanks in advance for your time! Kind Regards, V…Valerio Curzi 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 41 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Error message when downloading BI ReportSummary: Content (required): Hello experts, when downloading a BI custom report with some users I get the following error message: ORA-01847: day of month must be betwee…Valerio Curzi 51 views 9 comments 0 points Most recent by Valerio Curzi 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 -
Oracle BI EE option missed in Data source while creating report?Summary: Oracle BI EE option missed in Data source while creating report? Content (required): Oracle BI EE option missed in Data source while creating report? Version (i…
-
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