OBI Answers
Discussion List
-
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 1.1K views 12 comments 13 points Most recent by Samuel Bassey Reporting and Analytics for ERP -
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it… -
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…Sankeerthana Anumasula-Oracle 793 views 6 comments 2 points Most recent by Gurujothi D Reporting and Analytics for ERP
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 196 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 776 views 12 comments 11 points Most recent by Melissa Goodrich Reporting and Analytics for ERP -
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont…
-
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… -
'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…
-
How to setup a hyperlink in a column in OASHello all, Is it possible to setup a hyperlink as the result of a column in OAS for Taleo? I have read the following topic and tried what's in it: https://community.orac…Alice Gouzy 31 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics Taleo Enterprise
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 6.5K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 2 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 92 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
Sample SOAP request payload for OTBI Analysis extractSummary Sample SOAP request payload for OTBI Analysis extract using variables or filter criteriaContent I have an OTBI analysis based on the "Procurement - Purchasing Re…
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 23 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.2K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
TALEOHi All- We have created a report for Interview tab data to extract information however we are unable to pull one field from the subject area and even confirmed by the Or…SUNIL KOTHWAL-Oracle 11 views 2 comments 0 points Most recent by SUNIL KOTHWAL-Oracle Reporting and Analytics Taleo Enterprise -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 543 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 1.1K views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 295 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP
-
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 394 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 41 views 2 comments 0 points Most recent by Madhavi.Godbole Reporting and Analytics for ERP -
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 547 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 336 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like …