To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
General Ledger & Intercompany
Discussion List
-
SQL script to get Manage Intercompany Balancing RulesWe checked fun_bal_inter_rules and FUN_BAL_INTER_ACCOUNTS_ADDL tables. fun_bal_inter_rules table stores FROM_LEDGER_ID, TO_LEDER_ID, FROM_LE_ID and TO_LE_ID as -1 value.… -
Standard Functionalities to Import daily ratesSummary: Hello Experts, Is there a built-in feature to import daily exchange rates from third-party service providers into Oracle Fusion automatically, without requiring…
-
Is it possible to make a column in ADFDI as a mandatory field?Summary: Hi Team, We have made the Line Description field as a mandatory field in the Environment Front-End, but it is not behaving in the same way while we import a jou…
-
Intercompany balancing rules not replacing the intercompany segmentSummary: Hello Team, We have enabled cross validation rules for Intercompany receivables and Intercompany Payables account. The CVR states that we should have IC segment…
-
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…
-
Moved: Is there any documentation on Apptio Connector?This discussion has been moved. -
Is there any way to get the sequence of mapping for columns in CSVs for FBDI in Oracle fusion cloudHi - While creating CSVs from FBDI template, Oracle is mandated to generate CSVs based the column mapping sequence followed in control files of each entity. It is easy t…
-
Which Oracle ERP reports are suitable replacements for standard Oracle EBS Consolidation Reports?Summary: Hello, We are currently implementing Oracle ERP (Oracle Fusion Cloud Applications 24D) and replacing the legacy Oracle EBS (R12) system. Currently, in Oracle EB…
-
Row and column template in FRS reportsSummary: We have saved a row and column template and have linked the same with 5 RWS reports. Now we want to change the template and expect the change to reflect in all …
-
Custom lookups in OTBISummary: We have created a custom look up as common lookups and we want to use it in OTBI reports. Please let me know if it is possible or not. If yes, then please guide…
-
Need Smart View and ADFDI Plugin for MacBook usersSummary: We are implementing Oracle Cloud ERP Financials. And require Smart View plugin for General ledger and ADFDI installation for Spreadsheet upload. This is require…
-
equivalent tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Moved: Import External Transaction To the Tax Repository error "Unique transaction validation …This discussion has been moved. -
Beginning balances column showing no balances in the Trial Balance ReportSummary: When we are running the Trial Balance Report for Primary Ledgers, beginning balances column is showing the activity for the period that we are running the repor… -
Smart View plug in for MacBookSummary: Need Smart View Plugin for MacBook for Oracle ERP General Ledger Content (please ensure you mask any confidential information): Version (include the version you…
-
Mexico-How to setup COA Mapping Account Rules from Primary ledger to Statutory using FBDI ?Summary: Bulk upload of Chart of Account Mappings using Account Rules option Content (please ensure you mask any confidential information): Hello Some global companies w…
-
how to configure Position Trees for routing FIN Journal Workflows ?Hi all - We are trying to setup a THEN statement that routes the hierarchy logic based on the submitter and their placement within a custom position tree we will maintai…
-
How to Audit Chart of Account Hierarchies Changes?We want to maintain an audit trail to keep track of all the changes made to Chart of Account Hierarchies in Fusion General Ledger. How do you achieve it? What audit obje…
-
How to create journal approval using DFF and use the same in approval spreadsheetSummary:We are in the process of setting up journal approval using Descriptive Flexfields (DFF). We have created a DFF and assigned a value set to it. However, when crea…
-
Need to increase Precision of an Currency in ProductionSummary: Hi, we need to increase Precision of CLP currency from 0 to 2 in Production. Please note that we have multiple open transactions in the currency Content (please…
-
How can I run Trial Balance for multiple Primary ledgers in one runWe have 31 Primary Ledgers and as many Secondary Ledgers. The client wants to run Trial Balance for all Primary Ledgers in a single run. They do not want to run the TB 3…
-
How do I see if there are improvements for new releases for Functional Setup Manager (FSM)?Summary: How do I see if there are improvements for new releases for Functional Setup Manager (FSM)? Content (please ensure you mask any confidential information): Versi… -
What is the ISO 4217 Numeric Currency Code used for in FusionSummary: When adding a new currency in Fusion, you are requested to add ISO 4217 Numeric Currency Code (DIGITAL_CURRENCY_CODE) as well as the Currency Code. What is this…
-
Opened the first GL period of new year without closing the Dec periodSummary: Dear Experts, We have accounting calendar from Jan to Dec. We have opened the first GL period of new year without closing the Dec period. Business users has pos… -
Transfer general ledger balances errorSummary: Transfer General Ledger Balances resulting in the following error: Request to refresh the balances to the cube failed. Data is not loaded because of missing seg…
-
General Ledger - Revaluation - Exclude specific currencySummary: Hi Team, The requirement here is to exclude some specific currencies while configuring a revaluation set. Normally we are selecting "ALL Currencies" while setti…
-
General LedgerI' like to output the SEGMENT values (SEGMENT1~12) registered in GL that have an enabled flag of 'N', column by column. To achieve this with BIP, which table should I re…
-
How to temporarily block all users from entering, submitting or posting journals in GLSummary: Every month, few hours before the GL Close, Accounting Team announces "Pencils Down" after which users are not supposed to enter, submit or post the journals en…
-
Archiving and purging of accounting data implemented in ERP Financial 24BWe'd like to know the following two points about the archiving and purging of journal and balance data implemented in ERP Financial 24B. Are the archiving and purging of…
-
Does anybody have a "playbook" for LE setupSummary: I am looking for a questionnaire kind of playbook for gathering information from Business whenever we need to create a New Legal Entity. Content (please ensure …