OTBI
Discussion List
-
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…Mike Borghoff 35 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up…CIT Shane 184 views 25 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…User_2025-01-28-21-18-43-496 73 views 4 comments 1 point Most recent by User_X612P Reporting and Analytics for HCM -
Comparing two datesSummary Comparing two datesContent Hello, I am trying to create a new column whereby I am comparing the effective start date from 'Worker Assignment Event Real Time' sub…Helen Tilling 42 views 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (inSummary OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (in Workforce Management - Worker Assignment Real Time)Content B…User_A80ZS 39 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueSummary How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueContent Hi Team, How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attr… -
How to add a BI Report to a Fusion Page without navigating through Report and Analytics navigator (RSummary The Report should be embedded into fusion application page using create page entry (Link Type: Application Page)Content I want to add a report to Fusion applicat…Somefun 525 views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
BIP - data model joining different data sourcesSummary BIP - data model joining different data sourcesContent Is it possible to join data from two different data sources 1) from a SQL query 2) from an Oracle BI analy…
-
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti…Gail Langendorf-Oracle 460 views 4 comments 6 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary How to Find an IP Address of a User who has Logged in Fusion Application ?Content Hey, I have a requirement to restrict the data based on login IP address in BIP… -
Unable to get the Employee payroll calculation card details from Payroll - Calculation Cards Real TiContent Hi All, We are unable to get Employee payroll calculation card details ( State name, county name and city name details) from Payroll - Calculation Cards Real Tim…User_6I33I 251 views 2 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 93 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find Disability Declaration?Content Hello, I am currently building a report in which I need to report on Disability Declaration for all current employees e.g. Yes/No/Not Declared. I have managed to…User_2025-02-10-23-42-02-934 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Parameter not picking up exact value from XMLContent We have a BIP report with three parameters Learning Item Name, Completion Date and Person Number. The report is working fine for more Learning Item Name's except…User_2025-01-31-00-25-12-234 17 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA) Can you please advise if possible to notify th…Bernard T 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t…
-
how to restrict infolet user wise?Summary how to restrict infolet user wise?Sidhartha Wadhwa 40 views 5 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Performance Analysis Report Issue with Using MINUS clause to extract wanted data.Summary Need help Understanding why no data is returned from Analysis when using MINUS between 2 Subject AreasContent Hello, I have attached a word document with screen …User_2025-02-04-11-20-13-378 21 views 6 comments 0 points Most recent by User_2025-02-04-11-20-13-378 Reporting and Analytics for HCM
-
Profile Option for OTBI user settingsSummary Profile Option for OTBI user settingsContent Is there a profile option to set the default locale in OTBI? Global User settings get reset each day. It would be di…User_2025-02-05-23-02-10-916 20 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Performance GuidelinesContent The attached document pulls together our experience helping customers to improve the performance of OTBI reports into one succinct document. If you are looking t…Julian Challenger-Oracle 800 views 7 comments 14 points Most recent by Mahendra Reporting and Analytics for HCM -
Last Names in OTBI?Summary Location of paternal and maternal last names in OTBIContent Hi everyone! I have been trying to make a report in OTBI and I need the full name of an employee in s…User_2025-02-11-02-54-34-044 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can I enable guest access to OTBI AnalysisSummary I have an OTBI analysis and I would like to access that analysis using a guest login in OTBIVersion 20CV Pandalai 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Conditional formatting in Logical SQL OTBI reportSummary Conditional formatting does not reflect in OTBI report where Logical SQL is usedContent We have a requirement where we had to write a logical SQL query to show p…Akash Kiran Jana 64 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTL Approved time cards details with Reported hours and Calculated Hours BI Report QuerySummary OTL Approved time cards details with Reported hours and Calculated Hours BI Report QueryContent Dear Team, We need Oracle Fusion OTL Approved time cards details …VenkatReddy Pulichintha 851 views 4 comments 0 points Most recent by VenkatReddy Pulichintha Reporting and Analytics for HCM -
I need to get sysdate-effective_start_date in OTBI reportSummary I need to get sysdate-effective_start_date in OTBI reportContent I need to get sysdate-effective_start_date in OTBI report which function should we use? Thanks, …Pradvin Prabhakar 35 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
In which Subject Area/ Table holds Vertex Local Withholding Tax Rates Tables informationContent Hi All, Oracle provided Vertex Payroll Tax Series document. In that we need to fetch "Vertex Local Withholding Tax Rates Tables" information. Can you please sugg…
-
Scheduling Report to Respective Line ManagersSummary Scheduling Report to Respective Line ManagersContent Hi Team, We have a requirement that respective line managers should receive a report on weekly basis about p… -
Need inputs to hold the Received Date (Benefits)Content Hi All, In which Subject area/Table holds "Received date" value. Navigation: Benefit Administration-->Enrollment-->Query an employee-->Pending action Items-->sel…
-
Performance Tasks measures by top departement display wrong valuesSummary Create an Analysis to display measures for performance tasks/Top level DepartementContent Hi gurus, I would like to build an analysis that will allow me to displ…User_2025-01-28-23-51-35-873 18 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Performance Dashbord to ManagerSummary Add deep link of employee's performance form to a reportContent Hello Is there an option to add to a report (BIP or OBIE) to add to each employee deeplink to his…