OTBI
Discussion List
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
Dynamic PO PDF bodySummary: one of my customer wants the PO PDF Body message that goes to the supplier to be customized dynamically and it needs to be editable for each email that is sent … -
Invoice Lines with yellow exclamation markHi All, The Invoice lines have a yellow exclamation mark, with type Item and red box against Amount column. We are unable to find the error message it shows needs revali…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Allow tax withholding, Use Withholding Tax Flag, Withholding Tax Report Group, Federal ReportableSummary: Need help finding the table/s that holds the tax information below for Suppliers: 'Allow tax withholding', 'Use Withholding Tax Flag', 'Withholding Tax Report G… -
Data Not Visible in OTBI Dashboard for the userSummary: We have created one custom OTBI dashboard. When we give access to the user, he can access the dashboard but data is blank. What roles are requried? Content (ple…Santosh Vaidya 61 views 3 comments 0 points Most recent by Santosh Vaidya General Ledger & Intercompany -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 51 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP -
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to find Material Transaction for Dropship Sales OrderSummary: SQL to find Material Transaction for Dropship Sales Order Content (please ensure you mask any confidential information): we are looking to get a SQL to find Mat… -
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q…Upendra Nayak 504 views 5 comments 3 points Most recent by CSINGH_KCC Reporting and Analytics for ERP -
How to Retrieve Level 2 Manager's Designation in OTBI ReportSummary: I need to pull the designation of a level 2 manager using OTBI in Oracle Fusion. Looking for guidance on how to achieve this. Content (please ensure you mask an…Sankalp Shukla 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.user714053-Oracle 210 views 4 comments 4 points Most recent by Divyalakshmi Krishnamoorthy Reporting and Analytics for HCM -
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based…Pedro Teixeira 2.1K views 7 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM -
Export Manage Receivable ActivitiesIs there a way to export the results in Manage Receivable Activities setup & maintenance screen? Or is there a back end table I can create a data model and report off of…Matthew - Town of Aurora 41 views 1 comment 0 points Most recent by Matthew - Town of Aurora Receivables & Collections -
How to get detail of Data Access Security Policies applied at role level using sql querySummary: I need to get details of Data Access Security Policies attached at role level. I am using below query to get detail, but it seems its returning data which is en…rahul.gupta.scm 252 views 4 comments 0 points Most recent by rahul.gupta.scm General Ledger & Intercompany
-
Transfer order shipping line status in otbi analysisSummary: Need to be able to extract the transfer order line status from 'Manage Shipment lines' UI Content (please ensure you mask any confidential information): Current… -
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…JMLMIII 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Payables, Payments & Cash Management -
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g… -
Getting "The file uploaded may contain a virus or otherwise failed to be scanned for viruses."Summary: While trying to load the company logo image on an OTBI Report, i am getting the following error. "The file uploaded may contain a virus or otherwise failed to b…user10838976 81 views 9 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for HCM -
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…JMLMIII 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…Saurav R-Oracle 31 views 0 comments 0 points Most recent by Saurav R-Oracle Reporting and Analytics for HCM -
Join in OTBI is not removing data where joining two subject areas.Summary: When joining two subject area's the data is not removing information in one of the subject areas. Content (please ensure you mask any confidential information):…Max W 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Subtab Content Not Found in Subject Area of BI PublisherSummary: I am working on the Product Management >> Innovation Management. In the Subtabs Region, there is a Content - which consists of Text Editor for user to enter for… -
Is it possible to see a list of immovable inventory in OTBI or in the standard functions?Is it possible to see a list of immovable inventory that has not moved from subinventory for more than a certain period of time in OTBI or in the standard functions?Takaaki Kozaki-Oracle 11 views 2 comments 0 points Most recent by Regie Mercado Inventory Management -
How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…Nikki Reich 71 views 2 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Need to show people who are Missing FeedbackSummary: Hi Oracle Experts! I’m looking for some help on a custom report. As part of a routine audit, our HRBPs check to make sure that managers have left feedback for t…Monique 31 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM