Fusion Financial reporting
Discussion List
-
Please provide join logic for tables within the pvo SubledgerJournalDistributionPVOSummary: As part of our project we are extracting data from the underlying tables inside PVO. Could you please provide the join logic across the below set of tables GL_L… -
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS reportLakshmiVanarasi 12 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Grouping in FRS based on parameters passedCompany Cost Center 1111 11111 2222 22222 3333 33333 If user selects the above combination in the parameters in an FRS report, the data should be fetched for the sum of …PrerakKhandelwal 41 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular…
-
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…User_F2YWU 11 views 4 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 187 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…Suriaraj.Krishnamurthy 2 views 3 comments 0 points Most recent by Suriaraj.Krishnamurthy Reporting and Analytics for ERP -
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…Sofia Chen 58 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can I apply a Receivables Credit Memo while referencing the Invoice Transaction number in FBDI?Summary: While uploading Receivable credit memos via FBDI, I aim to automatically apply open invoices by providing references in the sheet. I'm aware of using the Refere…
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 106 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to add multiple Digital Signature based on Legal Entity for Print Receivables Transactions job.Summary: There is a requirement to attach the Digital Signature to AR invoice dynamically based on Legal Entity (digital signature varies for each LE). For this requirem…
-
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 414 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Create Customer StatementHi All, while calling Create Customer Statements ESS job same We Have requirement to pass 'cycle' and 'generate bill parameters' into Statement Generation Data Model. /s…Veeragopathi 9 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 13 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 87 views 1 comment 1 point Most recent by Daniel S.-Oracle Receivables & Collections
-
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 36 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is there any REST API to get the information of Key Flexfield Segments?Summary: Hi Team, Is there any API to get the information of Key Flexfield Segments under "Manage Key Flexfield Structures". We need the fields in below attached screens…Opkey PA 15 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to minimize the input parameters for the multiple Grid in a single FRS ReportSummary: Hello Exports, I have Created the complicated Income statement (IS) in (FRS) and the same/single report having 4 different Grid (Child) with in a report. While …Steeph 12 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Connect Two Subject Areas Without Common Attribute or Dimension in OTBI (Answers Report)Hello experts, I need assistance with connecting data from two different subject areas for a report in OTBI: Receivables - Transactions Real Time Subscription Management…Valerij Astafev 24 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Setting default parameter as "Current Period" while creating a Batch for Email bursting of FR StudioSummary: We have a requirement for sending FR Studio reports through Email Bursting. We have multiple FR Studio reports which have Prompt as "AccountingPeriod". While cr…Biduth C 9 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
SOAP Web Service to download attachments for Fixed assestsSummary: When I tried to call soap service to download Fixed attachments then I got this error. "JBO-Request Failed : Reason- User did not supply correct user key: Reque…
-
Why BIP audit report missing data ?We have audit requirement that we know who and when report have been modified. When using the Audit report for Product: Oracle Business Intelligence Enterprise Edition, …Francois Desjardins 41 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
When using smartview for the projects Essbase cluster how to display description instead of IdsWhen using smartview for the projects Essbase cluster how to display Tasks_Dimensions or Resource_Dimensions with their description instead of their IDs There is no clea…Ivan Olivera-Oracle 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …Manuel Riobóo Córdoba 25 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP