OTBI
Discussion List
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 443 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to pull only one field for Person Legislative Information > CountrySummary: I am attempting to pull an employee file that includes which country an employee lives in. I am using the subject area "Workforce Management - Person Real Time"…joshvanlaan 21 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Records for Cancel Workrelationship and Reverse Termination scenarios in new subject area in 24AIn 24A , oracle have introduced new subject area - Assignment Action Occurrence Real Time , allows you to report on all HR Actions and reasons associated with the worker…Manisha Singh 248 views 31 comments 0 points Most recent by Melissa Shropshire Reporting and Analytics for HCM
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…alliebaker 41 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
SQL with statement window function errorHello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found wh…alliebaker 12 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…User_2025-01-31-02-00-10-435 154 views 8 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
We need to create one OTBI analysis to display current and previous year calendar for Learning.Summary: We need to create one OTBI analysis to display current and previous year calendar for Learning . How can we achieve this? Content (please ensure you mask any co…Piyal Basak 32 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 23 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
OTBI Data as of yesterdaySummary: Hi there, I am trying to use the historical reporting capability of OTBI by inputting the logical SQL prefix of SET VARIABLE PARAM_EFFECTIVE_DATE='xxxx-xx-xx'; …Ruby Hui 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Busting OTBI Myths - Cross Subject Area ReportingContent Myth: You can't report across subject areas in OTBI I'd hope that this is not a myth anymore, but just in case, yes you can report across subject areas in OTBI. …Julian Challenger-Oracle 224 views 7 comments 7 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to align Prompt labelsI am trying to align the Date Between Prompt Labels as the ‘Please select dates’ and ‘Between’ labels not aligned at runtime. Prompt created based on Calendar date: the …
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 91 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Data Archival & retention for HCM CloudSummary Data Archival & retention for HCM CloudContent we wanted to know you what would be recommended best strategy for Data Archival & retention for HCM Cloud & do we …Ranveer.Tiwari-Oracle 54 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
Default prompt values not workingGood morning, I created a dashboard prompt that filters the values based on a query and works fine but I'm struggling to set the default values. In fact, even if I set "…
-
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…Ridma Karunanathan 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t…MaartenDIF 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…Shreya Datir 13 views 2 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B…
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 54 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?Summary: I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manag…Max W 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 898 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM -
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe Cannova 22 views 4 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM