Journals
Discussion List
-
How to default the current month when creating a Manual JournalSummary: How to default the Accounting Period in a manual journal entry Content (please ensure you mask any confidential information):In my previous job we had the Accou…Steffany Delucchi 33 views 5 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany -
Purge Purchase Transaction Tax Journal from Review Subledger JournalsSummary: We have a scenario where user has entered Purchase Transaction Tax Journal and it stuck in Invalid status, now user wants to purge it and re process it but we a…
-
Can Bad debts journal entries be auto created based on the bad debt provision amount calculated?Summary: There is a requirement to auto create the bad debts journal entries during period end based on the bad debt provision report generated in receivables. Is this p…
-
Manage Journals - View Transaction drilldown to Payables invoices missing Holds and Approvals tabSummary: How to get 'Holds and Approvals' visible when drilling down to payables invoice transaction ? Content (please ensure you mask any confidential information): Man… -
Change the journal line descriptionWould like to change journal line description so that it includes : supplier number/supplier name/invoice number/invoice line description. Is this possible?
-
Can we Restrict or Limit The Available Journal Categories When Entering Journals in fusionSummary: Can we Restrict or Limit The Available Journal Categories When Entering Journals in fusion Content (please ensure you mask any confidential information): We hav…Nidhi Chhajed 71 views 9 comments 0 points Most recent by Yuko Asanuma General Ledger & Intercompany
-
drill down journal general ledger with specific valuewe need to use the drill down function to extract entries in the general ledger with specific values in debit and credit; is there a condition that we can use?for exam…Francesca1 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Is it possible to route interface journal for approval after it's been updated?Summary: We have interface journals that are set to auto approve. However, if there are any errors with the journals that require correction, a user will need to update … -
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 2 views 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 251 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 2 views 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 138 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