OTBI
Discussion List
-
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…User_2025-02-11-07-08-23-440 92 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 155 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsSummary Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsContent As we are preparing for Talent Reviews, I have been trying…User_2025-02-08-03-57-26-191 31 views 8 comments 0 points Most recent by User_2025-02-08-03-57-26-191 Reporting and Analytics for HCM
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…User_2025-02-07-19-03-14-525 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…User_2025-02-06-14-37-05-233 44 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Current Performance Task by Org TreeContent Hello, I feel like this is a tough one to figure out. I have an analysis where I isolate the current performance task on a performance document. I'm trying to en…Rob F 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New hire report - Need to remove Global Transfers with changes afterwardsContent Hello, We are creating a new hire report that would show employees with a work relationship start date within the past year but we do not want to include global …Shanna Oppenheim 40 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
-
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. 41 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
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 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error when trying to save an analysis - don't have sufficient privilegesContent Recently we started to receive the following error after editing and analysis and trying to save it. "You do not currently have sufficient privileges to save a r… -
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 102 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 91 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 72 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 39 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 119 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Date & time of SubmissionSummary Date & time neededContent Hi, Is there a way to know the exact time and date the 360 review and performance review was submitted?Thanks AndrewVersion 20BUser_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Is it possible to create a BI report to search for a string in all the log files for the parent scheContent We submitted a Synchronize Person Assignments from Position and it internally spawned 25 processes. Instead of looking into the individual log files, we wanted t…User_2025-01-22-19-57-39-723 28 views 2 comments 0 points Most recent by User_2025-01-22-19-57-39-723 Reporting and Analytics for HCM
-
OTBI agents - update mass recipients list?Summary OTBI agents - update mass recipients list?Content Hello , In OTBI agents is it possible to update by an upload the recipients list of a mass of agents ? (Since w… -
Neel help schedule a BI reportContent How Can I schedule a BI report on daily basis and deliever it to an email address provided? Any help/Guidance will be much appreciated. Version 20BMegha Patel 26 views 12 comments 0 points Most recent by Megha Patel Reporting and Analytics for HCM
-
Need to know KFF Deployed person nameContent Hi All, We have "Deploy Flexfield" option in cost Allocation Key Flexfiled. We need to know the person name who deployed the flex field. In "FND_KF_FLEXFIELDS_VL…