OTBI
Discussion List
-
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP…Joseph -Oracle 182 views 0 comments 1 point Started by Joseph -Oracle Reporting and Analytics for ERP
-
Subject Area for asset tag numberSummary: Which subject area of assets stores the asset tag number? Content (required): My requirement is to show the asset tag number on the retirements schedule of asse…CKleu 21 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Subject Areas Exposing PPM KPI'sSummary Do any of the delivered PPM Subject Areas expose the KPI and related informationContent I am not seeing any of the Project-based KPI information such as measures…Charles Heishman 100 views 3 comments 1 point Most recent by Santhi Sree Reporting and Analytics for ERP
-
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab…
-
OTBI - Subject Area - General Ledger - Balances Real TimeSummary: General Ledger - Balances Real Time - can anyone confirm this works correctly with Budget and Actual data Content (required): I am trying to construct reconcili…User_2025-02-10-15-12-48-631 51 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to get the link for a custom application pageSummary: How to get the link for a custom application page? Content (required): We have created a custom page in our Fusion Cloud instance, were we have gathered our cus…Anders W. Langholm 31 views 3 comments 1 point Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Is it possible to enable "All Values" as an option in a Table Prompt for an OTBI report?Summary: Table Prompt on OTBI report to include an option for the report to return "ALL" Content (required): We have a dropdown menu (table prompt) on an OTBI report tha…
-
Is there a foreign exchange gains and losses report available?Summary: As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the…Felicidat 51 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to format an OTBI report to see the total amount spent in a specific account by month?Summary: Within the expense reporting template, I am trying to create a report that will show the amount spent in a specific account by month. For example, the amount sp…Trent M 131 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to join multiple subject areas into one analysisSummary: Requirement to join multiple subject areas in one analysis Content (required): I need to successfully join the following three subject areas: Receivables - Tran…
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…raban 162 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr…amy hardtke 85 views 3 comments 1 point Most recent by Adrian Townsend Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 241 views 3 comments 0 points Most recent by SimonTomey Reporting and Analytics for ERP
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time"Summary: Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time" without allowing them to run Import Costs and Import Commitments schedule…MHaynes 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei…MaartenDIF 191 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…Vinay Gharge 51 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting and Analytics for ERP
-
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 271 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 42 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is there a limit to the number of columns in a data modelHello, I’m attempting to create a report using a SQL based data model. It has about 90 columns but when I run the report it leaves off the last 2 columns. Is there a lim…
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 21 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…Abhilash K - Deloitte USI 71 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…Sheneli98 1.5K views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an …
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…Nicolas Vahman 21 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…User_2025-02-10-15-12-48-631 41 views 3 comments 0 points Most recent by User_VX7QK Reporting and Analytics for ERP
-
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…Stefan pettersson 41 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP