OTBI
Discussion List
-
Cross Receivable Subject Areas in OTBISummary: Cross Receivable Domain in OTBI Content (required): Hi, I would like to know if there is a way to link the domain "Receivables - Standard Receipts Application D…Antoine.Kaiber 91 views 1 comment 0 points Most recent by Antoine.Kaiber Reporting and Analytics for ERP -
OTBI Analysis: Connect 2 Subject Areas of General Ledger - Balance Real Time and General Ledger - PeContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". I would like to add column 'Accounting Period End Date'. This is ma… -
Supplier site bank account inactive date field in OTBIContent Hello, Could somebody assist me with the following problem, please: In an OTBI report, I would like to add the end date of a supplier site bank account. These va…User_RI0MI 237 views 4 comments 0 points Most recent by Shabharish, Pasupula Reporting and Analytics for ERP
-
No data in subject area Project Management - Task Management Real TimeSummary: Content (required): I cant see data in the OTBI subject area Project Management - Task Management Real time. Despite I can see the milestones the application. I…Nicolas Vahman 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to add Award project burden schedule and burden rate available in OTBI ?Summary: Our business needs ward project burden schedule and burden rate available on OTBI side. Has anyone configured them via flexfields? Content (required): Version (…Mona Mantry 71 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
OTBI Reporting for Financials Cloud - Tips and TechniquesSummary Aimed at report builders, the white paper addresses frequently asked questions in OTBI reporting for the Financials Cloud. It also includes tips to enhance repor…Anand DN-Oracle 3.7K views 23 comments 16 points Most recent by Deb Lang Reporting and Analytics for ERP
-
Audit OTBI CatalogSummary: Audit OTBI catalog folder Content (required): Is there a way to find out who deleted a custom folder in OTBI? Version (include the version you are using, if app…Hari Thyagaraj 61 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is it possible to combine the Payables - Invoices and Budgetary Control subject areas?Hello, I am trying to create deep links to the different expenditure transaction types in my budgetary control report and one of the transaction type is for Invoices. Th… -
Conditional Columns based on ParameterSummary Report Layout change based on ParameterContent Hi , I am using the "Receivables - Payment Schedules Real Time" subject area I want to have a parameter of Entered…Soumya Prakash Parhi 43 views 3 comments 4 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Where I Can find Financials OTBI database mapping with ViewObjectsSummary: I am unable to find spread sheet of Finacial OTBI OTBI database mapping with ViewObjects excel. For earlier versions, I have downloaded through docs.oracle.com-…
-
Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.Summary: Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code. Content (required): OTBI Version (include the version you are usin…Abhilash K - Deloitte USI 51 views 3 comments 0 points Most recent by Manu R-Oracle Reporting and Analytics for ERP -
Duplicate lines in Fixed Asset Depreciation reportI've created a simple analysis that pulls the depreciation details from the application and presents it in an overview. Here is the analysis XML: There's an issue where … -
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 191 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 52 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 32 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 52 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 135 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 167 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 …
-
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 193 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