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
-
How to get FULL_NAME from PER_PERSON_NAMES_F_V if user row is not on PER_USERS?Summary: We have a very simple section of report code that uses the LAST_UPDATED_BY field on FA_TRANSACTION_HEADERS table ("FTH" in the code below) to get a user's full … -
HCM Report Sharing CenterHello - does anyone know if there's still a place where all shared reports appear together in a table such as in the screen shot below? We have recently implemented cert… -
How create a Recruiting Report with ReasonSummary: Content (required): Hello Guys, We would create a Report that extract the reason linked to the last event for each worker, how we can create it, in our database… -
How to find requisitions pending approvalSummary: We are trying to find/create a report that can show the requisitions currently pending approval. I found the column that stores the status in Job Requisitions -…
-
HCM &Power BISummary Possible that Oracle HCM cant feed automatically to a Dashboard using PowerBIContent Hello, I am just wondering is there any posibility that Power BI can be refr…
-
"Close Date" in Payroll RelationshipsSummary: Morning, We are trying to report on the "Close Date" in Payroll Relationships but I am struggling to find it in OTBI. Would it be possible to have it in the OTB…
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …
-
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…
-
Is there a way we can have the Country in Mixed Case in Formatted Single line Address in Job Offer.Is there a way we can have the Country in Mixed Case in Formatted Single line Address in Seeded Job Offer Letter Templates. The Single Line Formatting has the Country al…
-
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion… -
Unallocated AORI've got sql to extract those who have an AOR allocated to them but im looking to do a cleanse on active AOR where a colleague isn't allocated. Does anybody have any tho…
-
To pull direct and indirect managers list from Compensation Worksheet pageSummary: Hello Team, We have a requirement to pull all the indirect and direct managers in a single column along with their direct line manager from Compensation Workshe…
-
Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…
-
BI Publisher - Can you FULL outer join?Summary: Full outer join in a BI Publisher is not behaving how I expect a full outer join should. Content (required): I need to do a full outer join on two sets of data … -
OTBI report Timing outSummary: Content (required): I am pulling some payroll data using an OTBI but it keeps timing out- How do I increase the time? I can't schedule since I created a DM usin…
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…
-
Dashboard PromptSummary: Content (required): Version (include the version you are using, if applicable): Oracle HCM 21D Code Snippet (add any code snippets that support your topic, if a…
-
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w…
-
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa…
-
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He… -
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r… -
Subject area for user defined columns under worksheet display (Compensation)Summary: Hi everyone - We have some criteria defined under one of our compensation plans in a user-defined column for the worksheet. The user defined column contains the…
-
Is it possible to report on HCM Recruitment transaction team system activity?Summary: We want to report on activities undertaken in Oracle Fusion by People (HR/HCM) transaction administration colleagues. This specifically relates to job offer rec…
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…
-
OTBI Report Usage - Count of Dashboards run (not executions)Summary: I've found the Usage and Performance Dashboard Sample (catalog files attached) and it looks pretty great but we're struggling to make it work for us. We want to…
-
Recruiting Dashboard PDF downloadSummary: Content (required): Hello, The functionality used to download a Recruiting Dashboard page doesn't work anymore. We usually used this html code:
-
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…
-
Dashboard / reports on Anytime Doc, Check In...etc.Content Hello! I am reaching you because I am preparing a demo for a client and I would need a dashboard about all the "continuous" performance functionalities (feedback… -
OTBI Dashboard Embedded not workingHello, OTBI Dashboard embedded using Page Composer is not working, where as when I'm running Dashboard in analytics its working fine. I've attached the screenshots and c…
-
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …