OTBI
Discussion List
-
Required to create a report to capture Trade Operations and related PO's in OTBISummary: We are required to maintain a report to capture the Trade Operations and the related Purchase Orders. The report should also capture the status of the Trade Ope… -
how to get Good receipt note details with procurement details on OTBI reportSummary: Content (required): Hello everyone, We have a OTBI report in the production instance related to PR details. The subject area, " Procurement - procure to pay rea…
-
Manager Details (more than one)Summary Writing an OTBI Report which pulls all of an employee's managersContent Hello, We record two managers for each employee at our company. One is the line manager a…John Gerbracht 102 views 8 comments 0 points Most recent by Kris Cregger Reporting and Analytics for HCM
-
In what table are the item/categories association in the audit trail stored?Summary: The item audit trail report does not give enough information for the auditor to analyze all the information correctly. For example, the item description is not …
-
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 41 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 61 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 327 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 31 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 31 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 41 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM
-
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 31 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to show only the MAX response attempt for a questionniare response in OTBI analysisSummary: We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to p…Amy Wilson 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need OBTI Course Record Count ReportSummary: I do not know what I'm doing wrong. I need a report where I can get the Overall count and % or completions and not completed, but I keep getting errors. Does an…
-
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 303 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 91 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report tabs on Learning admin dashboardSummary Report tabs on Learning admin dashboardContent Hi All I've noticed in a few Oracle videos, the Learning admin dashboard has a number of different tabs (see attac… -
DFF at Supplier Address not visible in OTBI report Subject AreasSummary: Content (required): Hi, I have created an OTBI report for Supplier Master details. I have defined few DFFs at supplier profile level, site level and at address … -
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 33 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM
-
Number of invoices processed per FTE that performs the process “Process accounts payable (AP)”Summary: Number of invoices processed per FTE that performs the process “Process accounts payable (AP)” Content (required): We are making an attempt to calculate the per…SaurabhSinghal26 92 views 1 comment 0 points Most recent by SaurabhSinghal26 Payables, Payments & Cash Management