Journals
Discussion List
-
Can a journal category be assigned to only specific ledgers?Summary: Can a journal category be assigned to only specific ledgers? Since we want to have separate journal categories for each ledger, we would like to know if Oracle …Sarinee.p 1 view 1 comment 0 points Most recent by Vivek Mandowara-Oracle General Ledger & Intercompany -
Change JournalEntry spreadsheet to use specific data format instead of windows default formatCan we configure the JournalEntry excel spreadsheet downloaded with "Create Journal in Spreadsheet" to use specific data format (e.g. dd-MMM-yyyy) instead of using the w…
-
Jouarnal Line Description for Subledger JournalsCurrently we have non Oracle system accounting entries transferring to GL through Accounting Hub (FAH). We have setup the Journal Line Description rule to include the re…
-
How to lock accounted amount for foreign currency journal using corporate rate typeHi Team, We've maintain daily corporate rate in the system by group HQ according to company policy. However, when user input foreign currency journal in GL, after accoun…Wang Yuan-Oracle 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can JV Approval by specific Journal Category?Summary: Can JV Approval by specific Journal Category? For example, having Manager A approve the Journal Category name Adjustment and Manager B approve the Journal Categ…Sarinee.p 1 view 1 comment 0 points Most recent by Vivek Mandowara-Oracle General Ledger & Intercompany
-
How to Set Up secondary Balancing SegmentsI want to set up with multiple balancing segment labels so that journal entries like attachments can be created. I tried to grant a secondary segment label, but I couldn…
-
How to not display LE that has already reached the end date in the TB ReportSummary: How to not display LE that has already reached the end date in the TB Report? Since the LE we created is no longer in use, can we remove it from the TB Report? …Sarinee.p 11 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to enable Journal Line DFF for particular journal source or categorySummary: Can we enable Journal Line DFF for particular journal source or category Content (please ensure you mask any confidential information): Version (include the ver…Arun Kumar Vikram M 21 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Need a API to get Journal ledger id and legal entityLooking for an API that will give ledger id and legal entity in single response. Is there any API that exist that meets the requirement?keith.robin 1 view 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
To make the Journal Batch and Journal Name fields auto-assigned instead of free textHow to make the Journal Batch and Journal Name fields auto-assigned instead of free text? We have configured and setup the GL journal sequencing but it is only for GL do…Hafizudin Imran 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Journal Reversal without Auto Reversal CriteriaSummary: Hi, We are populating reversal information while creating journal using ADFDI. Category on journal is not added to Auto Reversal criteria set. Journal is gettin…
-
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 250 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 23 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 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 1 view 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 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 264 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…