Journals
Discussion List
-
Can I create journal using visual builder excel templateSummary: Just wonder if we can use the visual builder excel template to create the GL journal Content (please ensure you mask any confidential information): N/A Version …Yeung Shing Keith 22 views 4 comments 0 points Most recent by Yeung Shing Keith General Ledger & Intercompany -
R13 How to generate a Trial Balance from OTBISummary R13 How to generate a Trial Balance from OTBIContent Hello : I was wondering if you can share with me any document how to create a trial Balance from OTBI . As f…gabriel kinovisques-163562 140 views 3 comments 3 points Most recent by TBIRD1 General Ledger & Intercompany
-
Change approver based on batch submitter and not creator.Summary: Hi Team, We have a requirement for our client where the journal approver should receive approval for batches based on the submitter and not creator of the batch…
-
Revaluation entry created for other currencySummary: There are 2 entries created when we revalued our balances. One is entered in PHP currency and the other in SGD, both with USD in the accounted amount. The accou…Anna Cielo 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Loading Pre-Acquisition Financials into Oracle FusionSummary: I am currently navigating the process of loading financial data into Oracle Fusion for periods going back to 2018. We initially considered using a separate ledg…SivaP 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to transform transaction entries coming from legacy system to oracle with different CoA?Hello, I am migrating journal entries from a legacy system to Oracle. The Chart of Accounts (CoA) in the legacy system consists of only three segments, whereas in Oracle…
-
Spreadsheet journal roll-forward not giving reversal periodSummary: Hello, When I use a previous months spreadsheet journal (ADFDi template) to post the current month journal, the new reversal period is not available to select. …Eoin Bryan 2 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Payroll subledger not appearing when attempting to drill down in DashboardWhen logged in trying to drill down thru the payroll ledger we cannot see anything on the subledger. Please help…below is what information we have. I am referring to thi…William Jordan 2 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Create Income Statement Closing Journal for first period of the following fiscal yearSummary: We have a requirement to run the Create Income Statement Closing Journal on Period 1 of the next Fiscal Year, however we ran this process several times but it d…
-
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 13 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 252 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 321 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 25 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 29 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 14 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 96 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…