OTBI
Discussion List
-
Unable to get the data from Workforce Management - Worker Assignment Real Time in OTBISummary Unable to get the data if we include Assignment Manager, Assignment Manager (Unsecured), Assignment Manager List, or Assignment Manager List (Unsecured) foldersC…Visu 326 views 10 comments 4 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 62 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Blank lines while printing success criterion in OTBIWhen I printing success criterion in OTBI reports, it is giving blank lines before and after text of success criterion. Probably, the reason is that it is defined as HTM…
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll…THawkins_LGI 234 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Top Of Stack Assignment Records - in OTBISummary Top of Stack Assignment Records - in OTBIContent Hello, How do you determine the "top of stack" assignment record? That is, the assignment record that is current…Daniel McMillian 207 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Check Digits field in Payroll - Personal Payment Details Real Time subject areaSummary: The Check Digits field cannot seem to be found in the Payroll - Personal Payment Details Real Time subject area. Content (required): The Check Digits field cann…Calvin Tam 51 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…Anna-MariaP 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only …AjayKumar Maddipati 32 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to make a totals columnSummary: Hi, I am trying to have a column that totals the values for a deduction at a Cost Center level. However, in my report, i continue to have repeating rows per Cos…Darrin N 21 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
where can i locate HR rep emailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Adam Calvert-Oracle 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
Candidate’s application Question code in OTBI or data moduleI am looking to build a report that has the candidate’s application questions and answers and I need the question code on it for analytic purposes. I can build an OTBI b…Chris Pomager-27736 31 views 7 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Sorting OTBI Report Worker Assignment Event Real Time Subject AreaSummary: I am struggling to sort my OTBI reports by more than one column, I am able to sort by Person Number OR start date but not Person Number then Start Date. It seem…
-
OTBI Report - Workforce Management - Worker Assignment Real TimeHello anyone, can we fetch Inactive - Payroll Eligible employees in OTBI using Workforce Management - Worker Assignment Real Time also their Annualized Salary Real Time?…Hazel De Castro 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
A comparison is being carried out between non-compatible types DATE and INTEGER. (HY000)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The below formula does not return any errors however when running the report I'm gettin…JHaden3 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manager Hierarchy starting with CEOSummary: We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager …User_2025-03-07-06-12-02-972 166 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Any Functional or Technical Design document for Seeded ORC DashboardAs we can see the seeded Dashboard for ORC - Recruit to Hire. But do we have any technical or Functional document available to see the logic (calculations) used in each …Venkatesh S S 52 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How to Get Flow Submission Date/Creation Date in OTBI ReportHow to Get Flow Submission Date/Creation Date in OTBI Report. I am using payroll Run Result Real Time Business Area. Scenario: Employee Resigned in the month of Sept2023…Jithindev 33 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
where to find "when is the employee start date" from offer letter in BISummary We need to report "start date" from offer letterContent Hello We have a requirement to include the "When is the employee start date" [hire date] from the offer l…Adil_R 135 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No results for some Facts-Candidate Tracking Activity such as number of applies, number of submits.Summary: Running a basic query against Recruiting - Candidate Tracking Real Time subject area. Number of successful submits does display, however Number of Applies, Numb…Melody Herbert 23 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Need help finding field in OTBI reportSummary: I have everything done on a custom OTBI report out of Performance Task Status Real Time except I need to pull the "Step" as shown in my image below. I cannot fi…Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee hierarchy under a manager - need help passing manager person number as a promptSummary: I am writing a report to show all reports (direct or indirect) under a manager. I am getting the list by hard coding the manager ee# in my OTBI report. Since it…Anita Modi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…
-
Why does the Compensation - Salary History Details Real Time not show the correct adjustment?Summary: In the subject area Compensation - Salary History Details Real Time it is showing a value which is not in the front end for adjustment. Content (please ensure y…
-
PPM Selected Bank AccountSummary How to Find selected bank account under personal payment methodContent Hello All, When employee update their bank details by clicking into their existing payment…