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 way to restrict BIP output file either with Datamodel name or Template nameContent Hi All, When we click on OPEN on BIP report and enter required parameters and then click on apply button it will generate output in Excel format as DatamodelName… -
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…
-
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s… -
Acting Up AllowanceSummary report showing old & new salaryContent Hi, I'm trying to build a report that shows employees that have or currently 'acting up' - I'd like the report to show the…User_2025-02-05-22-44-35-842 38 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 -
OTBI - Expression needed to filter dateSummary OTBI - Expression needed to filter last day workedContent Can someone help me with an expression for an OTBI analysis? I need to a filter on the last day worked … -
Adding parameters for BIP Report built using OTBI AnalysisSummary How to add parameters within BIP Data Model built using for OTBI Analysis data set ?Content We have built a BI publisher report using a OTBI Analysis in the data… -
In process Termination ReportContent Has anyone developed a report that shows terminations in process and who it is currently pending approval with? Ideally we'd like a report that includes date/tim…User_2025-01-28-07-43-27-066 43 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Termination category blank - how to solve?Summary How to have termination category for active employees with termination as future recordContent Hi, we need to identify active employees that have a termination p…
-
Can we hide Factory delivered folders from Reports and Analytics based on role?Summary We have a requirement to hide all the factory delivered folders except Human Capital Management from Reports and Analytics.Content Requirement is : When login as…
-
Change ordering of values in horizontal axis of graphSummary Change ordering of values in horizontal axis of graphContent We have a simple graph from OTBI but want to change the display order of the values on the horizonta…
-
Master reports for Job, grade, location, department, position, active and ex-employee headcountContent Any Master reports available for Job, grade, location, department, position, active and ex-employee headcount?User_2025-02-06-14-37-05-233 75 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…
-
Need to have Bar code on Oracle Fusion HCM BIP ReportsSummary Need to have Bar code on Oracle Fusion HCM BIP Reports - methods used not workingContent Hi, We have tried 2 methods for displaying bar code in BIP report follow…
-
How to link consecutive absences with same absence type together in an analysisContent We are not using OT&L and have an interface bringing in absence hours into Oracle HCM. The absences are stored in 1 day intervals so when we have employees on a …
-
Table name for Comments in a Learning CommunityContent For every learning community, members can comment using the seeded Comments functionality. We have a requirement to report on the comments made by the users. We … -
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 54 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary … -
Get the list of persons included in an Access Group for a Learning OfferingContent Hi everybody, for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons that are includ… -
Talent Pool DashboardSummary Example of a Talent Pool DashboardContent Hi, Does anyone have an example Talent Pool Dashboard which they are able to share? Regards, Karen Waddell Version Rele… -
SQL Filter for the System Date (current Date)Summary SQL Filter for the System Date (current Date)Content Hi All We need to Create an OTBI report filter for the current system Date. The original requirement was to … -
How to Incorporate a Person Number Dynamically in the "Email Subject" using OTBI AgentContent We are trying to trigger an email alert using OTBI Agent, with a subject line which should pick up the person number from the analysis we have created. However, …
-
Filter Formula to automatically fill in the Hiring Manager based on user logged inSummary Is there a formula that will auto-populate a filter based on the user logged in (running the report)Content I am developing an additional tab within Hiring to po…
-
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…User_2025-02-04-07-19-57-588 51 views 4 comments 1 point Most recent by User_2025-02-04-07-19-57-588
-
Rel 20B (11.13.20.04.0)-> No data for Pending Workers in 'Workforce Management - Checklist Real TimeContent HCM OTBI Prod Dev Team, Can anyone please confirm if the issue documented in Doc ID 2600452.1 (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-… -
Duplicate Rows on DM/ReportContent Hi all - We want to build one data model and then use that to build multiple reports. This will help us ensure that if we update the code, we are updating all of… -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…
-
Employee Self Service Transaction reportContent Hi, I`m trying to find the subject area for self service transactions - we need to ensure that for a period of time some employees aren`t putting through self se…User_2025-02-06-11-18-47-896 51 views 3 comments 1 point Most recent by User_2025-02-06-11-18-47-896
-
Subject area for individual compensationContent Hi , I`m trying to build a report for bonus payments that we make to employees for various bonus plans we have - recognition, excellence etc. I can not find this…User_2025-02-06-11-18-47-896 70 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896
-
How to ensure a Manager is not seeing their own data when viewing a dashboard reportSummary Is there a way to ensure a Manager can't see their own data when viewing a dashboard report?Content Is there a way to ensure a Manager can't see their own data w…
-
Listagg Function on Business Intelligence Subject AreasSummary How to use Listagg Function on Subject areas on BI ReportsContent Hi Team, I have converted an OTBI an analysis to a BI Report. I would like to use Listagg funct…