OTBI
Discussion List
-
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 - National Heritage Academies 33 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 11 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 116 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 1 view 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
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…Alexandre Chea-Oracle 186 views 10 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
BI Report Exported Data Wrong in Date but Become Correct after ReopenSummary: When I exported the report data. I find that when I chose the period like from 2024.06.01-2024.06.30. but the export date period in the report parameter will be…
-
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : But, I dont know how…
-
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We …Ashley Dore 22 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for ERP -
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 32 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 56 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 13 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot…
-
Does anyone have a template for annual retirement plan audit information?Summary: I need a report to show Total Gross Earnings, Deferral Eligible Earnings, Employee Contributions, Employee Roth Contributions, Employer Matching Contributions a…Chris West 1 view 0 comments 0 points Started by Chris West Payroll and Global Payroll Interface (GPI)
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…Hitesh Khandelwal 11 views 2 comments 0 points Most recent by Hitesh Khandelwal Reporting and Analytics for ERP
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…Cesar Saveedra 457 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r… -
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …Anjan Polimera 61 views 5 comments 0 points Most recent by Bhaskar Konar 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…
-
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
How to implement the Column Group in OTBISummary: I am checking a seeded report "Top 10 Requisitions Breakdown". can anyone help me how to implement the below column group functionality in OTBI report? Also, Ho…
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 73 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Left Outer Join between the same tableHello, I am trying to get a list of all expense reports and populate the Expense Report History.Event Date only when the Event Status is a specific one. So I attempted t…