OTBI
Discussion List
-
Talent Ratings - OTBI ReportContent Hello! Can anyone tell me where the Talent Ratings are stored so that I may report on them? Please see screenshot attached. I'm looking in the "Workforce Talent … -
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.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 24 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Document Sequence category Expense Report vs Payment Request (Document Sequence Category Name)Summary: I am configuring the "Document Sequence" for the Expenses module. Under the Assigment section, I see two categories : "Expense Report Invoices" and "Payment Req…
-
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 104 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 63 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 131 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 39 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 21 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 81 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM