Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
personal email otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
FDI - Is there a Manager Flag or Supervisor Indicator field available for selectionSummary: Is there a specific field within FDI that can be used to check if an Employee is also a Line Manager? e.g. If I used the the Subject Area MTS HR Analytics - Wor…
-
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… -
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…
-
Original hire dateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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… -
Can we access the file contents of UCM file in BIP Report?Content I have a requirement to read the contents of the file placed on UCM in BI Report and am struggling to find the right table for this purpose. In EBS there was a t… -
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…
-
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… -
Estado: HY000. Código: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] Se ha producido un errorSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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… -
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…
-
Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the…
-
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 …
-
Unable to see goals under approval/in draft in OTBI ReportsSummary We are not able to get the data for goals awaiting approval or in draft state using Workforce Management - Goal status overview real time Subject Area.Content Hi… -
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…
-
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…
-
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… -
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…
-
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… -
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…
-
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… -
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… -
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… -
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… -
How to display report parameters on the OTBI report output.How to display report parameters on the OTBI report output.
-
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…