Fusion Financial reporting
Discussion List
-
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 46 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP -
FRS 13 Month Rolling Reports Error Executing Query since 22C UpgradeSummary: Content (required): Hello: Is anyone having issues running FRS rolling reports since the 22C Upgrade? Our other reports are running fine, but we are getting an …
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu…Cathy Watson Moore 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 76 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Which database is used by Oracle Analytics Cloud?Summary: I wanted to understand if Oracle Analytics Cloud sits on the same Cloud Fusion ERP database or it uses a different database. Content (required): To be clear - I…Sumit Vijay 41 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…Vipusha Chandrakumaran 86 views 3 comments 0 points Most recent by Vipusha Chandrakumaran Reporting and Analytics for ERP
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
How to change the logo dynamically in fusion home page?Summary: How to change the logo dynamically in fusion home page? Content (required): Hi All, Is it possible to change the logo based on the user login on the fusion home…
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l… -
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…Vipusha Chandrakumaran 460 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
ERP BI and OTBI Reporting - Creating Custom RoleSummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 81 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for ERP -
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point…BillM 79 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How do we set the default value to "On" for the prompts auto-complete field?Summary:In recent upgrade documentation https://docs.oracle.com/en/cloud/saas/otbi/otbi-notable/index.html#TBIWD-GUID-26F03E96-6982-42BC-A9CA-8BFEDBA1FFFC It mentions “S…Carrie Behrens 42 views 1 comment 0 points Most recent by Arunkumar Ramamoorthy-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 63 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
Financial Reporting Webstudio Performance IssuesSummary: Oracle closed out the old discussions on this topic. We are still facing (on 22B) performance issues with Financial Reporting Webstudio. We are interested to he…
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 86 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
How to convert hexadecimal to Base64 in BI ReportSummary: How to convert hexadecimal to Base64 in BI Report Content (required): Hi All, How to convert hexadecimal to Base64 format in (SQL) BI report. Need to generate Q…Venkatesan 73 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 41 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you…Pam Clark-Oracle 41 views 1 comment 2 points Most recent by Pam Clark-Oracle Reporting and Analytics for ERP -
How to access the sample XML for the Printable Expense Report Template?Summary: I need to customise the Printed Expense Report Template to suit client's requirements. I understand that the seeded report does not have an associated Data Mode… -
Can you please share with me Workflow/BPM tables in Fusion? Are there workflow/BPM tables for Cash AContent Can you please share with me Workflow/BPM tables for Cash Advances in Fusion? Following I found in Procurement 1.POR_AMX_RULES2.POR_AMX_PARTICIPANTS3.POR_AMX_DIM…
-
How to add standard report icon in springboardSummary: I have a requirement to add icon of a standard BIP report in springboard. I am using static URL to create page entry. We cannot open a standard BIP report from …AeeTee 346 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…Richard Beet 407 views 32 comments 3 points Most recent by Aitor Quintela Reporting and Analytics for ERP
-
How do I implement custom barcode fontSummary: We have a requirement to print barcodes in BC3of9 and Code128 fonts. We implemented using the delivered Oracle-supported fonts. However, the client tested and s…Lisa Taroma 127 views 2 comments 0 points Most recent by Lisa Taroma Reporting and Analytics for ERP
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…DLMorgan 24 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Delete: ID10T error!Summary: Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications22B (11.13.22.04.0) Code Snippet (add any code s…
-
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it…Ahmed Maher Kadeh 61 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Performance Issue caused after 22B upgrade for CF Activity ReportSummary: Hi Team, We have performance issue in our report after 22B update. Regards Nidhi... Content (required): Version (include the version you are using, if applicabl…Nidhi Chhajed 21 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Group Filter not working in Custom ReportContent We have developed a custom Report. The Data Model is a master detail query includes a main query and three child queries Q_1 - Main Q_2, Q_3, Q_4 are child queri…Balachander G-Oracle 77 views 7 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
What is the current(22B) licensing/role description for OTBI reporting? ERPSelf-service vs. ERP Fin?Summary: Use Case 1 Store managers want to drill down on a report to view additional details in the report. View/Read=ERP Self-Service Use Case 2 Store Manager wants to …Mechelle Stone-Oracle 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP