Fusion Financial reporting
Discussion List
-
Standard Memo Line Report - Revenue CodingSummary: I have a customer requirement to be able to export a list of all standard memo lines and their associated Revenue coding, required fields highlighted in .JPG. C… -
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 14 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP
-
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 15 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 22 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 294 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
-
Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid…Tina Valtchev 14 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 170 views 8 comments 0 points Most recent by Satyam Roy Reporting and Analytics for ERP
-
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Error detail information in import journal execution reportSummary: In the process of creating a custom report for import journal execution report, we are unable to fetch the data for error status. We are able to fetch data for …
-
Is there a definitive date that Financial Reporting Web Studio will be discontinued?We were informed that Financial Reporting Web Studio will be shutting down at some point in 2024. Is that accurate? Is there a date set for discontinuing FRS?Steven Woods 195 views 2 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
ERP Secured ViewsSummary List of secured views to secure ERP data in BIP reportsContent Could you please let me know how can we secure data in datamodel for Financials data? We couldn't …User_2025-01-25-01-31-47-378 110 views 3 comments 1 point Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP -
Role/Privelege for Explain Plan from SQL Query on data modelOne of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports. "Error Msg = ORA-01039: in…Vijay Ramani VJ 102 views 4 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for ERP -
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table?Summary: What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table? What is the use of this table in FAW? Content (required): MAYO Clinic Version (includ… -
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 201 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …Latha00 723 views 5 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 99 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
Is intercompany invoice eligible for Mass Addition process?Summary: Hello, I created an Intercompany invoice with asset clearing account and want to transfer it through mass addition. I'm not able to do so. Please note that I've…
-
How to work with Multiple selection and NVL function In ParameterSummary: How to work with Multiple selection and NVL function Content (required): Hi All, Hope everyone is doing well. I have a below requirement for which i need you he…Pritam Das 530 views 3 comments 0 points Most recent by Humberto Martín-Oracle Reporting and Analytics for ERP
-
What Table(s) should I use to report on segment details?Summary: I am trying to build a BI Publisher report in SQL that exports details on individual segments in our chart of accounts. Content (please ensure you mask any conf…Henry Imgrund 46 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
I need a query to obtain Chart of accounts Values on ERPSummary: We are trying to create a report using BI Publisher and We require a SQL query to obtain the chart of account value set values (Value and Description shown on s…Robinson Antunez 2.3K views 3 comments 0 points Most recent by ROBERTO J CAMACHO Reporting and Analytics for ERP
-
Sql query for Canceled Payment Report.I wanted to fetch the Canceled Payment details from the person results through SQL query.Chetana Pawar 23 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for ERP
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…Deepa Kumari 21 views 2 comments 1 point Most recent by Mohammed Qurram Reporting and Analytics for ERP
-
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t… -
Scheduled BI Publisher reportSummary: Does a scheduled report need re-scheduling if its underlying BI Publisher template or data model is changed after the scheduling starts? Content (please ensure …Robert of STAU 14 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for ERP
-
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 148 views 6 comments 2 points Most recent by DennisOliver Reporting and Analytics for ERP -
Does an expense listing report exist?Users are wanting to run an expense listing report - does anything exist similar to what existed in EBS r12? Or alternatively is there a form where this can be extracted…