OTBI
Discussion List
-
Element Entry for Each WorkerContent Hi Guys, I have to create a report that allow me to extract the Element Entries associated to each worker. But I have a problem, when I Add the "Worker"."name" c…Giuseppe Iacono 106 views 10 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
No data in Human Capital Management - Approval Notification Real Time after Sep-2019Summary No data in Human Capital Management - Approval Notification Real Time after Sep-2019Content Hello I am trying to write a report to show the approval date for sic…Helen Thomas 34 views 13 comments 2 points Most recent by Linda Dunn Reporting and Analytics for HCM -
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 140 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Instance name - TableSummary Instance name - TableContent Hi Team, I want to know the Instance details available table or DBI or UE. We are using email options in the extract to send the out…User_4VVG2 44 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …User_2025-02-07-19-03-14-525 19 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL for report columnsSummary SQL for report columnsContent I want to be able to query an analysis and get a list of columns that are used in that analysis.Chris Campbell 39 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is it possible to have email recipient in Agent based on Area of Responsibility?Summary I am creating an email notification for New Hires with benefits enrollment details using Subject Areas and I would like to have the email recipients based on the…Dana Resultay 55 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Avoid Drill down on pie chartSummary How to avoid drill down on pie chartsContent Hi folks, I tried to do some configuration in order to avoid drill down on pie charts (on column properties, see att…Nicola Petri 55 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Need table Name for Job Statuses on Data exchangeContent Hi All, We all see our HDL job statuses on the Data exchange under my client groups->Data exchange. Can anyone please let me know if there are any table names av…PankajRK 28 views 3 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
SQL Help required - pulling manager for rehiresSummary Query was built to pull in Areas of responsibility - Manager details but for rehires, it seems to be picking up their previous recordContent I have been trying t…User_2025-02-04-08-51-08-912 46 views 5 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
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…Pavel Buynitsky-Oracle 93 views 1 comment 10 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 36 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
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 …Shelly Feyerherm 201 views 10 comments 0 points Most recent by Sandip Khatri Reporting and Analytics for HCM -
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… -
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…Nicola Petri 36 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
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…Emily Robinson 29 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 74 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
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 Reporting and Analytics for HCM
-
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 …Valerio Curzi 37 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
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…Karen Waddell 89 views 3 comments 1 point Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
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, …Tejaswini-Oracle 55 views 3 comments 1 point Most recent by Tejaswini-Oracle Reporting and Analytics for HCM
-
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…User_2025-02-06-12-05-09-447 44 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
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-…SantoshKumarBhairi 40 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…User_2025-01-28-20-43-56-568 20 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Restricting Access to OTBI Dashboards / Reports not Working as ExpectedSummary Restricting Access to OTBI Dashboards / Reports not Working as ExpectedContent Hi, We use Custom Roles and have configured the following: - Employee Role: No Acc…Karen Waddell 125 views 26 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …SantoshKumarBhairi 58 views 19 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Changed username and now user cannot login to OTBISummary Changed username and now user cannot login to OTBIContent Hello, We had to change the username for an existing user and now the user is unable to login to OTBI. …User_2025-02-04-15-06-22-759 150 views 8 comments 2 points Most recent by Robert Fighiroae-Oracle Reporting and Analytics for HCM
-
Prompt - put conditions on promptSummary I use Display Name and want to filter only employeesContent Hi, I need to limit the prompt on "Display name" to active employees only. I added a SQL statement bu…Nicola Petri 47 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…User_2025-02-05-22-44-35-842 30 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM