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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Help with Case When statementWe need to derive a Vacation Tier based on either the Assignment, Job, or Years of Service for an employee. It needs to first look at the Vacation Tier field on the Assi… -
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…
-
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…
-
Unable to pull Action Reason from Job OffersSummary: After enabling Action Reason on Job Offers based on 26A feature, we are able to view Action Reason on offers. We need to access this Action Reason in Fast Formu…
-
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… -
Human Capital Management - Transaction Administration Real Time - Assignee person is missingSummary: Hi, I am trying to create analysis to show all pending approval transactions using Human Capital Management - Transaction Administration Real Time, but I am una…
-
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 …
-
We have requirement to create goal report contain all information like measurement and tasksSummary: Any Help regarding creating goal report to have goal info and measurement and tasks Content (please ensure you mask any confidential information): Version (incl… -
ORA_ELEARNING type: course or offer?Summary: Content (please ensure you mask any confidential information): I create a course and an offer, both of type ORA_ELEARNING. How to tell if these 2 learning items… -
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…
-
Query to get the user login time for last 365 days in fusion HCM ApplicationSummary: we are trying to find out the login timings of a Common user, we use this user for scheduling purposes, need a query to fetch the login timings of this user. Co…
-
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…
-
Unable to configure scheduler profile in OTLSummary: Can any one share implementation guide or steps for configuration of scheduler profile in OTL Content (please ensure you mask any confidential information): Ver…
-
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…