OTBI
Discussion List
-
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 -
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 59 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 -
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 -
Maintenance Cloud / eAM SIG: Maintenance Cloud 101 A Live Demo!Summary Join TJ and Wes for a tour of the Oracle Maintenance Cloud Solution. Maintenance Cloud 101 A Live Demo will present a day in the life from the end users perspect… -
Using BI for Notifications/ AlertsSummary Required Training, Due and Overdue Notifications Using BIContent HI!! We have several BI Notifications set up for learning related to required learning being ass… -
OLC Learning NotificationsSummary Are there any standard emails automatically sent to learners regarding basic learning events?Content I was wondering if there are automatic emails sent to learne… -
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… -
How to ensure consistent output of default Date format in OTBISummary Default Date format is different for 2 different users who have same Regional PreferencesVersion Oracle Cloud Application 21B (11.13.21.04.0)User_UM4C6 34 views 1 comment 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Resignation Rejected ReportContent Hi Team, We are looking for some report by which we can fetch the data for all the Resignation status was Rejected. In our current environment, when the employee…Kiran Kancherla 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 54 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
OTBI Report On-Hand Inventory Value is Not matching with Inventory Valuation ReportSummary OTBI Report On-Hand Inventory Value is Not matching with Inventory Valuation ReportContent Hi, I have designed the OTBI report, to display the Current on-hand va… -
Generate Workpattern code like NYYYYYNSummary Generate Workpattern code like NYYYYYNContent Hello I am trying to generate an understandable work pattern code like NYYYYYN for reporting. Any quick pointers ho…Murthy Kodavati 21 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM