Oracle gl
Author: e | 2025-04-24
The process integration between Oracle Retail (RMS, ReSA, and ReIM) and Oracle GL supports the following integration flows: Post stock ledger from RMS to Oracle GL. Post channel sales, cash, and deposits from ReSA to Oracle GL. Post write-offs (aged receipts, not invoiced to ledger) from RMS to Oracle GL
GL Wand – Wands for Oracle
The Liability accounts total in the GL. We have some set of Liabilityaccounts in the Payables, which we only use in the Invoice Headers tobook the Liability and we match only these Liability GL accounts in the AP andGL reconciliation report.We tookthe help of Payables Trial Balance report to find the Total APliability and then Run the GL Trial Balance report to match the Payables TrialBalance Report Total with the GL trial Liability Accounts.11. Distribution Set in OraclePayablesAnswers :Distribution set is the combinationof multiple Distribution lines using different -2 GL accounts Combination. ForExample , We booked most of the AP invoices in two different GLaccounts combination so each time we need to enter two lines in the invoice distributions tobook the AP invoices expenses in these two GL accounts but this process can bemake query quickly and easy. Oracle have functionalitylike Distributions set in oracle payables where we can any number ofGL accounts line for a Given Distribution sets and then in the Oracle PayablesInvoices we don’t need to create Distribution lines manually. We just need toenter the Distributions Set in the Ap invoice Lines andoracle system automatically creates the Invoice distribution lineswith GL accounts given in the distribution set in oracle payables r12. The process integration between Oracle Retail (RMS, ReSA, and ReIM) and Oracle GL supports the following integration flows: Post stock ledger from RMS to Oracle GL. Post channel sales, cash, and deposits from ReSA to Oracle GL. Post write-offs (aged receipts, not invoiced to ledger) from RMS to Oracle GL Processing unit is the number of transactions processed by the Create Accounting program in one commit cycle. The Create Accounting program processes the default processing unit size at the application level.Setting Up Subledger Accounting OptionsPrerequisitesSet up a subledger application in the Accounting Methods Builder (AMB).See: Accounting Methods Builder (AMB) IntroductionSet up ledgers in General Ledger.See: Primary Ledger Setup Steps, Oracle Financials Implementation Guide and Secondary Ledger Setup Steps, Oracle Financials Implementation GuideTo Update Subledger Accounting Options and System OptionsIn the Accounting Setup Manager, execute a search for a ledger.In the Results region, click the Update Accounting Options icon for a ledger.In the Primary Ledger region or the Secondary Ledger region, click the Update icon for Subledger Accounting Options.In the Subledger Applications page, click the Update Accounting Options icon to update accounting options or the Update System Options icon to define the processing unit size.Update the accounting options as described in the following section, Subledger Accounting Options Setup Description.Subledger Accounting Options Setup DescriptionGeneral Options RegionSubledger Accounting ENABLEDThe Subledger Accounting option is visible only for secondary ledgers in the ledger options view described in Subledger Accounting Options Setup Pages. Enable or disable the subledger application for the ledger. No entries will be generated by Subledger Accounting for an application if Subledger Accounting is disabled for the ledger.General Ledger Journal Entry SummarizationThe General Ledger Journal Entry Summarization option determines whether subledger journal entries are summarized when they are transferred to General Ledger as described in the table below.General Ledger Journal Entry Summarization OptionsOptionDescriptionSummarize by GL PeriodDefault option; indicates that all subledger entry lines with the same GL period, General Ledger journal category, account, entered currency, side, and balance type are summarized into a single General Ledger entry; disabled if ledger uses daily balancingThe GL effective date defaults to the last date of the accounting period.Summarize by GL DateIndicates that all subledger entry lines with the same GL date, General Ledger journal category, account, entered currency, side, and balance type are summarized into a general ledger entry; default value if Summarize by GL period is disabledThe GL effective date is equal to the subledgerComments
The Liability accounts total in the GL. We have some set of Liabilityaccounts in the Payables, which we only use in the Invoice Headers tobook the Liability and we match only these Liability GL accounts in the AP andGL reconciliation report.We tookthe help of Payables Trial Balance report to find the Total APliability and then Run the GL Trial Balance report to match the Payables TrialBalance Report Total with the GL trial Liability Accounts.11. Distribution Set in OraclePayablesAnswers :Distribution set is the combinationof multiple Distribution lines using different -2 GL accounts Combination. ForExample , We booked most of the AP invoices in two different GLaccounts combination so each time we need to enter two lines in the invoice distributions tobook the AP invoices expenses in these two GL accounts but this process can bemake query quickly and easy. Oracle have functionalitylike Distributions set in oracle payables where we can any number ofGL accounts line for a Given Distribution sets and then in the Oracle PayablesInvoices we don’t need to create Distribution lines manually. We just need toenter the Distributions Set in the Ap invoice Lines andoracle system automatically creates the Invoice distribution lineswith GL accounts given in the distribution set in oracle payables r12.
2025-04-03Processing unit is the number of transactions processed by the Create Accounting program in one commit cycle. The Create Accounting program processes the default processing unit size at the application level.Setting Up Subledger Accounting OptionsPrerequisitesSet up a subledger application in the Accounting Methods Builder (AMB).See: Accounting Methods Builder (AMB) IntroductionSet up ledgers in General Ledger.See: Primary Ledger Setup Steps, Oracle Financials Implementation Guide and Secondary Ledger Setup Steps, Oracle Financials Implementation GuideTo Update Subledger Accounting Options and System OptionsIn the Accounting Setup Manager, execute a search for a ledger.In the Results region, click the Update Accounting Options icon for a ledger.In the Primary Ledger region or the Secondary Ledger region, click the Update icon for Subledger Accounting Options.In the Subledger Applications page, click the Update Accounting Options icon to update accounting options or the Update System Options icon to define the processing unit size.Update the accounting options as described in the following section, Subledger Accounting Options Setup Description.Subledger Accounting Options Setup DescriptionGeneral Options RegionSubledger Accounting ENABLEDThe Subledger Accounting option is visible only for secondary ledgers in the ledger options view described in Subledger Accounting Options Setup Pages. Enable or disable the subledger application for the ledger. No entries will be generated by Subledger Accounting for an application if Subledger Accounting is disabled for the ledger.General Ledger Journal Entry SummarizationThe General Ledger Journal Entry Summarization option determines whether subledger journal entries are summarized when they are transferred to General Ledger as described in the table below.General Ledger Journal Entry Summarization OptionsOptionDescriptionSummarize by GL PeriodDefault option; indicates that all subledger entry lines with the same GL period, General Ledger journal category, account, entered currency, side, and balance type are summarized into a single General Ledger entry; disabled if ledger uses daily balancingThe GL effective date defaults to the last date of the accounting period.Summarize by GL DateIndicates that all subledger entry lines with the same GL date, General Ledger journal category, account, entered currency, side, and balance type are summarized into a general ledger entry; default value if Summarize by GL period is disabledThe GL effective date is equal to the subledger
2025-04-06Last updated on DECEMBER 27, 2023Applies to: Oracle Fusion General Ledger Cloud Service - Version 11.13.21.10.0 and laterInformation in this document applies to any platform.SymptomsOn : 11.13.21.10.0 version, GL Reports & Inquire ScreensWhen attempting to drill down using Account Inspector or Detail Balances, the following information message is shown.ERROR-----------------------The information you’re about to submit is not secure.Because this form is being submitted using a connection that’s not secure, your information will be visible to others.The URL Sowssmartview://localhost?svrender\ long string that seems to be an ECIDSTEPS-----------------------The issue can be reproduced at will with the following steps:1. Have a Smart View Report Open2. Drill into a balance 3. Select any of Account Inspector or Detail Balances4. The Information message is shownCause To view full details, sign in with your My Oracle Support account. Don't have a My Oracle Support account? Click to get started! In this Document My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
2025-04-01Has been due before “07-Dec-2018”.6. How AP Invoice Payment Due Date Calculates in OraclePayablesAnswers :Invoice Payment Due date dependson the Two Factors.1.Payment Terms attached tothe Invoice2. Invoice Date.For Example, if Payment Terms is 30Days and the Invoice Date is 12-Dec-2018Then Payment Due Date Will be :12-Jan-20197. What is Primary and Secondary Ledger in Oracle Payables ?Answers :Primary Ledger is the Main Ledger andSecondary Ledger is the Replica of the Primary Ledger. We Do transactions inthe Primary Ledger. The main reason of using Primary and Secondary Ledger isthe difference in the Organization Requirement and the Statuary Requirement.For example, One US based company office is in India and as per US Company,their Calendar works from Oct to Sep but the in India their calendar works fromApr to Mar SO in this Kind of Requirement, Primary and Secondary Ledger conceptcomes. Where we can design the Primary calendar as per the US based but candesign the Secondary calendar as per India Statuary Requirement. 8. What is Recurring Invoice in Oracle ?Answers :As its name represents ‘Recurring’.Recurring means again and again. If any Organization books the Officerent invoice every month for the same amount or any other fixedexpenses every month then oracle has provided the Recurring Invoice. Wejust need to do the recurring Invoice setup for that amount andsystem will create the invoice automatically on the First day ofthe Months.9. What is the Use of Payables Trial Balance report ?Answers :PayablesTrial Balance Report shows the Total Liability or the Supplier Outstanding inthe System. This Report shows the Liability in the System supplier and SiteLevel. This Provide the Summary Information’s for all the Unpaid amount for theSupplier Invoices which are validated.10. What we do in the AP and GLreconciliation ?Answers : In the APand GL reconciliation, we try to Match the Total Liability from the Payableswith
2025-04-05