Journals
Discussion List
-
STAT journal in closed periodSummary: We have requirement to be able to post STAT journal even in period which has been closed Content (please ensure you mask any confidential information): Is it po…N&A Support Team 11 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
How to generate Tax Journals automatically from Manual Journals in Oracle Fusion General LedgerSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Journal Approval QuerySummary: Journal Approval Query Content (required): Business wants to implement Journal approvals: Question 1: Approval should trigger parallelly to set of people (Appro…Kumar 57 231 views 7 comments 0 points Most recent by Wilson Chelakadan General Ledger & Intercompany -
How to set up Clearing Accounts Reconciliation in the case of creating a JV ReverseSummary: How to set up Manage Clearing Accounts Reconciliation: In the case of creating a JV with the Period Ending Accrual type in this month, the system automatically …Sarinee.p 11 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Context Sensitive Segments Are Not Appearing For Lookup Values Descriptive FlexfieldHi, I have defined a common lookup code and would like to populate the DFF for lookup values. But, context is not showing at lookup line level. Do i need to run addition…
-
What would cause a journal batch to go from STATUS_VERIFIED='Y' to STATUS_VERIFIED='N'Hi Guys We have a BIP report based on journal batches/headers/lines developed by an outside consultancy that has the filter below on it: GJB.STATUS_VERIFIED='Y' All good…
-
Period End Accrual - Paid Invoice is reflecting in this accountWe noticed that some of our invoices are were but those appear in the Period End Accrual. We expected the system to exclude invoices from the Accrual Account if the invo…Wilson Chelakadan 1 view 1 comment 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub -
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 21 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 139 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 1 view 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 1 view 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 1 view 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
-
No Journal Line generated for the 1st rule in the Allocation Rule SetSummary: When running the Allocation Ruleset, no journal line is generated for the first rule. However, when the rule is run individually, a journal line is generated. I…
-
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…
-
Legal Entity-Specific Secondary Ledgers with Controlled Replication from Primary Ledgers Not WorkingSummary: Tried to test Legal Entity-Specific Secondary Ledgers with Controlled Replication from Primary Ledgers New feature but not working it seem Content (please ensur…Rajesh Kumar Podi 11 views 2 comments 0 points Most recent by Pakki Siva Sailesh General Ledger & Intercompany
-
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 192 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 228 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 31 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 21 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 21 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…