OTBI
Discussion List
-
-
What is the field name to find the managers who have direct reports in OTBISummary Managers who have direct reports in OTBIContent Dear Experts, Please help me the field/attributes name of managers who have direct reports in OTBI I have tried i… -
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 23 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
HR Help Desk report availabilitySummary Looking for recommendations and examples of reports for managing HR Help DeskContent Does anyone have any tips or suggestions for creating reports for HR Help De…Len M. 39 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Sample Daily Digest for Agents - Unassigned and My Open TicketsSummary Daily digest report ready for subscribable agent to inform agent of open tickets currently assigned to them or unassigned but in their queueContent Our agents wo…Josh Vincent 61 views 2 comments 1 point Most recent by Josh Vincent Reporting & Analytics for Fusion Service -
How to calculate next Anniversary date in OTBISummary How to calculate next Anniversary date in OTBIContent Hi All, How to calculate next Anniversary date based on the employee hire date? Example: Number Hire date N…Reddykrishna Chidella-Oracle 239 views 3 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
How to extract the SVP of a employee recordContent Hello Community, I am trying to create a report from OTBI using the "Workforce Performance - Performance Check-In Real Time" subject area, however, the business …User_2025-02-05-16-57-43-236 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New infotileSummary Develop a custom infotileContent Hello In Payables workarea Recent infotile is provided. it only provides invoices created by the user. Can we develop a new info…Krishna943 42 views 2 comments 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
Weird Subject Area names appearing when using saved column featureContent When we are trying to use ‘saved columns’ we are observing weird subject area name folders in the catalog navigation. We are not able to identify in which folder…Srinivas Malyala-Oracle 37 views 2 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
"Sales - CRM Sales Activity"."Business Unit"."Business Unit Name" is nullSummary I am trying to do an Activities report but the Business Unit Name field is nullContent I am using the subject area "CRM - CRM Activity Real Time" but when I adde…Edgar11 44 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to validate the flexfield of a page on another pageContent I created a flex field in the header called type: This field has 3 options I choose the type in the header and now I'm going to create items, the system opens an… -
Need an example on how to create Cross Reference using import mapSummary CSV file to create a Cross Reference using import mapContent Hi All, Can some one share their csv file to create cross ref using import map. I need to know what …User_JXMHE 20 views 4 comments 0 points Most recent by Robert Edmiston Product Master Data Management
-
OTBI visibility problemContent Hello Guys, I need to create an Analysin linked to Worker data, but the system don't extract any data linked to the employee, I tried to add any type of role wit…Giuseppe Iacono 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Multiple rows converted to columns grouped by employeeSummary Would like to display multiple phone types by column instead of having separate rows for each oneContent Hi - I am creating a report that shows specific phone ty…
-
Salary & Assignment Changes JoinedSummary Report that pulls Salary and Assignment Changes Joined TogetherContent Hi all, Has anyone created a report that pulls both Salary and Assignment Changes joined t…User_2025-01-31-00-25-12-234 112 views 5 comments 2 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Primary Assignment FlagsContent Hello...when running a report, we are finding that it is pulling the primary assignment flag incorrectly...we are pulling from the employee employment page and t…Donna Allen1 39 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to have a WITH clause in OBIEE Logical SQL?Summary Is it possible to have a WITH clause in OBIEE Logical SQL?Content Hi all! Is it possible to have a WITH (subquery) clause in OBIEE Logical SQL? I have to exclude…
-
When applying case statement with group by and aggregate function it is showing error.Summary When applying case statement with group by and aggregate function it is showing error(No fact table exists).I am using 2 subject areas and included fact columns …
-
Getting Error "the User request exceeded the maximum query governing Execution time" while running tSummary Getting Error "the User request exceeded the maximum query governing Execution time" while running the OTBI reportContent Hi All, I have created one OTBI analysi…User_2025-02-06-15-04-02-124 99 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 39 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
OTBI report to fetch all details of Direct and Indirect reports details based on Line Manager sessioSummary OTBI report to fetch all details of Direct and Indirect reports based on Line Manager session userContent Hi All, I am trying to fetch all the (direct+indirect) …User_2025-02-06-15-04-02-124 63 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 54 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Listing historical Grade Step via Workforce Management - Worker Assignment Event Real TimeContent I'm using Workforce Management - Worker Assignment Event Real Time subject area to review an employee's historical assignment changes. Within the Assignment Even…Robert Craske 49 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning reporting - OTBI - Pulling details on in-progress self-paced trainingSummary What fields are available for in-progress self paced training?Content A consultant has developed a report for us, which I've helped by locating fields via test/p…
-
Reporting on "In Progress" Talent Review MeetingsSummary Talent Review ReportingContent Is it possible to pull talent review meeting data on meetings that are still "In Progress"? Right now all of our meeting notes and…User_2025-01-28-08-47-04-905 129 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM