OTBI
Discussion List
-
How to remove aggregation from OTBI analysis?Summary: How to remove aggregation from OTBI analysis? Content (please ensure you mask any confidential information): I have this table with first fields aggregated: I d…Stefano_Mazzocca 14 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Enterprise hire date of pending workersSummary: Enterprise hire dates of the pending workers obtained from OTBI analysis are equal to the dates of adding the pending workers Content (please ensure you mask an… -
OTBI: HR HelpDesk Request Real Time - Line ManagerSummary: We are creating an analysis report using HR HelpDesk Request Real Time Subject Area with the ff goals: 1. If the Line Manager runs the report, the report should…Garry Parta 6 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
how can I create an alert within OTBIHello, how can I create an alert within OTBI? I need to send email notifications to both the manager and the employee. Is there any documentation or guidance available f…italoanjos 12 views 2 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a… -
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Total current hours worked per employee in reportI am trying to run a report that will show every employee with the total number of hours they currently are contracted to work subtotalled (we have quite a number of emp…Karen Wilson 92 views 4 comments 0 points Most recent by Jose Guerra Reporting and Analytics for HCM -
BIP Web Layout Editor (.xpt) Pivot table Header's Vertical alignmentSummary: Is there really no Vertical Alignment in Measure labels header in a pivot table in .xpt report template? it looks in the center in edit but in the output: I tri…Carlo Reyes-59977 1 view 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
How to see who deletes datamodel/report in catalog?Summary: How to see who deletes datamodel/report in catalog? Content (please ensure you mask any confidential information): A datamodel is missing under analytics/catalo…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.4K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …Nicole A. 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report to pull BPFM hierarchySummary: Could you please help in pulling the BPFM Hierarchy using OTBI Content (please ensure you mask any confidential information): Version (include the version you a…Nagarani M 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of all Agents created in OTBISummary Ability to report on scheduled AGENTS - Listing of Agent, Report Recipient and Frequency (schedule)Content The Payroll/HR department is lookin for a report that …Raz Baboorian 739 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Emergency contact OTBI analysisHi Guys i am trying to create an OTBI to show employees with emergency contacts and the contact details of them too. I have tried using the subject area 'Workforce Manag…Jeevan Loyal 11 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
OTBI Report on Seniority Rule ValuesSummary: Can we report on the values associated with a given seniority date rule using OTBI? Content (please ensure you mask any confidential information): I'd like to c…Monique 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…TC 66 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.1K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
How can I change the default aggregation rule (such as sum) in the Default Aggregation Rule settingSummary: I need to change the default (sum) through default simple without sum and it isn't working in OTBI using the Worker Assignment Event Real Time SA. Thanks Conten…ClaudiaManea 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo…Barile Alberto 64 views 2 comments 0 points Most recent by Francisco Barrios Reporting and Analytics for HCM
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Inaccessible columnSummary: This report is to fetch the personal contribution of an user. It is working file for everyone but one user. She is getting an error which is attached. I have tr…
-
Employees Missing in Compensation – Salary Details Real Time when using Matrix Manager FieldsSummary: Using Compensation – Salary Details Real Time , I’m experiencing an issue where employees drop from the report when matrix manager fields are added. For example…Mike Wulf 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …
-
Recruitment Candidate Question and Answers OTBI Report StructureSummary: I have been trying to change the layout of my OTBI report to have the candidate questions per column with their answers per row to avoid having multiple rows pe…GabrielaGilchrist 4 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
subject area for learning item in Development PlanSummary: Hi all, I am trying to retrieve the subject area for a specific section of Development Plan. 1. 2. So far I have retrieved all table info related to "Basic info…Silvia Stangarone CAI 11 views 2 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Extract of all Pre-Screening Questions and possible answersSummary: We would like to extract our entire library of pre-screening questions and the options on the multiple choice attached to the question. We have tried creating a…Diana Mitrovski 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
I need to find who created or updated a BIP or an OTBI report and whenSummary: We need to find details like who created a BIP report or a Dashboard or an OTBI report and when. Content (please ensure you mask any confidential information): …
-
OTBI report to pull BPFM hierarchySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagarani M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report cancelled work relationship person details in OTBISummary How to report cancelled work relationship person details in OTBIContent Hi Team, We have cancelled work relationship for some employees we wrongly loaded in wron…Pol Reddy 213 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM