Fusion Financial reporting
Discussion List
-
Ad Hoc Smartview ERPWe recently set up a SmartView connection for Oracle Hyperion Financial Reporting, Fusion Edition so our folks can access different FRS reports from smartview. They also… -
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss Added Font Ma…
-
Unable to run any custom FRS report after migrating the report from Test to ProdSummary: We have created almost 20 FRS reports in the TEST environment. After completion of the UAT, we are trying to migrate the report to PROD environment. After migra…
-
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 22 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 185 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…Sam Solomun 116 views 6 comments 0 points Most recent by 'Yehia Zakaria Reporting and Analytics for ERP -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Intermittent Error with Custom OTBI ReportSummary: We are experiencing issues with one of our custom OTBI reports, which had been functioning perfectly until recently. Users have reported that the report intermi…
-
How can we migrate an EBS Financial Statement Generator (FSG) report in Fusion CloudWe are migrating client system from EBS (R12) to Fusion Cloud. In the EBS environment client has a custom Financial Statement Generator (FSG) report. Client has the requ…
-
Help finding FND_ATTACHED_DOCUMENT table in ApBicc PVO in FDI?I need some help to find out if a PVO exists that is accessible in FDI that contains the FND_ATTACHED_DOCUMENTS table - namely I'm after a column called "URL Attachments…
-
How can we use multiple account hierarchies for a single segment in a FRS report?Hi Team, Our client is looking to create another hierarchy for Primary balancing segment which would be date effective from 1st of Jan 2025. They want to keep using the … -
Posted query in inappropriate groupPosted query in inappropriate groupSheshan Ukkalkar 12 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP -
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca…Stephanie Golly-Oracle 527 views 4 comments 4 points Most recent by M.Stafford.FCGVT Reporting and Analytics for ERP -
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 823 views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…marc.joed.de.guzman 33 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections
-
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently …JennyB 46 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
SQL - GL Balances for IntercompanySummary: Can anyone help, I understand with subledger queries I can filter to accounting_class_code = 'INTER', is there any equivalent means of getting ONLY intercompany…Robert of STAU 42 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 14 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
FRS- How to replace Period Name with Calendar Date in Column HeadersSummary: Content (required): Hello. For columns in Income Statement we would like to be able to use the Calendar Date instead of the Period Name. For example, if Period …Marisa Escobar 67 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Which table holds the error details for failed records from "Customer Credit Hierarchy" conversion?Summary: Hi Team, In order to get the details of loaded and failed records when building a custom Reconciliation Report (BIP) for "Customer Credit Hierarchy" conversion,…
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 24 views 5 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…User_2025-03-07-21-11-01-091 267 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…Sheshan Ukkalkar 38 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
To restrict access so that only pending workers can use the username and password.Hi All, Can someone provide insights on how to implement restricted access so that only pending workers can use the username and password login while everyone else uses …Sheshan Ukkalkar 25 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 36 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 121 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP
-
Which table holds the error details for unsuccessful imports of Customer Credit hierarchy data?Summary: Hi Team, I am in the process of importing "Credit Hierarchy" data through "Import Management" (Object = Hierarchy & Hierarchy Member) and am working on a BIP re…