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
-
Any function is available that can be used in OTBI reports for calculating annual leave balance.Summary: Any function is available that can be used in OTBI reports for calculating Annual leave balance. It should work same as 'balance calculation' in oracle fusion h… -
primary address querySummary: Content (please ensure you mask any confidential information): Is it possible to tell when an address is set as primary? I see both PER_ADDRESSES_F and per_pers… -
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Compensation - Access Level AuditSummary: Need to know how we can check who has changed the access level Content (please ensure you mask any confidential information): Line Manager » Workforce Compensat…
-
Option to request overtime in OTL Oracle time and laborSummary: Do we have functionality in OTL Oracle time and labor to request overtime from standard OTL solution. or we can do it using DoR custom solution. Content (please…
-
Career Site | Reporting on Candidate Consent and Behavioral Data for Non-Essential CookiesHi team! We are currently implementing ORC for a client and we are working on the configuration of the career site cookie consent management. Non-essential cookies on th… -
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie… -
"Preview Offer" feature in HTML does not show correctlySummary: The "Preview Offer" task shows the Offer Letter in different formatting on different parts of the page when previewed in HTML. However, when downloaded in PDF f…
-
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 …
-
pages that are *not* in RedwoodSummary: A user reports seeing pages in NUX rather than Redwood, even though all the learning pages have been migrated to Redwood. How can the learner access the pages t…
-
Performance Participant Request CommentSummary: Content (please ensure you mask any confidential information): During performance evaluation process the manager can add a participant in order to have another …
-
BIP report: Profile ID not populated on candidates TableSummary: There is a profile ID on IRC_Candidates that the description says is he foreign key to HRT_PROFILES_B, but it appears to be null for newer candidates. https://d…
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…
-
HCM module OTBI / SQL report on employee informationSummary: SQL / OTBI report related to LE / BU / Employee first name & Last name / Person number/ Person ID/ Person type /contact with email / Department / User name if t…
-
Dynamic Signature Management in BI Publisher PDF Output Not Rendering via UCM/DOR Urgent RequirementSummary: Dynamic Signature Management in BI Publisher PDF Output Not Rendering via UCM/DOR Urgent Requirement Content (please ensure you mask any confidential informatio…
-
Ability to disable all the custom OTBI schedule reportsDo we have a process in place to inactivate all OTBI scheduled reports (agents)? We have a business requirement to inactivate all scheduled reports for a certain period …
-
Dynamic Signature Management in PDF Job Letter ReportSummary: Need Oracle-recommended approach to dynamically maintain and update signatures in a BI Publisher PDF Job Letter report without modifying the report template whe…
-
Organization Hierarchy in OTBI missing peopleSummary: Hello, We have updated our org tree on 01/01/2026 and we noticed that when we are adding a field from the 'Organization Hierarchy' subject area catalog folder, …
-
How to add multiple users as Recipients in OTBI AgentProblem: When user performs setup of OTBI Agent, then while adding other user under Recipients tab, system throws this error: Analysis: Access to OTBI agent is provided … -
Oracle Recruiting Offer Dashboard ReportingSummary: Oracle Recruiting Offer Dashboard Reporting Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well. This requ… -
Is PER_ACTION_OCCURRENCES.CREATED_BY reliable for identifying the initiator?Summary: We use PER_ACTION_OCCURRENCES in our HCM reporting to identify who initiated an assignment transaction (Employee, Manager or HR). Historically, CREATED_BY has b…
-
Is it possible / How to create BIP report output in .xlsx format?Is it possible / How to create BIP report output in .xlsx format? Currently we can only see .xls option while creating the template. Please advise.
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…
-
OTBI Folder DisappearanceSummary: Is anyone experiencing folders disappearing in the catalog? I pulled a report to see what happened to the folder, and there is no record of it being moved or de…
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
Consolidated Offer Report and DashboardSummary: Consolidated Offer Report and Dashboard Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well! We are lookin…
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
how can i join person number with transaction details in HCM OTBI?Summary: How can i have detailed information on what fields are changed in a transaction, and the person number of the user initiated the transaction? Content (please en…
-
Reporting the candidate offer transaction approval attachmentsSummary: Reporting the candidate offer transaction approval attachments Content (please ensure you mask any confidential information): Hi All, Greetings! This is about t…
-
Query to get attachment URLSummary: I have uploaded the attachment under Skill and Qualifications —> Licenses and Certifications. Need query to get attachment details related license and certifica…