General Ledger
Discussion List
-
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…George Mattar 356 views 4 comments 0 points Most recent by Sridhar_Rejeti_1423 General Ledger & Intercompany -
Auto reject approval rule for Unbalenaced JournalsHello All, We have business requriement for auto reject for unbalenace journals. Any one have same requriement earlier, pleae share your inputs here. Thanks, Hari. -
Two Adjustment Period at year end to create with Rapid load fileSummary: We need to create two adjustment period at the year end and rapid load file do not have that option, please let me know any suggestion on this Content (required…Sam Samaddar 34 views 5 comments 0 points Most recent by Muhammad Hamza Hanif General Ledger & Intercompany -
The GL Journal Action Log displayed a different username than the one who uploaded the journalHi, A user uploaded a GL Journal using a spreadsheet, however when the journal was imported into Oracle the Action Log of the imported journal displayed a different user… -
Automated intercompany transactions between legal entities under the same business unit.Can we process automated intercompany transactions between legal entities under the same business unit? -
Connecting ADFDI journal upload file to the ApplicationSummary: Connecting ADFDI journal upload file to the Application Content (please ensure you mask any confidential information): I opened the ADFDI journal upload file, w…ramesh.sivapalan 10 views 0 comments 0 points Started by ramesh.sivapalan General Ledger & Intercompany -
How to use Parent Value in Target and Source section of Formula component in calculation managerWhile defining the allocation rule we have requirement to use parent value in Source and Target section of allocation rules. While Entering parent value in Source and ta…Basant Parihar 141 views 6 comments 0 points Most recent by Nikhil_Jain10_07 General Ledger & Intercompany -
Journal workflow rule template for Attachments in Journal BatchSummary: I want to update the rules in Journal workflow rule template to Auto-reject a journal if it doesn't have Attachment file in Journal Batch. The template (at Mana…HarshitBa 12 views 2 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Understanding Impact on Enterprise StructureGiven the current setup in which primary ledgers vary by country, is it feasible to consolidate them into a single ledger? What would be the potential impact of doing so?Cliford 17 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Fusion GL Calculation manager - Variable designer - Default valueSummary: I need help to default Accounting_Period value to be previous period as dynamic so that the ESS Job Generate Allocations can be scheduled instead of user runing… -
Privileges to add Values in Value set ( To add value and not to enable the check box)Summary: Hi, Is there any privileges to restrict the user to enable the "Enabled" check box while adding the values in value set? Content (please ensure you mask any con…Arunkumar Augustine 10 views 0 comments 0 points Started by Arunkumar Augustine General Ledger & Intercompany -
Redwood pages in General Ledger?Summary: Please Oracle teams, any clue about when we will see a Redwood page for this module? No specific dates but some clues. Content (please ensure you mask any confi…Juan Jesus 47 views 3 comments 0 points Most recent by Priyaranjan Nayak General Ledger & Intercompany -
Allocation formula is not generating allocation journalsSummary: Allocation formula is not generating allocation journals, we are getting below message in the log - Message data is :::::FUN_ALLOC_NO_LINES The allocation gener… -
Restricting Usage of Statistical Accounts against STAT currency onlySummary: We need to restrict the usage of Statistical natural accounts against STAT currency only. Content (please ensure you mask any confidential information): This is…Iffat Shaikh 92 views 6 comments 1 point Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Issue Converting Accounting Calendar from Fiscal Year to Calendar Year in Oracle FusionSummary: Hello Team, We are in the process of modifying our existing accounting calendar setup in Oracle Fusion Financials. Currently, the ledger is using a fiscal year … -
How to setup a Context Sensitive DFF to work based on GL Journal Category?Summary: How to setup a Context Sensitive DFF to work based on GL Journal Category? Content (please ensure you mask any confidential information): We have a requirement …ramesh.sivapalan 12 views 0 comments 0 points Started by ramesh.sivapalan General Ledger & Intercompany -
Delete approved but unposted journals from Spreadsheet sourceSummary: We had created a journal batch which was then approved. During posting, an issue came up with Intercompany due to which the journals could not be posted. Now we… -
Budgetary Control Validation Online Inquiry line display limitSummary: In one journal entry, several transactions failed the funds validation, and due to the volume of lines in the journal, a results report is being run instead of …Tahlia Mena-Oracle 4 views 0 comments 0 points Started by Tahlia Mena-Oracle General Ledger & Intercompany -
General Ledger Account Groups query criteria to include Chart of AccountsSummary: We are looking for Query by example on General Ledger Account Groups to include Chart of Accounts criteria, is anyone aware if this function available with a pr… -
Common GL Posting Errors and How to Troubleshoot ThemHi everyone, As a beginner when transferring journals from subledgers to General Ledger in Oracle ERP Cloud, I sometimes get posting errors. What are the most frequent c…Kiltom AP 18 views 1 comment 1 point Most recent by Venkatesh Padamwar General Ledger & Intercompany -
How to Delete Multiple Account Hierarchy Tree VersionsSummary: We would like to know if there is a way to delete multiple hierarchy tree versions at a time in Oracle Financials Cloud. I mistakenly created 1,254 tree version…Jayendra Sreekar Kurali 21 views 3 comments 0 points Most recent by Lakshmi Kameti General Ledger & Intercompany -
Control budgets not populating in LOV in Enter Budget in SpreadsheetSummary: Hi Team We have created a Control Budget: OH Control Budget_1 and completed all the required setups. The required roles and data access also given to the user b… -
Defining Approval rule in SRC for late journal entries(post business day 10th)Summary: We have a requirement to create an approval rule for journals based on journal batch creation date. All journals created after populated accounting period end d… -
Has anyone set Allocation rule in GL to create Standard Recurring Journals?Summary Unable to create variable for Accounting PeriodContent Hi, We are trying to use allocation rule to create Standard recurring journals and I'm unable to create va…Sathya Kannan 97 views 5 comments 1 point Most recent by Sudhakar Reddy N-Oracle General Ledger & Intercompany -
Accounting Date Range in AutoPost Criteria SetSummary: Query: The user wants to post journals based on the Accounting Date. Does the “Autopost Journals” process work based on the Submission Date or the Accounting Da…Rama Mohan ReddyB 19 views 1 comment 0 points Most recent by Jamal Saboonchi General Ledger & Intercompany -
Is there a way to automate the configuration steps when there is a new entity COA value?When there is a new entity value that feeds into ERP from EDMCS, we then complete the required configuration steps for the new entity, such as Manage Legal Entity, Assig… -
How can I find correct load_request_id for transactions those are stuck in the GL_INTERFACE tableSummary: How can I find the correct load_request_id for transactions that are stuck in the GL_INTERFACE table? Please help to a SQL query. Content (please ensure you mas… -
can’t delete the journals that are currently in an error statusHello, In GL, I have journal entries that were imported and ended in error, and cannot be deleted. I have already executed the "Delete Import Data" and "Purge Interface …Teresa Martinez-Oracle 9 views 1 comment 0 points Most recent by George-Oracle General Ledger & Intercompany -
Unable to select the BU in "Assign Business Unit Business Function".Summary: Unable to select the BU in "Assign Business Unit Business Function". Content (please ensure you mask any confidential information): We have created a setup user…koji shinoda 24 views 3 comments 0 points Most recent by George-Oracle General Ledger & Intercompany -
Changing prompt for FUTURE KFF segment in COASummary: The company wants to change the Name/Prompt of a FUTURE segment in COA KFF. Please share your experience and thoughts regarding the considerations and consequen…