Fusion Financial reporting
Discussion List
- 
             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 51 views 6 comments 0 points Most recent by Tashi Temple-Wood 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 51 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 141 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany 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 141 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 121 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 121 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 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 71 views 2 comments 0 points 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 71 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 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… 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 81 views 3 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP 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 81 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 … 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… 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 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP 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 22 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… 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? 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 53 views 6 comments 0 points Most recent by Sonny_Conyers Reporting and Analytics for ERP 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 53 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… 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… 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 1 view 0 comments 0 points Started by Jackie Blankenship Reporting and Analytics for ERP 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 1 view 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 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… 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 11 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP 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 11 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 11 views 1 comment 1 point Most recent by Bhaskar Konar 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 11 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 1 view 1 comment 1 point Most recent by KISHAN BUSSA 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 1 view 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 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle 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 23 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… 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 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 508 views 3 comments 0 points Most recent by Bhaskar Konar 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 508 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… 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 143 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP 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 143 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… 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…
- 
             Convert Period Name to DateSummary: Trying to convert period name format to date format mm/dd/yy Content (required): Hi All, I'm trying to convert the column "Fixed Assets - Asset Depreciation Rea… Convert Period Name to DateSummary: Trying to convert period name format to date format mm/dd/yy Content (required): Hi All, I'm trying to convert the column "Fixed Assets - Asset Depreciation Rea…