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 export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. … -
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u… -
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…
-
Join two different Subject areas - Workforce Learning - Learning Management real time and WorkforceSummary I am facing error when I tried joining two different subject areas (Learning and Person)Content In OTBI, I cannot able to Join two different Subject areas - Work… -
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with… -
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…
-
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once …
-
Number of Rows in a ReportSummary How to see the number of rows in a reportContent I am new to OBTI and am trying to build report up slowly and trying not to lose employee details as I go along o…
-
Report to fetch Open Notifications for the employeeSummary Report to fetch Open Notifications for the employeeContent Hi Guys, I have a requirement to send all the open notifications as a summary via email every week to … -
Analysis about own Person ProfileContent Hi, it seems that Worker cannot see information about own Person Profile on analysis (Workforce Profiles - Person Profile Real Time). Can we achieve this by cust…
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P… -
Grouping EthnicitiesSummary Grouping ethnicities after a single row of data has been calculatedContent Hi everyone, Using this post, I was able to successfully get an ethnicity report to re…User_2025-02-11-03-07-51-707 171 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707
-
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955
-
How to get link between Plan, Plan option and Elements for individual compensation plans?Summary How to get link between Plan, Plan option and Elements for individual compensation plans?Content Hi Team, We have a requirement where to fetch all the elements a…
-
One prompt for multiple views in OTBIContent Hello, I have developed an OTBI analysis which will have two different views (Pivot table & Graph). Can we have a single Prompt for both the views? I do not see …
-
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov…
-
Oracle Employee auditing that captures changes to a persons recordContent We currently have been looking at the history tab within person management and have realized that it does not give us much information. After connecting with Ora…
-
Effective Date of Latest Job CodeSummary Pulling Effective Date of Latest Job Code in an analysisContent I have created an analysis using the subject area ‘Compensation – Salary Details Real Time’. I ha… -
OTBI - HCM Manager dashboard Session 01 - 11/March/2021Summary OTBI Reporting overviewContent This OTBI working session conducted on March-11-2021 had an overwhelming response of 277 attendees. I hereby attach the resources …Raghavendra Raghunath-Oracle 67 views 0 comments 1 point Most recent by Raghavendra Raghunath-Oracle -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…
-
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …
-
How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Summary How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Content Hi Experts, We came to know that Oracle deprecated 'DATA_CACHE' column and…
-
Combining Oracle HCM and data from external sourceSummary How to create a data model for BI report using combination of Oracle and external dataContent Hello All, I need to generate a CSV file, to be sent periodically t…
-
BI excel template xsl when otherwise tags giving data in different format with extra spacesSummary BI excel template xsl when otherwise tags giving data in different format with extra spacesContent Hi All, In one of the custom BI report we are using excel temp…
-
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…
-
Managing privileges for AgentSummary Schedule an AgentContent Hello Everyone, Does anyone know which privilege from the list below removes the access from users to Schedule Agents? Thank you, Alvaro… -
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho…
-
OTBI analysis for Performance rating #Content Hello, We have a requirement to develop an OTBI analysis that gives the count of employees for each rating in a particular department. I am using the subject are…
-
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa…
-
Behaviors tagged under each competency in Talent profileContent Hi, Can someone help me with the database table where we get the Behaviors tagged under each competency? Regards, Nivya