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
-
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking… -
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati… -
Questionnaire report with Question that has multiple answers - duplicating rowsSummary: Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple…
-
Getting multiple values with HZ_LOCATIONS queryHello, I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is …
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation Thanks
-
Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.Summary: We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) functio…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there… -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i… -
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…
-
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…
-
Non-typeable flags - Audit ReportI cannot put the flag on "Show User-Related Details", "Show Attribute Details" and "Show additional object identifier columns", when exporting audit reports. What role/p…
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the … -
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person … -
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version… -
How to add background image in fusion home pageSummary: How to add background image in fusion home page Content (please ensure you mask any confidential information): Hi All, How to add background image in fusion hom…
-
We need to know table which stores Absence StatusContent Hi , We need to know which table stores status shown in attached screenshot. I have checked columns ABSENCE_STATUS_CD and APPROVAL_STATUS_CD in table anc_per_abs…
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
loader for licenses and certificationsSummary: I'm trying to figure out how to do a bulk load of employee licenses/certifications with the field below. I looked in HSDL and I'm not sure what I need to pick t…
-
ICP start date in fast formulaSummary: How to restrict start date in ICP page. We want to restrict employee entering the back dated changes for their pension contributions. Have any one done these ty…
-
How is the Assignment manager List Unsecured populated in OTBI?Summary: I am executing the standard OTBI analysis "Headcount KPI - Female Managers" and I am getting a wrong number of female managers. How is it working? We have 13 fe…
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…
-
In Compensation, for approval. Need to extract Applied data from hrc_txn_headAfter applying individual compensation, it went for approval. Applied data is stored in hrc_txn_header. We are not able to extract ElementTypeId, ElementEntryId, InputVa…