Financial Reporting
Discussion List
-
I am designing a FR report where i need to derive Quarters based on the User prompt.Summary: I am designing a FR report where i need to derive Quarters based on the User prompt. I am using function: Relative to Prompt for AccountingPeriod offset. Busine… -
Get different accounts in cost dist. for different Shipping Charges in Intercompany Transfer Order?Process followed 1.Create InterLegal Entity Transfer Order 2.Create & Release Pick Wave 3.Add Shipment Lines (Recording two different Shipping costs) 4.Recieving 5.SCFO …
-
What is "Adjustment Period" in General Ledger Accounting Calendar and its reporting impactsWhat is "Adjustment Period": When we configure General Ledger module, one of the important setup is Accounting Calendar. In that, there is a functionality called- Adjust…CA Nirmal Choudhary 2.8K views 12 comments 3 points Most recent by On King Lau-Oracle General Ledger & Intercompany -
Journal entered currency conversion to constant reporting currencySummary: We have a requirement to report on a specific currency and constant exchange rate, i.e. we have to convert and report all the entered currency journal posting i…Lohith Joyappa 31 views 2 comments 0 points Most recent by Lohith Joyappa General Ledger & Intercompany
-
How to build a FRS report to show trailing actuals and budget for an entitySummary: We have two separate FRS reports to print 12 month trailing budget and actual, which are working fine. The new requirement is to print the actual for the curren…SuniChacko 53 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Unable to Publish Account Hierarchies for few Value setsSummary: Unable to Publish Account Hierarchies for few Value sets Content (required): We are not able to publish Accounting Hierarchies for Some value sets which for few…Rohit Kumar Singh 1.2K views 12 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
Do we really need the BIAdministrator role for the Account Inspector to show balances on parents?Summary: We noticed an interesting phenomena in General Ledger features that are based directly on the balances cubes (Inquire on Detail Balances, Account Monitor, Accou…Thomas De Leeuw 31 views 2 comments 0 points Most recent by Thomas De Leeuw General Ledger & Intercompany
-
Impact Analysis on field 'Precision' for Currency 'XOF'Summary: Hello, Can you assist us urgently with the impact analysis of the following : Navigate to Setup & Maintenance > Manage Currencies Search for currency code 'XOF'…
-
What are all the impacted areas that we should promote a Legal Entity name change?Summary: Legal Entity name change in General Ledger enterprise configuration Content (please ensure you mask any confidential information): We have a requirement to chan…ramesh.sivapalan 91 views 1 comment 0 points Most recent by SauravS-Oracle General Ledger & Intercompany
-
When was the ability to select a currency type of Statistical Unit added?Summary: We have a currency defined that users use for statistical entries that was originally created as a type of currency and not statistical unit. It was created thi…James McBride 11 views 3 comments 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
General Ledger Journal and Balance Report - can't schedule with incremental parameter PeriodIn Oracle Fushion, not possible to schedule with incremental parameter Period. Our users run schedule the report monthly, e.g.., run on Feb 1 with period Jan-24, run on …AnniesEco 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Journal Import Execution ReportSummary: We want to understand the functionality of "Journal Import Execution Report ", what are all the tables comes into picture as part of this process. We want to kn…
-
General Ledger journal reportsSummary: As per below oracle link, we are supposed to have a seeded report called Journal Reports that allows us to run and view journals by selecting specific journal b…
-
Need details of the Dashboard that show the period status of all the subledgers and BU'sSummary: Need details of the Dashboard that show the period status of all the subledgers and BU's in one screen. Helps user and operation teams during period close. Cont…
-
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 31 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 73 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 71 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 86 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