Fusion Financial reporting
Discussion List
-
Income Statement and Balance Sheet are returning error values for Net Income and Asset balancesWhat are the possible reasons for Net Income and Asset values showing error values in the Income Statement and Balance Sheet generated in FRS? Investigation performed so… -
FRS reporting issues- dimension placement making huge differencesI’m having an issue with an FRS report. When I place the scenario in the columns, the trial report doesn’t match the one from the generated from scheduled process, but i… -
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…Sowbhagya B 34 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Locating PVOs and Data Stores for ar_batch_sources_all and ar_credit_memo_amounts Tables in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th… -
Upload Image in Financial Reporting CenterSummary: Upload Image in Financial Reporting Center Content (please ensure you mask any confidential information): Hi, How to upload the image such as logo into FRS and … -
Unable to find error details in interface table GL_SEGMENT_VALUES_INTERFACESummary: Hi Experts, Could anyone please provide the details for 'GL_SEGMENT_VALUES_INTERFACE' table. The import program 'Import Segment Values and Hierarchies' getting …Sai Krishna Chelikani 11 views 0 comments 0 points Started by Sai Krishna Chelikani Reporting and Analytics for ERP -
Is there functionality to leverage Data Access Sets for BIP reportsHello, Does anyone have any feedback on how to secure BIP reports via Data Access Sets? We are trying to split out security roles so that International crew only see the…Jason Madden 31 views 7 comments 1 point Most recent by Jason Madden Reporting and Analytics for ERP -
Multi Language in Single BI Publisher ReportHello Community, We are having a requirement to Generate Invoice Report such that for certain Provinces the report should show the invoice in two languages in single fil…Sreedhar Elagandula 13 views 2 comments 0 points Most recent by Sreedhar Elagandula Reporting and Analytics for ERP -
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and… -
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r… -
Date format in parameter display as DD/MM/YYYYSummary: User want date parameter supports either input manually DD/MM/YYYY or select from calendar. Currently it display as MM-DD-YYYY and cannot change the format, whi… -
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 12 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
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 110 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP -
Retired Assets in previous years should be part of Asset Register ReportSummary: Hello, one of our user raised concern regarding Asset Register Report that "all the assets that were retired last year still appear on the report. They do have … -
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 34 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP -
Regarding COA future1 segment name change impact on custom reportsSummary:Is there a specific option to find out what all custom reports are touching the chart of accounts Accounting Flexfield to analyze the impact of chart of account …Savita_1 13 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 73 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
segregation of dutiesIs there a report for segregation of duties for Finance? -
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans… -
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 14 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub -
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 56.9K views 137 comments 31 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are … -
Does Oracle Fusion Cloud have any standard report/Localization for FTA VAT Audit File, (FAF)Hi Experts, The United Arab Emirates tax authority, Federal Tax Authority (FTA), audits businesses at its discretion to ensure accurate and timely tax declarations. As p… -
Range Function in Accounting Period is not working when adding another columnHello, I'm creating Trial Balance in FRS, and i need to use the range function in accounting period dimension, However, when I only have one column its working fine but …Mohammad Hussein 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…Ann Djiyanova 12 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
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 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP -
which tables store information about data access set for user?I need to a query to read for each user which BU have access to -
Is it possible to make import output with capitalize letter even original data stored as uppercaseIs it possible that original data is all uppercase but transfer to captalize letter in output report? for example, JIM CHUNG, but in expected output, need to be Jim Chu… -
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…Ravi Upadh 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi