Fusion Financial reporting
Discussion List
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter…Subhash Valiveti 402 views 15 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 347 views 6 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo… -
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B…Dharmendra Shukla 179 views 4 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge…
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…User_BUU5W 43 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 74 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI…User_2025-01-30-21-34-16-665 144 views 8 comments 6 points Most recent by Tessy Reporting and Analytics for ERP
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…User_2025-02-05-23-02-10-916 33 views 1 comment 0 points Most recent by Naveen Gowda Reporting and Analytics for ERP
-
Receipts Awaiting Bank Clearance Report in EBS R12Summary Receipts Awaiting Bank Clearance ReportContent HI All, Do we have the same/similar functionality report as "Receipts Awaiting Bank Clearance Report" from EBS in …Amarnath 13 views 1 comment 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
Miscellaneous Receipts Register EBS R12Summary Do we have any standard report for the same from oracle fusion cloud.Content Hi All, Do we have any standard report for the same from oracle fusion cloud. for Mi…Amarnath 22 views 2 comments 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
Physical or Soft Deletes handled in PVO DataSummary How are Physical or Soft Deletes handled in PVO Data ? Does it comes as a flag/identified along with incremental extract so that it can be deleted in the target …Upendra Nayak 36 views 0 comments 0 points Most recent by Upendra Nayak Reporting and Analytics for ERP -
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 385 views 8 comments 14 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Payables invoices consolidated to 1 currency in OTBISummary Write report for AP Invoices from different BUContent We have many business units in our system and each of them are having different ledger currency. We would l…User_2025-02-04-22-27-16-622 35 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Do we have the same/similar reports from fusion cloudSummary Do we have the same/similar reports from fusion cloudContent All, Do we have the same/similar reports from fusion cloud Miscellaneous Receipts Register EBS R12 R…
-
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon…Sudha KOVURU 100 views 9 comments 0 points Most recent by Hariharan Sekaran Reporting and Analytics for ERP -
Report timeoutContent Hi, One BI report is timing out in the shared folders. But the same report is completing perfectly fine in local folder. Any suggestions? Thank you. Added the be…Uma Manogaran 66 views 4 comments 0 points Most recent by Uma Manogaran Reporting and Analytics for ERP -
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari…Vamshi Mohan 75 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 628 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP
-
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 23 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 169 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP
-
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
Segment Security in BI ReportSummary Restrict the BI report based on the user logged in and their Natural Account/Department.Content Folks, We have a requirement to restrict the BI report by Segment…
-
Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…Balachander G-Oracle 789 views 3 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP
-
FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …User_2025-02-10-13-18-41-347 85 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…saravana maneeian subhramaniun 102 views 2 comments 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
FRS Reporting Query - Current yearSummary FRS Reporting Query - Current YearContent Hi team, In FRS Report, If the current open period is Jun 20 and the report is run for year 2020, it does not give any …Vinod Kumar Mohanraj 68 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…Dave Pucetas 36 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP