OTBI
Discussion List
-
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 1.9K 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 174 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 42 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 Started 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…
-
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 12 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
-
How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE DatabaseSummary: How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE Database. The Below part is having an issue. Please help me how to write regular expression in Oracle BI EE ON…Niranjan_DTCC 112 views 3 comments 0 points Most recent by Niranjan_DTCC Reporting and Analytics for HCM
-
Oracle Fusion to customize format payment data modelSummary: Hello everyone. For implementation on a client, a new custom check format needs to be created. It is necessary to add some fields that are not shown in the xml.…Juan López 263 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
BI Consumer role is not giving access to create data model in my folderWe are trying to give read only access to BI reports in OTM. We provided BI Consumer role to user by using which we able to access the reports and able to run. But we ar…vikram khengare 51 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
Sample Oracle BI Reports for Spend Authorization RequestsSummary Dashboard for Spend Authorization RequestsContent This dashboard will allow you to view the following key details: * Number of spend authorization requests by St…Aishwarya Pawar-Oracle 68 views 1 comment 1 point Most recent by Marcela Narváez Supplier Management
-
Default communication Method as E-Mail in Purchase OrderSummary: Is there any way to default the Communication method as E-Mail when I create a Purchase Order without using Communication Method in Supplier Site Content (pleas…
-
The PO E-Mail notification cannot be delivered to the recipientsSummary: When all buyers create PO's all suppliers can't receive PO email notification and send an email to the buyers as shown in the image below Hope to get a solution…
-
Subledger DFF enabled not shown in OTBI subject areasSummary: BIenabled subedger line level DFF cannot be found in OTBI subledger accounting subject areas Content (please ensure you mask any confidential information): A li…Dian Minshan 1 view 2 comments 0 points Most recent by Viviane Vasconcelos Subledger Accounting & Accounting Hub -
'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19bSummary Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject AreasContent Hi All--> Payables Invoices Holds Informat…