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
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
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…
-
Person Security Profile for Manage Job Offers, Pending WorkersSummary: Can anyone share sample SQL for Person Security Profile custom criteria to restrict HR's from viewing candidates and pending workers that dont belong to their c…
-
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…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…
-
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…
-
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…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…