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
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis… -
How to create advanced rule in Workflow spreadsheet with condition 'Each' or 'None'?Summary: In BPM it was possible to use expressions like EACH and NONE in Advanced Mode. In the workflow spradsheets it is not present. At least it seems that way. How ca…
-
Impact Of Changing the Account Type of Natural Account segment value from Revenue to ExpenseSummary: In the current landscape of our client's environment, COA values and related information will flow from EDMCS to Fusion ERP. Now there is a requirement from Cli…
-
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…
-
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr… -
Create a sequence for a specific Journal Source and CategorySummary: Hello, For our migration we have the requirement to create a specific journal source and category for the migrated entries of GL. The requirement also specifies…
-
Modifying the Revaluation criteria doesn't work even if the Journal is not posted and deletedUser ran revaluation based on a wrong criteria, But didn't post the journal and deleted it. After which he modified the criteria and rerun the process but the new criter… -
Segment Value Set Security Control for Ledger SetWe have enabled Segment Security control by ledger-wise and have also a ledger set. When we assign the ledger set to a user and they select a ledger from the LOV while m…
-
Recon Reference for Balancing Journal LinesSummary: When a Subledger Journal is unbalanced, Intercompany and Additional Intercompany Balancing rules create journal lines. How can i setup accounting so we can capt…
-
Documentation on ERP Audit OptionsSummary: Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Amica Mutual Insurance Compa…
-
How can I change segments in an existing chart of accounts structure?Summary: The Customer wants to changue the order of the. segments in the char of account structure, in this moment we already did the configuration but they have no made…
-
Delete journal interface by 'Purge Interface Tables', but import errors repord still thereSummary: Delete journal interface data by process'Purge Interface Tables', but import errors repord still there Content (please ensure you mask any confidential informat…
-
Excel Add-ins to export TB directly from Fusion applications to Excel directly.Summary: Excel Add-ins to export TB directly from Fusion applications to Excel directly. Content (please ensure you mask any confidential information): Business would to… -
Journal Approval_Grade LevelSummary: Journal Approval_Grade Level Content (please ensure you mask any confidential information): Journal Approval_Grade Level, Business is requesting us to implement…
-
How to fetch Timezone defined in Legal Entity Address through Groovy ScriptSummary: Need a way to fetch Timezone details from Legal Entity Address setup through Groovy Script Code. Please confirm if there is any function available to fetch thes…
-
How to prevent changing a segment value when an Alias is being used?Summary: We are trying to figure out a way, that an alias could be used to enter some (not all segments) of the GL Code combination (when entering transactions), and whe…
-
Cross Validation rules works differently when using the FBDI for import JournalsSummary: The Cross Validation rule configured in the environment is not correctly picked up / works differently when using the Journal Import FBDI The CVR rule is set-up…
-
DATE_CREATED_IN_GL field on the GL_INTERFACE tableHow does the DATE_CREATED_IN_GL field on the GL_INTERFACE table gets populated? As per the tables and views description: Oracle internal use only. Date journal import cr…
-
What's the best practice to limit revaluation journals cannot be modifiedHi team, We are a global company and APAC users request to have their revaluation journals cannot be updated after generation under audit requirements. We know that we c…
-
What roles are required to complete the IC transactionSummary: Provided Receiver and provider in IC transaction, Receiver is not available in Provider list, Not able to transfer the IC Transaction to payables. Is that true?…
-
Inquire on Detail Balances Default Column ViewHi Everyone, I see another thread regarding this question, but no definitive answer was given. Is it possible to automatically have the columns in a certain order when y…
-
Custom role to access specific tasks in GL setupHi all, I have a request for a custom role related to GL setup. They need that the role has access only to Manage trees and trees versions, Manage cross-validation rules… -
How to prevent the addition of different set of values to the same parent in different hierarchiesSummary: In Oracle Fusion Cloud General Ledger, it is possible to add the same parent to different hierarchies / tree versions while the set of values rolling under the …
-
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…
-
Is there a workaround to view combinations for a combination set?Summary: I have followed steps to View Combinations for a Combination Set available in Oracle Help Center. When I get to step 8 listed below to download it freezes my pa…
-
Incorrect Account type reclass from Revenue to ExpenseWe went live in April-25 and we noticed after loading all the TB's some of the expense account was wrongly setup as Revenue account due which it is impacting the FRS rep…
-
Business Requirement to move Legal Entities from GBP Ledger to USD LedgerSummary: Business Requirement to move 3 existing Legal Entities from GBP Ledger to USD Ledge. Please see the table below. We want to move 3 Legal Entities (LEs) and Bala…
-
Require Alternative approach instead of BIPWe are using the below BIP query to extract and correlate data from various financial and customer management tables combined to get comprehensive transaction details. T…
-
What is the maximum currency precision and extended precision in Fusion GL?Hello Gurus, What is the maximum currency precision and extended precision in Fusion GL? Highly appreciated for any feedback/help in advance. Thanks and Regards, David
-
Opening GL period Request Status is warningSummary: there are two user accounts shared the same role and data access, but one(weixiaojie) can open the GL Period and the other one (CHENWEIWEI) cann't open. the Ope…