add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, April 5

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.


No comments: