Journals
Discussion List
-
When to use Historical Rates?Summary: Our client wants to load AED journals to the AED ledger. The balance in the ledger will then be translated to USD as our Reporting Currency ledger (AED to USD).…JPLED415 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Microsoft .NET Framework Runtime requirement - Oracle CommsSummary: Client received following comms from Oracle: Reminder - In Oracle Fusion Cloud Update 24C, the Oracle ADF Desktop Integration (ADFdi) Excel add-in installer wil…Kristina Timberlake 242 views 10 comments 0 points Most recent by Alex D-Oracle General Ledger & Intercompany -
Run Closing Journals process after year-end closeContent We have a requirement to run the closing journals process to generate these journal entries. I have never run these processes and let alone this long after the a…
-
Does anybody know how to create Journal Approval Rule based on the converted amount of Journal BatchSummary: Client wants to have an approval based on the Journal Batch Amount converted to USD. The rule is if the converted Journal Batch amount is greater than 1M USD, i…
-
Journal Import FBDI upload successful but Journal Import process not picking up.Content Hi, Can anyone please assist- I have uploaded Journals using FBDI but notice the Import process is not picking up these Journals and creating them. I did the fol…naailah Gora 309 views 3 comments 4 points Most recent by Viraj Vaibhav General Ledger & Intercompany -
Access Issue - Create Taxable Transactions in Spreadsheet is missing Business Unit in LOVSummary: Access Issue - Create Taxable Transactions in Spreadsheet is missing Business Unit in LOV. When Creating a taxable journal in GL, for Purchase Transaction or Sa…Rohit Dhannawat 32 views 6 comments 0 points Most recent by Deb from Kolkata General Ledger & Intercompany
-
How to Remove Access to "Create Taxable Transactions in Spreadsheet"Summary: Remove Access to "Create Taxable Transactions in Spreadsheet" and "Correct Taxable Transactions in Spreadsheet" Content (required): I have copied General Accoun…prakhar.s 31 views 2 comments 0 points Most recent by Deb from Kolkata General Ledger & Intercompany
-
Reversal period manually updated in PL journal is not overwritten by period populated in SLSummary: Customer is trying to update the Reversal Journal period after the Original JE is flown from PL to SL and He wants the changes should be in sync with PL to SL C…Rajesh Kumar Podi 22 views 2 comments 0 points Most recent by Rajesh Kumar Podi General Ledger & Intercompany
-
Does it possible to post Automatically Manual journal and subledger journalSummary: One of our customers requires the automatic posting of manual journals and sub-ledger journals once the notification is approved. They expect that they should n…Veeranarayana Swamy-Oracle 23 views 4 comments 0 points Most recent by Veeranarayana Swamy-Oracle General Ledger & Intercompany
-
Journal sourceHi, I would like to know what transactions will trigger the below 4 journal sources or in another words how does the below journal sources get created? Are they the subl…
-
Broken links in Journals when using saved templateWe are saving a journal template as we have created custom sheets to feed information into the Multiple Journals sheet. However, after a couple of months, the Reversal P…
-
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…
-
How to restrict the Reversed Journal being adjustedSummary: We have requirement to restrict the Journal created for reversal without allowing to edit and reverse the Orariginal JE Entry Content (please ensure you mask an…Rajesh Kumar Podi 27 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to default the Company segment value based on SQL query taking the value of legal entity.Summary: We have Unified COA shared across multiples Ledgers. Each Ledger represents a Legal Entity. Each a Legal Entity has a single Company Code. How to default the Co…
-
Restrict posting of Intercompany Journals linesSummary: Hi Team, We have certain Intercompany balancing rules defined for Primary balancing segment for all sources. Can you please advise if there is a way that we cou…Goutam5555 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Why are duplicate subledger journals being created?Hello, We have a scenario where we are manually entering a Payroll subledger journal and it is producing two journals upon posting. I understand the flags Y and N relate…OConsHD 13 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
How can we see Jornal rejection in the bell notificationHi Community, I need help on the below topic. Please help. Journal went for approval and the approver rejected the journal with the reason in the comments. How can we se…Jakee_Agarwal-Oracle 3 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Effect of disabling COA Values on Infight transactionsSummary: Hi, We have a business scenario where users want to disable certain COA values for 2025. But we see there are few inflight transaction for revenue scheduling an…Goutam5555 1 view 2 comments 0 points Most recent by AmarnathVankadara General Ledger & Intercompany
-
How to establish link between Primary and Secondary Ledger entriesSummary: I want to determine how Oracle establishes a link between entries posted in Primary and Secondary Ledger on backend table. Content (please ensure you mask any c…Akhil Chawan 85 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to get extra parameter in derived by field in manage DFF in GL for journal linesSummary: how to get extra parameter in derived by field in manage discriptive flexfields in GL for journal lines Have a requirement to get the DFF value depending on the…
-
Customer wants two different accounts in Revaluation.Is this Possible.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can Auto copy source be changed?When we manually copy the journal and create duplicate journal the journal source automatically reflect as auto copy rather it should be manual. How to change the journa… -
Transfer to GL StatusSummary: In Review Journal Entries task, what does it mean when the Transfer to Ledger Status = Selected? Content (please ensure you mask any confidential information): … -
Ability To Delete An Attachment From A Posted JournalSummary: Ability To Delete An Attachment From A Posted Journal in GL Content (please ensure you mask any confidential information): Version (include the version you are …
-
How to schedule standard recurring journal entrySummary: How to schedule standard recurring journal entry with constant debit and credit accounts and amount. Content (please ensure you mask any confidential informatio…
-
General Ledger: DFF at Journal Line - GL_JE_LINES vs GL_CAPTURED_INFOSummary: Is there any reason to use GL_JE_LINES vs GL_CAPTURED_INFO at DFF at journal line level? Content (required): Or is it just ability to have 2 DFF structures and …
-
Differences between posted journals in the tables GL_JOURNALS and GL_BALANCES.We have seen some differences between posted journals in the tables GL_JOURNALS and GL_BALANCES. I thought that the table GL_BALANCES was updated when a journal was post…Jesper Maarbjerg SDU 13 views 3 comments 0 points Most recent by Jesper Maarbjerg SDU General Ledger & Intercompany
-
Ability to restrict reversal method to be used by the usersSummary: Hi Team, We understand that we have 2 methods to reverse the Journal in Oracle (switch debit or credit and change sign). We have a requirement to restrict the u…
-
Error when loading journals via spreadsheetSummary: Hi I am getting the following error when loading some journal in the ADFDI template : You're using an account that's either disabled for posting or a control ac…
-
Issue with RevaluationIssue: Bank Account Currency equal to Entity Currency: - In the Global Template, all accounts are included. As a result, when there is a transaction in other currency, t…