OTBI
Discussion List
-
Session Variables for Recruiting Subject AreasSummary: We have an open requisition report that we would like to use a session variable for so that the recruiter who is viewing the report only sees their requisitions…Allison O'Brien 82 views 2 comments 0 points Most recent by Allison O'Brien Reporting and Analytics for HCM -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda… -
How can i create a current and previous report for location change for a dashboard?Summary: I need to create a location change report using the visa permit type (not null) in the Person Real Time subject area and the Assignment Event Real Time subject …Mark Stoker 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Ethnicity ReportingSummary: Event headcount is incorrect. Showing 2 when employee has more than one ethnicity selected. Content (required): I'd love a second set of eyes on this. On recomm…Susan Anderson 132 views 2 comments 0 points Most recent by Christine Tutani Reporting and Analytics for HCM -
How to create an advanced OTBI reportSummary: Short video describing how to create an advanced OTBI report using a calculated column and binning. Content (required): https://www.youtube.com/watch?v=YNcSgOvw…Julian Challenger-Oracle 33 views 0 comments 3 points Started by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 21 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Report on scheduled Extracts and BI reportsHow to get a report on all the extract and BIP reports scheduled in system with frequency of schedule? Regards, NivyaNivya Mathire 21 views 1 comment 2 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Goals Report showing Draft StatusSummary All Drafts Status Goals before a certain dateContent Hi, I've been asked to build a report that shows anyone who had a 'Draft' status to their 2020 Goals prior t…User_2025-02-05-22-44-35-842 37 views 4 comments 0 points Most recent by Lavanya Reddy Reporting and Analytics for HCM -
Pull data for a specific person number when there are multiple Person numbers in the dataSummary: I am trying to pull management level for the manager's job vs the employee using OTBI report Content (required): I am using workforce assignment real time - how…Riti Malhotra 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…Kamini Kaushik-Oracle 25 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to get the employees' latest assignment data and the effective start date of the TOS position thSummary How to get the employees' latest assignment data and the effective start date of the TOS position through OTBIContent Hello, I'm trying to create a report using …Rajesh Kumar Bhagtani 65 views 2 comments 0 points Most recent by Gayathri Ganesan Reporting and Analytics for HCM
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
Security profile to restrict line manager to view only one assignment of employees in OTBI reportSummary: Hi All, My line manager is able to see the records for performance document for all Active assignments of employees. How to restrict my OBTI output so only the …Kamini Kaushik-Oracle 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…Kamini Kaushik-Oracle 12 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 32 views 1 comment 0 points Most recent by Preston Schultz Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Remove Person number From Human Capital Management - Approval Notification Archive Real TimeSummary: In Subject area Human Capital Management - Approval Notification Archive Real Time, column Subject "Approval Notification Details"."Task Title" can we remove Pe…RakeshK 33 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
DoR DDF correlation table HDOR.DEI_INFORMATION_NUMBER2Summary: Hello experts I'm trying to query some Document of records for brazil taht have fixed DDFs SELECT HDOR.DEI_INFORMATION_NUMBER2 as "STATE" HDOR.DEI_INFORMATION_N…Pedro Teixeira 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
What is the best way to show all employees for a specific element even if they do not have it?Summary: I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't Content (required):…Mark Stoker 32 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.5K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
Pie Chart Percent Display OverlapContent Hi - I need to display the percentage for each pie chart slice in an OTBI report for export to powerpoint, but some percentages overlap when displayed. Is there …Julia SRI International 65 views 2 comments 0 points Most recent by Ms_Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Sample CSV file for Purging Learning recordsSummary: Content (required): Hi there, I am looking for a sample csv file for purging Learning records Is there any available? Thanks in advance. Bobby Here is the featu…Bobby Jourdan 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to associate an historical event State within a particular Phase in "Recruiting - Recruiting EveContent The requirement is to calculate totals based on Phase/State of historical events for auditing purposes. For example, in a "Job Application Status History" analys… -
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 21 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 507 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM