How To Open Or Close Periods in Oracle Apps R12

Controlling period statuses in Oracle EBS R12 is a vital part of the financial cycle. This guide provides detailed steps how to open GL period in Oracle Apps R12 with each subledgers and inventory, supported with examples, SQLs, and best practices.

In Oracle EBS R12, financial and operational transactions are recorded within specific accounting periods. Every subledger and ledger has its own period management system. Accurate period management ensures:

• Timely Financial Closure
• Data Integrity
• Audit Readiness

🌀 Period Lifecycle & Statuses

Each period can have one of the following statuses:

• Never Opened
• Future
• Open
• Closed
• Permanently Closed

💡 Only open periods allow transaction processing.

⚙️ Accounting Period Management

1. How To Open(Close) GL Period in Oracle Apps R12

🧭 How to Navigate for Open GL Period in Oracle Apps R12

General Ledger Super User→Setup→Open/Close:

✅ How To Open GL Period in Oracle Apps R12:

1. Select your Ledger
2. Choose the Period Name
3. Click button “Find“
4. “Open and Close Periods” will open
5. Click “Open Next Period”

🚫 How To Close GL Period in Oracle Apps R12:

🔎 Prerequisites Before Closing GL Period

• ✅ Ensure all subledgers (AP, AR, INV, PO, CST) are closed
• ✅ Post all journals (run Journals – Post)
• ✅ Reconcile Trial Balance and verify financial statements

📌 Steps to Close GL Period

• Navigate to GL Close Status
• Set period status to Closed from the LOV
• Press “Ok”
• Save the form

🔧 SQL Query to Find GL Period Status

SELECT fa.application_name, sob.name ledger, gps.period_name,
       gps.period_num, gps.start_date, gps.end_date, gps.closing_status
  FROM gl_period_statuses gps,
       gl_sets_of_books sob,
       fnd_application_vl fa
 WHERE 1=1 
   AND fa.application_name = 'General Ledger'
   AND sob.name='AU Primary'
   AND sob.set_of_books_id=gps.set_of_books_id
   AND fa.application_id = gps.application_id
   AND gps.adjustment_period_flag = 'N'
   AND gps.closing_status = 'O'
   AND TRUNC(SYSDATE) BETWEEN gps.start_date
                          AND gps.end_date;

2. How to Open/Close Payable Accounting Period

🧭 Navigation:

Payable Manager →Accounting→Control Payables Periods

✅ How To Open Payables Accounting Period

• Select Operating Unit (or Ledger)
• Click “Find”
• “Control Payables Periods” form will open
• Search for the specific period
• Click the Period Status LOV
• Select “Open” as Status
• Click “Ok” in the LOV Window
• Save changes

🚫 Steps To Close Payables Accounting Period

🔎 Prerequisites Before Closing AP Period

• ✅ Run Unaccounted Transactions Report
• ✅ Ensure all invoices and payments are accounted
• ✅ Transfer data to GL
• ✅ Resolve accounting holds or issues

📌 Steps to Close Payables Period in Oracle Apps R12

• Navigate to AP Close Period window
• “Control Payables Periods” Opens
• Search for the specific period
• Click the Period Status LOV
• Select “Closed” as Status
• Click “Ok” in the LOV Window
• Save changes

🔧 SQL Query to Find Payables Period Status

SELECT fa.application_name, sob.name ledger, gps.period_name, gps.period_num, gps.start_date, gps.end_date, gps.closing_status
FROM gl_period_statuses gps,
     gl_sets_of_books sob,
     fnd_application_vl fa
WHERE 1=1 
AND fa.application_name = 'Payables'
AND sob.name='AU Primary'
AND sob.set_of_books_id=gps.set_of_books_id
AND fa.application_id = gps.application_id
AND gps.adjustment_period_flag = 'N'
AND gps.closing_status = 'O'
AND TRUNC(SYSDATE) BETWEEN gps.start_date
                       AND gps.end_date;

3. How to Open/Close Accounts Receivable (AR) Period

