OTBI
Discussion List
-
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve…Shanna Oppenheim 32 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table Name and Column name required error while writing a CASE Function in OTBI AnalysisSummary: Requirement is to populate the data in a EFF attribute column based on the other column in OTBI analysis. Trying to get condition establish using CASE function.…sudheer.movva 181 views 5 comments 0 points Most recent by Sam Samaddar Product Master Data Management -
Adding Total Headcount and Response Percentage Columns in OTBI ReportHi Community, I am working on an OTBI report that aggregate responses from employees related to their self-identification. Current Setup: The report currently includes c…Ashok Kumar Sharma 25 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
V3 Seniority Dates in OTBISummary How to report on V3 dates in OTBIContent Hello, We're migrating to the V3 seniority dates with the release of 20B, but we're running into a number of reporting i…Whitney Van Way 103 views 8 comments 1 point Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 294 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
-
Associating the reconciliation history table with system transactionsIn the CE_RECON_HISTORY_ITEMS table stores the bank statements reconcile record. The field RECON_SOURCE shows where the matching item comes from. And I believe field SOU…July_Yanlin 71 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Year over year disability disclosure reportsOur requirement is to provide a report and graph with year over year counts of disability self disclosures. Attached is an xml version of my report. I'm joining the Work…Jenna Fuchs 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Identifying duplicate emailsSummary: An analysis that highlights the same emails being registrered to multiple persons Content (please ensure you mask any confidential information): I need an OTBI … -
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…
-
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 11 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
DFF on "Issue and Return Materials from Inventory" ScreenHi Gurus, Is there any way we can create a DFF on Issue and Return Materials from Inventory in Maintenance Module in Oracle fusion. Need to capture couple of additional …
-
Schedule otbi asset reportSchedule otbi asset report: If you schedule an OTBI Fixed Asset Report will it pick up the current Period if you tick the Use Trigger flag?
-
Report to reflect latest asset locationSummary: Report pulling through a line per location, even if it was updated Content (please ensure you mask any confidential information): We currently have an OTBI repo…
-
How to find Grade ID for EmployeesHi, I am trying to complete a Bulk Load and require 'Grade ID' for employees, I have the Grade Name and Grade Code but not the Grade ID associated, how can i extract thi…Jacob Good 143 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
I cannot avoid multiplexing when joining item and category tables.Hello The following SQL multiplexes up to the item organizations record. CAT.CATEGORY_NAME AS CATEGORY_NAME and CAT.CATEGORY_CODE AS CATEGORY_CODE multiplexes on the bas…
-
How can we customize a learn role by giving access only to Learn OTBI reportsSummary: We have a requirement to create a learn administrator role along with country specific Area of responsibility which is working fine, but we need to restrict the…
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 322 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Multi Row Attribute Group Attributes Enabled for BI not displayed in OTBI AnalysisSummary Multi Row Attribute Group Attributes Enabled for BI not displayed in BI Analysis Subject AreasContent Multi Row Attribute Group Attributes Enabled for BI not dis…Sudheer Movva-193114 40 views 5 comments 0 points Most recent by Leen Mardini Product Master Data Management
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 22 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Payroll Reporting name in OTBISummary Payroll Reporting name in OTBIContent Hi All, I can see a field "Reporting Name" in PAY_ALL_PAYROLLS_F table, I can able to pull this in BIP but not able to see …Prabhu Krishnamoorthy 50 views 4 comments 0 points Most recent by Anubha B Reporting and Analytics for HCM -
Create Analysis Report for Marketing Interactions with Account informationDear Community, we are trying to create an analysis report for Marketing Activities linked to various Contacts but it's hard to find a good subject area that works corre…George Papadogiannopoulos 11 views 1 comment 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 83 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Can a Vanity URL be setup for the OTBI or BIP ReportsSummary: One of the requirements is to have a Vanity URL setup for accessing the OTBI/BIP reports from external source. Content (please ensure you mask any confidential …SSN-Oracle 41 views 9 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…PeterXavier 11 views 2 comments 0 points Most recent by JohnCap Reporting & Analytics for Fusion Service