Financial Reporting
Discussion List
-
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 53 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 0 points 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 12 views 3 comments 0 points Most recent by James McBride General Ledger & Intercompany
-
Create FRS Planning database connectionSummary: I am building an FRS report in ERP and would like to create a database connection to the Planning application to include budget data. I can easily create the Es…
-
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 11 views 4 comments 0 points Most recent by Mohamade Oumar General Ledger & Intercompany
-
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written…
-
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 255 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 51 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 22 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 11 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
-
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode…
-
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 78 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 17 views 2 comments 0 points Most recent by VivwkSharma-Oracle General Ledger & Intercompany -
Putting primary ledger and secondary ledger into same subeI am using Oracle Fusion General Ledger Cloud Service (Oracle GL). Now, we created primary ledger(PL) for local GAAP and secondary ledger(SL) for another GAAP. Same COA …
-
View Cash Position Report is not fetching the Closed Booked Balance, Inflow and Out FlowCash Management UI View Cash Position we are not able to see the Closed Booked Balance, Inflow and Out Flow amounts. We have executed the below jobs, but still not fetch…
-
Can't post eliminating entries on ledger setReferring to https://docs.oracle.com/en/cloud/saas/financials/23c/faugl/example-of-reporting-only-consolidation-method.html#s20035629 The steps to reporting only consoli…
-
International Netting Roaming SolutionHi We are implementing fusion for a telecom company. Requesting any solution approach which may have been followed for international netting roaming solution for a telec…Ankit Agarwal 21 views 2 comments 0 points Most recent by Neil Ramsay-Oracle General Ledger & Intercompany
-
What are the impacts of having a one to one relationship between business unit and legal entity?Summary: Content (required): From an enterprise structure perspective, it has always been known to follow a ledger-> business unit -> legal entity hierarchy, where there…
-
Questions about Maintain Chart of Accounts Hierarchies processWe recently discovered we had an issue with a custom BIP report that was built for us by our implementation consultants. Long story short, we discovered that any new com…MDeming 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Security access for "Inherit Segment Value Attributes" Ess ProcessSummary: Hello Team, We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in O…
-
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 22 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany