Fusion Financial reporting
Discussion List
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 82 views 2 comments 1 point Most recent by CathyK Reporting and Analytics for ERP -
create a net column on an analysis by subtracting two columnsSummary: I am trying to create a net column on an analysis using by subtracting two columns that are included on it. The Analysis is using the GL and AP subject areas. T…Tashi Temple-Wood 58 views 6 comments 0 points Most recent by Tashi Temple-Wood Reporting and Analytics for ERP -
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…Joe B 145 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 125 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Financial Reporting Studio - prior yearsSummary Avoid hard coding year-end dates in reportsContent I am using Financial Reporting Studio with an Oracle Essbase connection and require dynamic date reporting so …Jill 169 views 3 comments 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)?User_2025-03-28-20-51-35-346 77 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 256 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Why is the PVO for project team members not appearing anymore in Oracle 23... versions?Hi, We noticed that the following PVO, used to extract data for project team members: FscmTopModelAM.PjfProjectDefinitionAM.ProjectTeamMemberPVO , does not appear anymor… -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 87 views 3 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
what is EDI location in Banks, Branches and Accounts FBDI TemplateSummary: What is EDI Location in Banks, Branches and Accounts Template also guide me on how to update Bank code, Branch number etc., for existing bank accounts. Content …
-
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…Service Desk Claremont 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Cannot connect to URL in FRS ReportSummary: Hello, When trying to edit my FRS report or even adding a member, like Aug-23 in the Accounting Period, the system gives me a white screen with an error of 'htt…
-
Why to use FRS or Narrative reports when we have OBTI and BIP toolsHello Oracle Gurus, When we have reporting tools such as OTBI and BIP, why is there a specific need to use Narrative reporting tool or FRS tool?
-
BI Publisher - How to generate the postal bar codeSummary BI Publisher - How to generate the postal bar code and standard payment barcode on billsContent I have a requirement to generate customer correspondence that inc…RichardChan 55 views 6 comments 0 points Most recent by Sonny_Conyers Reporting and Analytics for ERP -
Print Receivable Transaction - customizationSummary: Sending AR Invoice by E-mail to customer through bursting. Content (required): We need to send the AR invoice through E-mail for the particular customer by burs…
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
How do you update Remaining Life with an effective date?Summary: How do you update Remaining Life with an effective date? When we update the Remaining Life then run calculate depreciation, we want that calculated based on an …Jackie Blankenship 4 views 0 comments 0 points Started by Jackie Blankenship Reporting and Analytics for ERP
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 71 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
In our FRS Reports, the Description does not work unless you put first few charactersSummary: In our FRS Reports, the Description does not work unless you put first few characters that is you can’t search with string starting with asterisk, but for Name …Abhilash K - Deloitte USI 12 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Report to Monitor User ActivitySummary: Hi All, We have a ask from the customer where in if a collection rep logs in and works an 8 hour shift, manager would like to pull a report to see how many tran…Harsha_Gargeshwari2480 15 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 3 views 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP
-
How to change member display in SmartView FunctionEven if I changed "Member Name Display" in Options>Member Options> General> Member Name Display, there are no changes in "Member Selection". Member Selections shows each…Nao-Oracle 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
How does FR retrieve data from EssbaseCube?I would like to know how FR retrieves data from EssbaseCube, because of its performance. When we'd use FR, it takes much more time than we'd use Smartview at the same co…
-
FRS search members by description starting with, Ending with, ContainsSummary FRS search members by description starting with, Ending with, ContainsContent Our client doesnot have specific values for each row. Instead they have conditions …saravana maneeian subhramaniun 43 views 2 comments 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): …Michal Shaked 436 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
LACLS: Dominican Republic (DO) BIP Reports Libro Diario and Libro Major do not render parametersSummary: The Libro Diario and Libro Major BIP reports in the Latin America Cloud Local Solution (LACLS) for Dominican Republic do not work. Parameters do not render. Con… -
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…SireeshaJaladi 144 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the…