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
-
Anyone have useful examples of simplified GL approval rules?Summary: We can't migrate our BPM gl journal rules to the simplified version using the 'download BPM rules' option fails - we therefore need to build them directly in th… -
How to link a reclassification journal back to originating projectSummary: Query to link a reclassification journal with the original projects transaction. Content (required): I am trying to write a query to find the project number tha… -
Fin Tech | GL Approval BPM | how to get parent account for a natural account to route Approval GroupSummary: how to get parent account for a natural account to route Approval Group Content (required): Dear team, Need advice on designing approval rules for Oracle BPM fo… -
how to set user approval on an account ?Dear all I am having a request to add user approval for accounts in COA How to do it ? Regards -
22B - What is the correct process to update Legal Entity Address?A customer I support has 1 Legal Entity, and the Address associated with the Legal Entity needs to be changed (because when POs are printed, they contain the incorrect a… -
How to edit unfrozen automated journal entries?The Oracle Help Center says you can prevent edits to journal entries by freezing the journal source (https://docs.oracle.com/en/cloud/saas/financials/22b/faugl/how-can-i… -
Periods Control at Ledger/Legal Entity LevelSummary: Can we open/close periods by a combination of the ledger and legal entity? Content (required): Hello - We have a scenario where a single ledger contains multipl… -
Rapid Implementation Spreadsheet for Enterprise StructuresSummary: We are on 22A . Just starting our cloud journey from EBS. we downloaded the rapid implementation spread sheet from 22A to setup our sandbox instance. We validat… -
The subledger journal entry doesn't balance by balancing segmentSummary: The subledger journal entry doesn't balance by balancing segment Content (required): Hello I have an AP Payment Batch that are stuck, and I got the following er… -
New Reporting Ledger Addition to Live primary LedgerSummary: New Reporting Ledger Addition to Live primary Ledger Content (required): We have to add a new Reporting Ledger at subledger level to existing Primary Ledger. Cu… -
Define OTBI prompt default depends on login userSummary Would like to define OTBI prompt default depends on login userContent Is it possible to define OTBI prompt default depends on login user? -
Assigning a Legal Entity based in US to a EURO Primary LedgerSummary Is it acceptable to assign a legal entity from one country to another countries/currency Primary Ledger?Content Hi All We have an interesting scenario whereby an… -
Prevent user entering negative value into ADFDI journal's Credit Column?Content Hi, We have noticed users have created some lines on ADFDI Spreadsheet journals, with a negative value in the Credit column. On the same journal there are cases … -
Journal Import issue - Reference field need to load with CommaSummary Journal Import issue - Reference field need to load with CommaContent Hi All, When loading a Journal Import interface, the process fails the data load for record… -
Journal Approval workflow sending multiple emailsSummary Journal Approval workflow sending multiple emailsContent Hi Our Journal Approval workflow is sending 2 approval emails for each user, how can I change the setup … -
Which table stores the hierarchies in ERP Cloud?Content Hi, In which table can I find this information?, Is there a NODO table? * - Investigating, I found the following statement gl_flexfields_pkg.get_description_sql(… -
Post JournalContent Hello when post journal system is show below message "You can't approve or reject the journal because you're not the approve." Thanks
-
After GL Budget Data loaded, how can we refresh OTBI / Cube?Content Hi, We have loaded data into GL_BUDGET_BALANCES table using FBDI from here: https://docs.oracle.com/en/cloud/saas/financials/21b/oefbf/general-ledger.html#import… -
Purge records from GL_BUDGET_INTERFACEContent Hi, We are using 21B (11.13.21.04.0). We used an FBDI loader file from here: https://docs.oracle.com/en/cloud/saas/financials/21b/oefbf/general-ledger.html#impor… -
How to use SOAP API "updateDffEntityDetails" for update GL journal DFF?Content Hi, we want to update GL journal DFF with SOAP API "updateDffEntityDetails". But there are no sample information and document about the case updateing GL journal… -
Saving a journal without selecting Post, is posting during nightly post scheduleContent Hello: Sometimes we would like to enter an Journal, but for one reason or another are not ready to post it (maybe we waiting an new acct to be added and intend t… -
FBDI - Hierarchy Error MessageContent Hi All, Attached is the screenshots of the FBDI I need to use, on validating the segment Hierarchies (GL_SEGMENT_HIER_INTERFACE), I am getting error messages lik… -
Changing ledger options after go liveSummary GL list of changes that can be made after go liveContent Hello Can we enable suspense for a ledger in PROD and later remove it. what would be the implications fo… -
Revaluation Accounting DistributionsSummary We would like to change the revaluation accounting distributions for one of our Business UnitsContent We would like to change the revaluation accounting distribu… -
Unable to open Financial Reporting StudioContent Hi All, We installed the Financial Reporting Studio through the cloud application. But after logging in we are unable to open the reports. Getting an error messa… -
eText Template File for Journals Import InterfaceSummary Looking for an existing eText Template to use for importing journal entriesContent Has anyone created an eText Template for the Journal Import Interface that can… -
General ledger - Balances real Subject Area not showing balances for natural account segment (hierarContent Hello, I have an issue with showing balances for the natural account segment column (hierarchy) in OTBI. Please find attached the screenshot of the report in the… -
Best Practice when country changes ISO currency codeContent When a country changes it's ISO currency code (i.e. Venezuela changing from VEF to VES) what is best practice for revising General Ledger setup? * Define new Pri… -
how to derive the other accounting segments from the Journal line that come from the Project (LaborSummary I need this Derivation to occur for all segments inherited from the Original Transaction to the Intercompany Line Created in Process, not just the Intercompany S… -
Journal CategoriesSummary Restricting all the Journal Categories from appearing on the Create Journal Screen.Content Can we restrict or limit the journal categories when creating a journa…