OTBI
Discussion List
-
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …JHaden3 27 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
How do I extract a portion of a text field before a special character in OTBI?Summary: One of our Display Name fields shows Preferred Name Last Name (pronouns). What is the expression to extract the portion of the text before the "("? Content (ple…
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …Aishwarya_Saju 10 views 0 comments 0 points Started by Aishwarya_Saju Reporting and Analytics for HCM
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 55 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM
-
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e…Claudia Linares L 23 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…Aishwarya_Saju 3 views 0 comments 0 points Started by Aishwarya_Saju Reporting and Analytics for HCM
-
Seniority Date in Workforce Management - Worker Assignment RT is not returning any data in OTBISeniority Date.Seniority Date in Workforce Management - Worker Assignment RT is blank whereas Person Seniority Details.Seniority in Workforce Management - Person Seniori…MeghnaDe 26 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
How to add Active FTE column to OTBI PivotIs there a way to add a column to the Pivot in this OTBI report that shows CURRENT total FTE by Dept By Job? Here is a print screen of output example. New column hi-ligh…
-
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…Aishwarya_Saju 17 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 13 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Disabling caching for specific OTBI analysis not workingSummary: We tried to disable caching for an OTBI analysis in HCM with both 'Bypass Oracle Analytics Presentation Services Cache' and SET VARIABLE DISABLE_CACHE_HIT=1, DI…
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include …Luke.Findex 2 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…Luke.Findex 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to include historic versions of org tree in OTBI workforce trend analysis?Summary Analysis containing HC summaries spanning years does not accurately reflect earlier org tree versionsContent Subject Areas: * Workforce Management - Workforce Tr…James Hoffmann 55 views 8 comments 0 points Most recent by Claudia Linares L Reporting and Analytics for HCM
-
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 23 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…
-
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 25 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 16 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 109 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 5 views 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 7 views 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.6K 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. 27 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 17 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 768 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM