Financial Reporting
Discussion List
-
FRS report percentage calculations based on displayed digitsHi Team, We are developing an FRS report, which involves having the actuals and the percentages. For a specific account 110110 as an example, YTD Actual - 126.00 YTD Las…Swapnil.S 33 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
How to fetch Days of the Months in an HFRS Report?Summary: How can we retrieve the days of the month in an HFRS report? Additionally, what is the process for recording the days of the month in the GL module, and how can…
-
Is it possible to update an applied receipt?Summary: I am using the following webservice https://servername/fscmService/CreateAndApplyReceiptService?WSDL and operation to apply receipt. My new requirement is that … -
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 71 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
Account Value which is updated in COA is getting updated in FRS custom Reports(Balance sheet)Summary: Hi Team - we have updated the COA value from 111005 (petty cash) to 111005 (cash operating 3) in the instance. when we are trying to retrieve the balance sheet …
-
Needs to be deletedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to display if amount is Zero then need to be displayed zero valueSummary: How to display if amount is #ZERO then need to be displayed zero value. Content (please ensure you mask any confidential information): I need to make 'IF(K6=0,0…Narendra Golla 82 views 5 comments 0 points Most recent by Narendra Golla General Ledger & Intercompany
-
ability to secure Budget ScenariosSummary: Is it possible to secure a specific Budget Scenario? Content (please ensure you mask any confidential information): We have a budget scenario that is specific b… -
Exporting theFRS report in Excel format, we want the header data reflected in separate Excel sheets.Summary: Requirement in FRS Reporting wherein 'While exporting the FRS report in Excel format, we want that the parameters or header data reflected in separate Excel she…Harsh Bhavsar 31 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
Account Cube UpdateSummary Account Cube UpdateContent I did an update to Account Hierarchy and generate the "Publish Chart of Accounts Dimension Members and Hierarchies" not publishing Hie…
-
General Ledger Balance; No Subledger balanceSummary: Our GL Balance for an account should be zero according to our subledger journal detail Content (please ensure you mask any confidential information): We have an…
-
Get Expenditure item date from back end tablesSummary: Please advise how we can get Expenditure Item Date and Expenditure Type from back end tables. I have below query as of now it is giving result based on SYSDATE.…
-
How do we get Transaction counts by day or by week from modules AP,AR,GL,FA & CM from Oracle FusionSummary: We are looking for the Transaction counts of all the modules from Oracle Cloud Fusion by day or by week. Is there any default reports that can give these counts…Jaikar_Reddy 94 views 4 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
How to view code combination description everytime while viewing accounting draft and finalSummary: We need to see Description of Code Combination at all places while viewing accounting in Oracle Content (please ensure you mask any confidential information): V…Kashyap Shiringi-Oracle 31 views 9 comments 1 point Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
How to restrict create accounting and period close by entitySummary: The closing process in Oracle is by Ledger. This creates problem when you have multiple entities [BSV's] within a Ledger. We have a global client with several l…Raj Mohanraju FRNT 18 views 3 comments 0 points Most recent by James McBride General Ledger & Intercompany
-
Balances are not reflecting in "Inquire on Detail Balances"Summary: Balances are not reflecting in "Inquire on Detail Balances" Content (please ensure you mask any confidential information): Balances are not reflecting in "Inqui… -
How to not allow one balancing segment to be used for subledgers and only use for GL?I have a scenario where - the Client has Ledger - USD Ledger Legal Entity - LE1 Business Unit - BU1 2 Balancing segments - 101 and 102 For the balancing segment 101, the…
-
Account Analysis ReportSummary: Account Analysis Report Content (required): Does any of the GL Analysis report contains supplier name, address and withholding Tax Code? If not which can be mod…
-
FRS & Smartview Report helpSummary: In the FRS & Smart View report we have ''AccountingPeriod'' dimension where we can see GL Periods and able to select. But our requirement is to select date rang…
-
What reports includes GL Document/Account sequence numberSummary: What reports includes GL Document/Account sequence number Content (please ensure you mask any confidential information): We have implemented Document/Accounting…ramesh.sivapalan 21 views 4 comments 0 points Most recent by ramesh.sivapalan General Ledger & Intercompany
-
23 D Upgrade - French Audit fileCan someone please explain why we have the lines of code for french audit file report added during the 23D upgrade? The table fnd_segment_attribute_values dfsa was added…Mohamade Oumar 12 views 4 comments 0 points Most recent by Mohamade Oumar General Ledger & Intercompany
-
Need Information on rest API to validate the GL code combination in fusionSummary: Hi All, Need Information on rest API to validate the GL code combination before creating new Combination in fusion. This is for selecting the code combination a…Neeraja Chinta 586 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
Divestment of an entity : Legal SeparationHi, Our client has 3 BUs setup under the same ledger (BU1, BU2, BU3) One of the entities under BU1 is going to be sold as part of a divestment strategy (Highlighted belo…Mig_ph 64 views 6 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
GL Revaluation Strategy - Initial Period ?Summary: GL Revaluation Strategy - Initial Period ? Content (please ensure you mask any confidential information): Hello I already reviewed the document FAQ on Revaluati…Cesar Saveedra 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 31 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to set range from fiscal year starting period to current point of period in FRSHow to set range from fiscal year starting period to current point of period in FRSNarendra Prasad Golla 31 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany
-
OTBI analysis joining General ledger and Project subject areas blank fieldsSummary: We are trying to pull GL transaction data and add the project and invoice information to it when relevant. Content (please ensure you mask any confidential info…Tashi Temple-Wood 146 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Does FRS reports are allowed to run for entire Financial Year?Summary: FRS reports not fetching balances when we selected a Year (2023) in period parameter. We have balances in all the months in selected Year. Please suggest how to…AARE AJAYKUMAR 11 views 2 comments 0 points Most recent by VivwkSharma-Oracle General Ledger & Intercompany