Fusion Financial reporting
Discussion List
-
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 49 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,…Dhilip Kumar P. 2 views 0 comments 0 points Started by Dhilip Kumar P. Reporting and Analytics for ERP
-
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…
-
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 …Akash Verma 9 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
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 19 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 242 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 1.2K views 32 comments 19 points Most recent by THawkins_LGI 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 16 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 20 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 825 views 15 comments 1 point Most recent by Sai Divya Kolachana 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 35 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
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…
-
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 124 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP -
Set up IP Restrictions for FDI instancesHello All, Is there any documentation out there on how to restrict network access to Oracle Financial Data Intelligence URL's through IP restricting? I cant seem to find…
-
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…Dhilip Kumar P. 8 views 0 comments 0 points Started by Dhilip Kumar P. Reporting and Analytics for ERP
-
Tables to get Multiperiod Accounting Invoices With Amortization ScheduleSummary: Tables to get Multiperiod Accounting Invoices With Amortization Schedule Content (please ensure you mask any confidential information): Hi All, Is there any tab…
-
standard reportsSummary: Can I get a list of the canned reports for accounting? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
FSGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Frankie Chan-Oracle 8 views 0 comments 0 points Started by Frankie Chan-Oracle Reporting and Analytics for ERP
-
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati…
-
VAT Functionality for Expense reportingSummary: VAT functionality in Oracle Expenses, focusing on international purchases. International staff should be able to split VAT from the total product/service purcha…
-
User is facing time out error while running OTBI reportHow can i increase query governing execution time for see error below Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 1005…Shahid Qureshi 18 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Project Adjustment Costs Error Exception DetailsSummary: I wanted to build a report which illustrates all the error-ed Cost Transactions ( Expenditure Item Costs ). In Costs dashboard, I have 1800+ error-ed transactio…
-
How can we accurately pull the unpaid invoice amount in an analysis reportHi All, We have an analysis report that was made to assist with pulling the unpaid invoice amount, however it is pulling 3x the value for some invoices and other invoice…FlatFish534 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 18 views 1 comment 0 points Most recent by Shahid Qureshi Reporting and Analytics for ERP
-
how to convert Amount to WordsSummary: in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word We see the same package in fusion but We do not understand how to use it - SQ…
-
How To Design FRS Report That Shows all the transaction Balances For a specific account Periods?We want to create an FRS report that will prompted for the Account and Period and will show the all accounting entries with journal type for the input, is it possible?
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 5 views 0 comments 0 points Started by LakshmiVanarasi General Ledger & Intercompany