Fusion Financial reporting
Discussion List
-
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 16 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?
-
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 to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 1 view 0 comments 0 points Started by LakshmiVanarasi Reporting and Analytics for ERP
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 141 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP
-
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 … -
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 31 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
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 51 views 4 comments 1 point Most recent by fusion.integration Reporting and Analytics for ERP
-
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…Priyanka Amjuri 1 view 0 comments 0 points Started by Priyanka Amjuri Reporting and Analytics for ERP
-
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 …
-
Need a sql query to fetch approver history for contract managementSummary: Need a sql query to fetch approver history for contract management Content (please ensure you mask any confidential information): Version (include the version y…Dilip.Murugan-Oracle 11 views 1 comment 0 points Most recent by Akanksha Srivastava-Oracle Enterprise Contracts
-
Extract Report OutputSummary: Extract Report Output and populate standard attachment table for Payables Invoices Content (please ensure you mask any confidential information): I'd like to kn…
-
BIACM data models not returning any valueSummary: We are building a data warehouse and needs to utilize the default models provided by Oracle via BIACM to extract values needed for this project. When started wi…
-
Track usage of Account InspectorSummary: Customer (Old Mutual Limited) asked if any options exist to track the usage of Account Inspector (Financial Reporting Center). They want to have a view of users…AVorster-Oracle 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Which table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be…Aman Mishra 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 11 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management
-
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …Vipul_vipul 4.5K views 12 comments 1 point Most recent by Alexandru Dicu-Oracle Reporting and Analytics for ERP
-
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 11 views 4 comments 1 point Most recent by Shahid Qureshi 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…
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 23 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 229 views 5 comments 0 points Most recent by Bhagchandani Nayan Reporting and Analytics for ERP
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
Need Information on Parameters for AP_TRIAL_BAL_REPORT_PKG.BEFORE_REPORTWe are using a customized version of the Payables Trial Balance Report to pull one specific account via custom parameter on the data model. We would like to add another …
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 941 views 6 comments 1 point Most recent by User_2W210 Reporting and Analytics for ERP