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…
-
Can we combine Recruiting subject area with Position subject areaHello, Are the two following subject areas compatible for combination in an OTBI analysis ? - Worforce Management - Position Real time - Recruiting - Recruiting Real Tim… -
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…
-
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… -
OTBI send ouput by email as attachmentSummary: On 26C. We developed a custom report and like to schedule it to run and receive the output as an attachment in an email However, I'm not getting any email. Is t…
-
RTF Template with the excel output format generating null rows in each excel sheetWe have created a report with RTF template and set the output format to Excel. The excel output has multiple sheets, but there is an empty row in all the excel sheet. We…
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R… -
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… -
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…
-
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…
-
HSDL for Work Schedule AssignmentSummary: Does anyone have an HSDL template to assign Work Schedules? Content (please ensure you mask any confidential information): Version (include the version you are …
-
Where can we find Leave Balance in OTBI Subject areaDear , I want to leave balances for my users i created a otbi report (Workforce Management Absence Real time) but cant able to find leave balances in front i can see tha… -
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…
-
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…
-
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…
-
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… -
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 …
-
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…