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
-
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…
-
How Much Time Does It Take To Post Bulk Journal Batches (Appx count is 67000)Hi Community, We have attempted to post GL conversion Journal Batches (Actual Balance - 3 years detail journal) in bulk via AutoPost Journal process. The count is appx 6…
-
How to resolve the error ORA-00001: unique constraint (FUSION.FND_DF_SEGMENTS_B_U1) violatedHow to resolve the error ORA-00001: unique constraint (FUSION.FND_DF_SEGMENTS_B_U1) violated, which I get when creating a flexfield in the legal entity. I checked the ta…
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…
-
The posting process detected an error with the GL balances cube. Details: No journals were posted.Hello, I am getting the error "The posting process detected an error with the GL balances cube. Details: No journals were posted.", when posting journals to extract Tria…
-
Display Negative Amounts in Red Font with Enclosed Parenthesis in the User InterfaceCurrently negative amounts in the UI are displayed in black font with a negative sign (-). We would like to know if there is a function/ ability available to display neg…
-
Trial Balance Report is Fetching No Data for Consolidated EntitySummary: Hello, Is it possible to run the Trial Balance Report for a Consolidated Entity. For us it fetches no data, and for individual segment values(entities) it fetch…
-
Currency Code appearing for some journals and for some notSummary: Currency Code appearing for some journals and for some not - at Manage Journals search, We have Journal Entered Debit and Journal Entered Credit columns at Mana…
-
How to delete User Name in User details.I am not able to delete User Name in User details. After loading worker data through HDL, I just set User Name in User details section manually. Could you please let me …
-
Allocation rules guide for multiple scenariosSummary: Allocation rules guide for multiple scenarios. I am facing many issues related to member selection, i am not able to select multiple member in source and target…
-
OTBI report unarchive from one instance to another instance is not workingSummary: We are facing an issue with OTBI report migration between environments. A report (e.g., Account Analysis) developed in one instance was archived and then unarch… -
Is there a table that stores ALLOW_POSTING_FLAG?Oracle Fusion Cloud Financials 25A Is there a table that stores the value for allow_posting_flag for a segment value loaded into gl segment values? that field can be loa…
-
Account Analysis Report - The report columns are shuffled in CSV format outputIn Standard Account Analysis Report - The report columns are not in a proper order in CSV format output. for every different parameter the some columns are shuffled. Ple…