Fusion Financial reporting
Discussion List
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Item number field is not reflected in the Procurement Requisitions Real Time subject areaI used the Procurement Requisitions Real Time subject area in OTBI to build a report. There is just one field in the underlying source data that is not reflected in the …Walter L Gess 11 views 2 comments 0 points Most recent by Walter L Gess Reporting and Analytics for ERP -
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 44 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 112 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
U.S 1099 Payment ReportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 3 views 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
Report or table details for Chart of account listing values for natural account in General LedgerSummary: Hi Team, I have to create BIP report for COA listing values for Natural Account in General Ledger as per attachment. I am looking for table details or query to …ManishaPatil 21 views 3 comments 0 points Most recent by ManishaPatil Reporting and Analytics for ERP
-
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 11 views 2 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany -
Sql query or Table name for Classify Organizations under Manage Project Organization ClassificationSummary: Hi Team, We need a table or query to get the flag columns for Classify Organizations under Manage Project Organization Classification Attached the screenshot fo…
-
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…SuniChacko 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 261 views 16 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP
-
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 31 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
Smartview:How to enforce data access control in Smartview based on rolesSummary: In Smartview, how do we restrict data access by Ledgers configured in Data Access set? Ex: If a user has access to only Ledger A controlled via Data Access Set,…Rakesh Viswambharan 1 view 2 comments 0 points Most recent by Rakesh Viswambharan General Ledger & Intercompany
-
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …
-
Mapping Tables Not giving us accurate dataSummary: Mapping Tables Not giving us accurate data Content (please ensure you mask any confidential information): We are replacing our old system of EBS with ADW. When …
-
Ledger not visiable in FRSSummary Ledger not visiable in FRSContent Hi, We have 15 ledgers,out 15 only 3 ledgers are available in Financial reporting studio.We are web reporting studio. We have C…
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …
-
FRS- Need to display the output in excel in different tabs for different branch valuesSummary: There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the paramete…
-
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.5K views 37 comments 21 points Most recent by Srinivas Chilakamarri 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…
-
Standard Reports that include transaction number and Receipt NumberI would like to know If there are Standard Reports that meet the following requirements. 1)include transaction number and Receipt Number. 2)I need to confirm the clearin…
-
FRS branch wise bifurcation for calculated fields like gross profit and percentageSummary: I am taking branch in rows. I need to display the gross profit data branch wise and percentage should also be calculated branch wise. Content (please ensure you…Tanya Matani 21 views 3 comments 0 points Most recent by Tanya Matani Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Tax Audit Trail Report export to excel doesn't have transaction num but html and pdf does have it.Summary: Export to excel different than html and pdf export. Anyone else have that issue? Content (please ensure you mask any confidential information): Version (include…
-
how to show alternate account GL combination in BIP report?Summary: User requirement to show alternate account GL combination but cannot find correct field. Content (please ensure you mask any confidential information): When vie…CarolineH 11 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 133 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management