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 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? Content (please ensure you mask any confidential information): In t… -
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?
-
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… -
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…
-
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Goal Approval workflow notification issue with CLOB type data which have > or < symbol ?Summary: Goal approval workflow notification is having success criteria field where field is having below combination of text : 7800 and when notification triggered and …
-
Few privileges are not available in the database tableSummary: There is issue with the privileges: Few privileges are not visible when query directly from roles/privilege screen while the same is visible when query a role. …
-
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon… -
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…
-
Road map to upgrade BIP Excel 97 version to excel 2010HI Team, I am for road map plan to upgrade BIP Excel 97 version to excel 2010. Currently BIP excel supports 97-2003 version only. Most of the advance excel function like… -
Scheduling OTBI reports to roles /user groups- How does access work ?Summary: If we have a simple headcount report built using Assignment real time subject area, and it is scheduled to a role (meaning multiple users with the same role but…