🧭 Navigation:

Receivables Manager → Control → Accounting → Open/Close Periods

✅ How To Open Receivables Accounting Period

• Choose Ledger & press “Find”
• Set Status to Open or Press “Open Next Period”
• Save the form

🚫 Steps To Close Receivables Accounting Period

🔎 Prerequisites Before Closing AR Period

• ✅ Run Unposted Items Report
• ✅ Confirm all invoices, receipts, and adjustments are accounted
• ✅ Transfer data to GL

📌 Steps to Close AR Period in Oracle Apps

• Navigate to AR Open/Close Period
• Change the status of the period to Closed
• Save your changes

🔧 SQL Query to Find Receivable Period Status

In the above Payables Period Status query just change the application name to “Receivables”

WHERE 1=1 
AND fa.application_name = 'Receivables'

4. Open/Close Inventory Accounting Period

🧭 Navigation:

Inventory→ Accounting Close Cycle→ Inventory Accounting Periods

Select the Inventory Organization from LOV.

✅ How To Open Inventory Period In Oracle Apps R12

Follow bellow steps to Open Inventory Period in Oracle Apps R12

• Choose Inventory Organization from LOV
• Select the period to be opened
• Click “Change Status” button

🚫 How To Close Inventory Accounting Period:

🔎 Prerequisites Before Closing Inventory Period

• ✅ Transfer transactions to GL
• ✅ Run Inventory Transactions Summary Report
• ✅ Ensure all material transactions are completed and costed

📌 Steps to Close Inventory Accounting Period

1. Navigate the Inventory Accounting Period
2. Select the period
3. Set status to Closed
4. Save the record

🔧 SQL Query to Find Inventory Period Status

Below query can be used to check the inventory period status for an inventory organization

SELECT oap.period_year, oap.period_name, oap.start_date,oap.end_date, status, to_char(oap.last_update_date, 'DD-MON-YY HH24:MI') update_date
  FROM org_acct_periods_v oap,
       mtl_parameters mp
  WHERE period_year =2025
    AND period_name='P4-25'
    AND mp.organization_code='AUS'
    AND oap.organization_id=mp.organization_id
oRDER By period_year desc;

5. How to Open/Close Purchasing (PO) Accounting Period

🧭 Navigation:

Purchasing Super User→Setup→Financials→Accounting→Control Purchasing Periods

Enter the Fiscal year and click Go button.

✅ How To Open Purchasing Accounting Period

• Select Operating Unit
• Enter period Name and press “Go”
• Change to status to “Open”
• Save the record

🚫 Steps To Close Purchasing Accounting Period

🔎 Prerequisites Before Closing Inventory Period

• ✅ Run Inventory Transactions Summary Report
• ✅ Ensure all material transactions are completed and costed
• ✅ Transfer transactions to GL

📌 Steps to Close PO Period

1. Navigate to Control Purchasing Periods
2. Check for pending receipts
3. Ensure all transactions are accounted
4. Set status to Closed

🔧 SQL Query to Find Purchasing Period Status

In the above Payables Period Status query just change the application name to “Purchasing”

WHERE 1=1 
AND fa.application_name = 'Purchasing'

🌐 Real-World Example

Scenario:
A Kolkata-based distributor of printers and cameras needs to close March 2025 across all modules.

🔄 Actions:

📌 Final step: Closed GL after all subledgers.

📍 Use with caution and proper user initialization.

📌 Best Practices

• ✅ Always close subledgers first, then GL
• ✅ Maintain a checklist for each period-end close
• ✅ Use reconciliation reports before closing
• ✅ Don’t open unnecessary future periods
• ✅ Document who opened/closed and when

📎 Conclusion

Managing period status in Oracle R12 requires both process discipline and technical awareness. Whether you’re preparing for audit or month-end close, using the correct steps and understanding dependencies ensures data consistency and financial accuracy.

🔗 Additional Resources

• Oracle General Ledger User Guide (Oracle Docs)
• Subledger Period Close Checklist