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
-
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 show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…
-
How to clear cache in BI report?Hi Team, I have added roles with full access to BI report folder permission but user who has the role unable to view the folders. Could you please advise how to clear th…
-
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…
-
admin is unable to see contents in user foldersSummary: In the past we have been able to see the contents in a users folder when in Admin view. Now we can no longer see the files. Has anyone else experienced this iss…
-
How to download the files that are uploaded in DOR against employeehi i have a query which shows al the files uploaded in DOR of emplyee . select fad.DOCUMENT_ID , fdv.DM_DOCUMENT_ID CONTENT_ID, fdv.datatype_code , fdv.FILE_NAME , fdv.T…
-
Integrate OTBI with ODASummary: I need more clarity on the feasibility of the integration of OTBI/BI publisher with ODA. Is it possible to access OTBI report from ODA ? Content (please ensure …
-
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…
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…
-
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… -
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…
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …
-
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… -
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…
-
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…
-
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:…
-
table record to use for non benefits employees to new benefitsSummary: Hi, Writing a report to check the list of employees who are newly enrolled in the benefits. please share the table name which give the field name to separate th…
-
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…
-
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…
-
Generate query related ODA reportsSummary: I want to generate analytics report for responses for specific queries like feedback query to understand bot responses and communication with user to improve pe…
-
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 … -
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…
-
Absence notification is not sent to Line Manager after Employee withdraws it.Summary: In the Absence approvals, when an absence is requested by an employee and is approved by their Line Manager, when the employee attempts to withdraws the absence…
-
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…
-
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 …
-
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 …
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o… -
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…