OTBI
Discussion List
-
Positions report with no open requisitions or current incumbentsHello, Currently we are looking for a report regarding Position details where there is no Open requisition linked or no current incumbents mapped. Many thanks,Bala Krishna B 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not getting correct count in the termination count column.Summary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…Shreya Datir 53 views 13 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
OTBI Caclulation Issue [nQSError: 22025] Function Cast is called with an incompatible type. (HY000)Summary: Hi everyone, I'm finding troubles when summing 2 columns in OTBI. Content (please ensure you mask any confidential information): Hi everyone, I'm finding troubl…Vasco 12 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.Saher 25 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Presentation Variable Date Prompt no Longer Functions ProperlySummary: Recently all our absence reports within our Production environment that use a Date Presentation variable as a prompt have stopped producing the required results…Kevin Robertson 43 views 15 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "Summary Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "All Prompts" selectedContent Hi , I am facing a issue. I have …User_MC37Q 103 views 13 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to display month names instead of numeric values in OTBI analysisSummary: I have created a graph through OTBI analysis. But month is coming as numeric values. How to show month name ? Content (please ensure you mask any confidential i…Shreya Datir 35 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
Enable to get the output from the "Person Profile Real Time” subject areaSummary: Enable to get the output from the "Person Profile Real Time” subject area Content (please ensure you mask any confidential information): Hi experts, we want to … -
Is it possible to show/identify the job family for the Line Manager in OTBI Analysis ReportAs per business requirement I am creating a OTBI Analysis report to identify/highlight job family (Thru Conditional Formatting) for direct manager. For example, if a Dir… -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Multiple assignment abseSummary: Hi, I am trying to create a report for absences that are assigned at assignment level. As you can see from the image attached the moment a column is added from …
-
Unable to view job history of custom reports in Oracle FusionSummary: I have BI Author, BI Consumber, and BI Administrator Roles assigned to my profile. I'm trying to view Report Job History for a Customized version of the Receipt… -
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 42 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 131 views 20 comments 1 point Most recent by Kyle Norris Reporting and Analytics for HCM
-
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Agent to send to HR Business Partner via Username in the agent not sendingSummary: I am setting up a new agent to send via email to users. it is being created by conditional analysis. Get Recipients from the Analysis Used in the Agent Conditio…
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 63 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Combing Two Rows into One Based on Person NumberHello everyone, We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into…Yiming Xiong 21 views 10 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 32 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Issue while adding prompts to a pivot view of an OTBISummary: Not able to add and apply prompts to pivot view of an OTBI analysis Content (please ensure you mask any confidential information): The requirement I have is to …Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Payroll Relationship - Element Duration Dates - Final Close DateContent Hello, We're keen to build a report that shows the final close date using OTBIEE Answers (subject areas), however when included this appears to be on the relatio…Kevin M Storrie 193 views 12 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM -
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info…Madhuri Kovuri 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Payroll Element Entries Real TimeSummary Results not displayed after adding worker details in the reportContent Hi All, I am trying to pull employee element entry details. For that, I am using Payroll E…Prabhu Krishnamoorthy 56 views 13 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …Shreya Datir 32 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need …