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
-
Unable to Extract 2026 Holiday EntitlementSummary: Hello there - I'm trying to evidence each workers 2026 holiday entitlement but the standard HCM accrual reports only seem to be set up to report accural balance… -
Extract scheduled ReportHi Experts , Can someone help me with scheduled extract report? Looking for actual start date and end date of the scheduled job. Referred the below link which has next s… -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t…
-
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…
-
Role assignment historySummary We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that user was term…
-
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l… -
How to extract the details of the Employee and there Line Manager / Supervisor details ?Summary: Hello All, We are trying to extract the details of the Employee and there Line Manager / Supervisor details for all the employees. Is there any Standard report … -
Changes to the Seeded BIP Template for ManageDORReport are not reflecting in the notificaitonSummary: I made copy of the default template for the ManageDORReport and uploaded as a new DEFAULT template for the report in the custom folder. But the changes are not …
-
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…
-
Workforce Compensation BI Publisher Add Ins not functioning for Word or ExcelSummary: MSWord & MSExcel - BI Publisher Add Ins no longer functioning. Have uninstalled, reinstalled. Still not functioning. Content (please ensure you mask any confide…
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…
-
When I search for a custom role code in the BIP report folder permissions, it throws an error.When I search for a custom role code in the BIP report folder permissions, it throws an error "No results are available for given search string". Any idea how to fix thi…
-
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …
-
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…
-
How to hide View Drafted Requisition for hiring managers.Hi team, Could someone please help me to hide view Drafted Requisition for hiring managers? Please check the below screenshot from hiring manager's credentials. The requ…
-
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha…
-
Query for HDL to purge DOR of terminated employees .I am looking for a report that generates HDL to purge /Archive DOR for terminated employees from certain date range .
-
EU Pay Transparency Report Startup PackSummary: In webinar it was told that oracle has Startup packs for Reporting, How we can get them? Pay Transparency Webinar - Oracle Video Hub Content (please ensure you …
-
Subject area to fetch Legal Employer Seniority Date at Work Relationship LevelHi, We have moved to Seniority Dates V3 version. We tried to use OTBI to create reports to fetch the Legal Employer Seniority Dates at Work Relationship level. The subje…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
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…
-
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…
-
Bold letters are showing in PDF Output?Summary: We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, all the letters are…
-
Repeating Groups - Excel TemplateHello. Does anyone have any idea on how to make this kind of layout on Excel Templates using BI Publisher? How to make a repeating group like this? -
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma… -
How to use Work schedule in Eligibility for Fast FormulaSummary: Hi Team, we have a requirement : We have a Absence Type- That should be eligible to only employees who are having work schedule A. How to make it possible in El…