Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Year End Closing

Posted on July 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Continuing last article Does the “Year End Close” is different than “Month end close” – Part -I , lets have a look on the some steps involved for the year end process

Steps as required for year End Close in Oracle EBS.

These are the some of the standard steps performed for year-end processing in Oracle General Ledger.

1. Set the status of the first accounting period in the new fiscal year to Future Entry. Generally the first period of the new fiscal year should not be opened until all of the year-end processing for the last period of the current year has completed.

2. (Optional) Create reversing entries at the beginning of every period, generate and post accruals from the prior period now.

3. If you have other source make transfer data from all of subledgers and feeder systems to the GL_INTERFACE table.

4. Then ,run the Journal Import process to populate the GL_JE_BATCHES, GL_JE_HEADERS, and the GL_JE_LINES tables. This can be done automatically from the subledger systems, or manually from Oracle General Ledger.

5. Now the next is review the Journal Import Execution Report to check the status of all imported journal entries.

6. If there is any error journal entry batches, delete it.

7.a. If you encounter a small number of errors, make the necessary corrections in the GL_INTERFACE table using the Correct Journal import Data window. Run Journal Import.

7.b . If you encounter a large number of errors, delete the Journal Import data from the GL_Interface table, correct the information in the feeder or subledger system and run Journal Import.

8. Close the period for each subledger. This prevents future subledger transactions from being posted to General Ledger in the same period as part of regular month end close process.

9. Review the imported journal entries in Oracle General Ledger. These can be reviewed online or in reports. Reviewing journal entries before posting minimizes the number of corrections and changes that need to be made after posting.Normally these Reports are run for review.

  • Journal Batch Summary Report
  • General Journal Report
  • Journal Entry Report
  • Journal Line Report
  • Journal Source Report
  • Journals by Document Number Report (This is when document sequencing is used)
  • Unposted Journals Report.

10. Then the Post all the imported journal entries.

11. Perform reconciliations of ledgers by reviewing and correcting balances.The following reports are useful to help with the reconciliation:

  • Account Analysis with Payables Detail
  • Account Analysis with Subledger Detail
  • Account Analysis with Subledger Detail II
  • General Ledger Report
  • Posted Journals Report
  • Journals Report with Subledger Detail
  • Accrual Reconciliation Report
  • Other Reports

12. Generate all recurring journals.

13. (Optional) If you did not generate and post your prior period reversals at the beginning of this period, be sure to generate reversals now.

14. Running the revaluation process to get revalue balances to update foreign currency journals to the functional currency equivalents.

15. Then the posting all journal wheather its is manual, recurring, step-down allocations, and reversals.

16. Review your posting results. The following reports are helpful:

  • Posting Execution Report
  • Error Journals Report

17. Update any unpostable journal entries and then post them again. Common reasons for unpostable batches include:

  • Control total violations
  • Posting to unopened periods
  • Unbalanced journal entries

All errors in the journal entry batches must be corrected and resubmitted for posting.

18. Run General Ledger reports, such as the Trial Balance reports, Account Analysis reports, and Journal reports.

19. Consolidate the other sets of books if you instance is having multiple Operating units.

20. If using a calendar with an adjusting period that represent the last day of the fiscal year, close the current period and open the adjusting period.

21. Create and post adjusting entries and accruals in the adjusting period.

22. Run Trial Balance reports and other General Ledger Reports in the adjusting period after adjustments are made.

23. Post the Balance Sheet Closing Journal by submitting the Create Balance Sheet Closing Journals program, once this is done balance sheet will now reflect zero balances which is same as mention above.

24. Close the last period of the fiscal year using the period window.

25. Open the first period of the new fiscal year to launch a concurrent process to update account balances. Opening the first period of a new year automatically closes our your income statement and posts the difference to your retained earnings account specified in the Set of Books form.

26. Run FSG reports for the last period of the year.

Related Posts

Posted in Oracle General Ledger | 1 Comment »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. SAP-ORCL - ‘ GL Journal’ Says:

    […] So with above period structure you could enter a journal dates 12 December 07 (i.e. P12) with flag clicked to reverse next accounting period and it would reverse out P1 FY08 OR you could have set up a journal template of YEAR END which already has this rule predefined so whether it was entered P12,P13 or P14 it would all still backout P1. Any journal can be later reversed or backed out (i.e. you don’t have to have defined it as a type reversing when it was first created). For Details refer earlier post on year end Year End Closing. […]

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.