Category 81
Discussion List
-
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 199 views 12 comments 0 points Most recent by Vittoria Reporting and Analytics for HCM -
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens… -
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Unable to fetch Enrollment Action time, Disclaimer status and Assigned date in a BI report.We need to retrieve the Action Time, Disclaimer Status, and Assigned Date fields from benefit enrollment records for a BI report. However, these columns do not appear to…
-
Does any OTBI subject area have these payroll schedule related columns?Do we have any OTBI subject area where we can fetch these columns? Period Schedule Name, Period Schedule ID, Usage, Frequency, Period Start Date, Period End Date, Paymen…MeghnaDe 20 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen…Pranav Waichal 25 views 5 comments 0 points Most recent by Pranav Waichal Reporting and Analytics for HCM -
Impact on BIP Schedule if Only Data Model is ChangedSummary: I’m planning to make changes to the data model of a BIP report. I want to confirm whether modifying only the data model will have any impact on the current repo…KHALED IHADDADENE 17 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
Why is "Compensation - Salary Details Real Time" so slowSummary: We have an employee roster/list that uses "Compensation - Salary Details Real Time" If we use 3 columns from that subject area (pairing with Person Seniority an…Monique 46 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 42 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 7 views 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Options to control and monitor the download of Custom BI ReportsHi, We have a custom BI Report containing multiple layouts The client has raised a request to understand anyone options on how to do the below Information on options: Te…Steven_Bullock 19 views 4 comments 0 points Most recent by Steven_Bullock Reporting and Analytics for HCM
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.5K views 10 comments 0 points Most recent by Robinson Ng Reporting and Analytics for HCM -
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Transaction table is not storing the details of all offer approvalsSummary: Hi Team, We have a requirement to get the offer approval history from transaction table. The issue we are facing is the table we are using does not have the det…Shikha Agarwal 67 views 5 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM -
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.8K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 49 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d…Ismael Jimenez 16 views 4 comments 0 points Most recent by Ismael Jimenez Reporting and Analytics for HCM -
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo…Raghavendra Raghunath-Oracle 1.4K views 14 comments 11 points Most recent by Ruvina Khan Reporting and Analytics for HCM -
Showing Attachments on Notification Worklist for "Request New Position" & "Request Position Change"Hello Community, I'm working with Oracle Cloud HCM and have a question regarding the visibility of attachments on approval notifications in the worklist. My Goal: I want…
-
Oracle FDI – HCM securityHello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restrict…Rajendraprasad N 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to display report parameters on the OTBI report output.How to display report parameters on the OTBI report output.Venkata Naga Praveen Kumar Bonthala 28 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 17 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever …
-
Number of workflow Notification Emails sent from HCMSummary: Looking for number of emails sent from HCM through workflow notifications by Module identifier. For Example - Number of emails triggered by personal information…vinay karumanchi 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 61 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to hide "Update your goals" action for selected performance documents onlySummary: Hi I have 3 performance documents in Oracle Fusion Performance Management . I would like to hide the "Update your goals" option in only 2 specific documents, Co…Mohammed Alharbi 27 views 2 comments 0 points Most recent by PrJohns Reporting and Analytics for HCM