OTBI
Discussion List
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 37 views 1 comment 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP -
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …Steven Woods 33 views 2 comments 0 points Most recent by Mona Mantry Reporting and Analytics for ERP
-
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We…Rahul Kumar Gupta.-Oracle 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 63 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… -
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 5K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components.erp_expert03 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi…Andy Gough 2K views 19 comments 14 points Most recent by Khalid Mahmood Reporting and Analytics for ERP -
Embedding Dashboard onto Tile - Application Role list incompleteSummary: Hi all, I am embedding some BIP reports onto tiles and have a couple of questions regarding the application roles in this step - This list is incomplete e.g. Ac…Ian.Gooderham 12 views 1 comment 1 point Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How can I find AP invoices Approvals by user and approval group details in Fusion cloud?Summary: To identify the Invoice is approved user or approval group and which Rules hitting by the BPM Content (please ensure you mask any confidential information): To …Harish Pati 157 views 2 comments 0 points Most recent by Harshali Shirgannavar-Support-Oracle Payables, Payments & Cash Management
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en…NancyR_Bravo 2 views 2 comments 0 points Most recent by NancyR_Bravo Reporting and Analytics for ERP -
Otbi analysis filter for budget date greater than creation dateSummary: We are looking for advice on the most effective way to set up an analysis that lists all requisitions that have a budget date of more than 30 days from their cr…
-
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…Steven Woods 56 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP
-
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…Silas Henrique Silva 26 views 2 comments 0 points Most recent by Silas Henrique Silva Reporting and Analytics for ERP
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long …KerryanneLee 11 views 3 comments 0 points Most recent by KerryanneLee Reporting and Analytics for ERP -
Fixed Asset Register report is not working when you select a date in the past like OCT 2023.Summary: Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation.…
-
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 3 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used …LaurentDup 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 131 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed… -
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
Additional levels listed in OTBI for GL segments in GL Subject AreasSummary: We have levels listed for all of our GL segments in OTBI. We would like to know where these come from and if there is a way to remove them from OTBI if possible…Kristina P 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Future dates (i.e. 1/1/3000) appear as null or blank in OTBI analysis results for ContractsSummary: Using the "Enterprise Contracts - Contracts Real Time" subject area, the analysis/report doesn't display some End Dates even though they appear on the Contracts…Dawn Tilson 12 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts
-
24A ERP OTBI subject areas to database tables mapping spreadsheetsSummary: 24A ERP OTBI subject areas to database tables mapping spreadsheets Content (please ensure you mask any confidential information): Where can I find 24A SCM and P…Bea 68 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 6 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Project Resource varianceI have created an analysis that reflects the variance of actual cost to the budget at resource level and also the variance of the same cost but related to the whole proj…Mohamed Abdelbar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP