Fusion Financial reporting
Discussion List
-
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u… -
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 49 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
ERP Financials Custom Disbursement Positive Pay File FormatsSummary: I'm trying to add headers to a custom positive pay file, however when I run the process this return data but not headers. Could you please let me know if there … -
Narrative ReportingSummary: In Narrative reporting, is it possible to display numerical numbers in other language numbers e.g Arabic numbers etc in reports. Content (please ensure you mask…
-
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 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 21 views 3 comments 0 points Most recent by Andres Celis-Oracle Reporting and Analytics for ERP
-
Join between xla_distribution_links and po_distributions_allHi, Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)? For example, for the receipt accounting accrual. In x…Rob Tempelman 43 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 225 views 10 comments 0 points Most recent by Florence Z Reporting and Analytics for ERP -
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…User_2025-03-07-18-57-57-349 904 views 4 comments 2 points Most recent by Robert A Reporting and Analytics for ERP
-
Timezone - BIP Report schedule defaultSummary Timezone - BIP Report schedule defaultContent Hello All, When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all use… -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…JayaramK_yash 4 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 12 views 2 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for ERP
-
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…Khushi 47 views 2 comments 0 points Most recent by Antima Rai-Oracle Reporting and Analytics for ERP
-
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c…
-
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …user12232237 123 views 7 comments 0 points Most recent by User_WAU4B Reporting and Analytics for ERP
-
BICC - Oracle AR Invoice Line extended amountSummary: Hi, We are extracting data from oracle fusion ERP using BICC. When extracting Receivables(AR) invoice lines, there is no column like 'extended_amount', basicall…
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…Sean-B-01 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can we track users selecting specific company codes from input parameters of FRS reportsWe have a bunch of FRS reports in which "company" is POV. Users have an option to select the different company hierarchies from LOV of input parameters. A new BU formed …Lakshmi Kanchi 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an…
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
Transaction Number in Account Analysis reportSummary: Can you please help to determine where we get this transaction number for payroll in Account Analysis report? Content (please ensure you mask any confidential i…
-
how can we remove Account Value from Account Description Column? From Inquire: On Details BalancesWe are facing a discrepancy when running queries in GL Detail Balances: General Ledger: Inquiry and Reporting > Inquire on Details Balances The account description colum…User_WV62V 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create … -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 32 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP