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 get average years of service by company and gender in OTBI?Summary: I need to create an OTBI report to calculate years of service by company and gender. Content (please ensure you mask any confidential information): This is my s… -
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O… -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r…
-
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe…
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?
-
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…
-
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …
-
How to join Transaction ID with Assignment IdentifierSummary: We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so t…
-
Headcount is different across Line Manager Dashboard and reportingSummary: Hi, I am having an issue at the moment where the Line Manager Dashboard is showing me 5.8k Headcount and 5.1k FTE, but my OTBI report is picking up 6159 active …
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per…
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
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…
-
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…
-
Group similar columns together in bip report either through report editor or rtf templateSummary: We have a requirement to build a performance report in BIP to bring all the similar worker and manager comments in single row instead of the rows being repeated…
-
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
Public Key for sharing with ADP Global View - same key across all environments?Summary: Can we generate the SAME set of public encryption keys across ALL our non-PROD environments? https://us.v-cdn.net/6034893/uploads/3YMOJ095ARMJ/public-keys-downl… -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing? https://us.v-c…
-
Getting insufficent privledges error when executing SQL in Data ModelWe are trying to create a report that shows bursting queries scheduled in our system. The code was found here: Document 2210437.1 The SQL code we are trying to execute i…
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…
-
which hdl used to create individual balance adjustmentsSummary: We are looking for the hdl to create the individual balance adjustment for the person Content (please ensure you mask any confidential information): We are look…
-
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh…
-
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p… -
Parameters and lists of Value in the analysis are not inherited into the BI Publisher Data ModelHi, Expert I encountered the case that I developed an Analysis and Prompts within it. Subsequently, I built a new Data Model, designating the Analysis as the dataset, bu…
-
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…