R12.X -Opening and Closing Accounting Periods

Open and close accounting periods to control journal entry and journal posting, as well as compute period-end and year-end actual and budget account balances for reporting.

You can open and close accounting periods in two ways:

• The Open and Close Periods window
• The Open and Close Periods programs

If you have Ledger Sets defined, you can open and close periods for multiple ledgers in a single process using the Open and Close Periods programs.

Accounting periods can have one of the following statuses:

• Open: Journal entry and posting allowed.
• Closed: Journal entry and posting not allowed until accounting period is reopened. Reporting and inquiry allowed.
• Permanently Closed: Journal entry and posting not allowed. You cannot change this period status. Reporting and inquiry allowed.
• Never Opened: Journal entry and posting are not allowed. General Ledger assigns this status to any period preceding the first period ever opened in your calendar, or to any period that has been defined, but is not yet future-enterable. You cannot change this period status.
• Future-Entry: Journal entry is allowed, but posting is not. Your period is not yet open, but falls within the range of future-enterable periods you designated when defining your Ledger. You cannot change this period status without using the concurrent process to open the period.

 Open and Close Periods Programs

You can open and close periods for a single ledger or multiple ledgers in a ledger set with one of the following programs:

·         Periods – Open Periods: To open periods up to and including the specified target period for one or more ledgers.

·         Periods – Close Period: To close a single period for one or more ledgers. Only open periods can be closed.

Note: The Close Period program completes with a warning if unposted journals exist in the period.

·         Periods – Gapless Close Period: To close a consecutive range of open periods for one or more ledgers. This program closes the specified period and all prior periods that are still open.

·         Periods – Permanently Close Period: To permanently close one or more closed periods for one or more ledgers. Periods starting from the initial period must be closed before you can permanently close them. To permanently close a range of closed periods, the specified period and any prior periods must have a status of Closed or Permanently Closed.

Caution: When you permanently close a period, all prior periods are also permanently closed and can never be re-opened.

You can schedule your Period programs to run automatically based on schedules you define in Oracle Applications or in General Ledger.You must have read and write access to the ledger and all of its balancing segment values and management segment values to open and close periods.

Prerequisite:·         Define your ledger and ledger sets.

To run the Periods programs:

1.      Navigate to the Submit Request window.

2.      Choose to Submit a Single Request.

The Submit Request window appears.

3.      In the Request Name field, select one of the following Period programs:

o    Period: Open Periods

o    Period: Close Period

o    Period: Gapless Close Period

o    Period: Permanently Close Period

 

4. Complete the following parameters:

• Ledger/Ledger Set: Enter the name of the ledger or ledger set. You can only access ledger sets that are included in your data access set. 

         Note: You must have read and write access to the ledger and all of its balancing segment 

         values and management segment values to run the Period program.

• Period Name: Enter the period you want to open, close, or permanently close.

 

5 .Select OK to close the Parameters window. 

6. Submit the program. A concurrent process is launched.

 

For a ledger set, the program launches a parent request and separate child requests for each ledger in the ledger set. The parent request execution report outlines all the ledgers that were processed.

Oracle E-Business Apps Analyzer Diagnostic Scripts

       Financial Analyzers:

Auto Invoice Post-Process Analyzer: Overview and Installation Instructions :

The Auto Invoice Post-Process Validation Report is a Self-Service Diagnostic non-invasive script which reviews the overall status of the Auto Invoice Interface tables, analyzes the validation errors encountered by Auto Invoice program and provides recommendations for resolving the errors.

Auto Accounting Analyzer:

Auto Accounting issues are typically addressed by correcting setup. This analyzer will identify if you have incomplete or incorrect setup for Auto Accounting, and walk you through the navigation telling you what record to query and update to fix the errors.

R12: Payables Create Accounting Analyzer:

Invoice/Payment not getting picked up for Created Accounting? Invoice/Payment accounting with an error? Run the R12 Payables Create accounting Analyzer to find the problem. It checks your ledger and sub-ledger setup for issues. It verifies the transaction and event statuses are correct. It checks for data integrity issues that will prevent accounting.

R12: Payables Period Close Analyzer - Diagnostic to Validate Data Before Period Close :

The PCH works in conjunction with the MGD as the month end. Through the month you detect and fix data issues with the MGD. At the month end the PCH gives you a summary of what other issues may be preventing you closing the Payables Period. In a single run you get aware of transactions pending accounting, unprocessed invoice lines, orphan events and many more typical exceptions that need action ahead of closing the period. The tool indicates exactly what steps you need perform to address each exception type. For convenience this analyzer can be registered as a concurrent process.

R12: EBTax Setup and Data Integrity Analyzer:

This analyzer scans for typical EBTax issues found when processing Payables Invoices (and can be applied to Receivables transactions as well). EBTax issues are very common causes of Invoice Actions (validation, cancel, discard, matching) failing. You can use this tool proactively to screen and correct data problems in EBTax or reactively when having problems performing an Invoice or Transaction action. This analyzer can be used through the month to complement the MGD.

R12: Payables Trial Balance Analyzer - Diagnostic to Validate Data for APTB issues 

The month ends and you need to reconcile. The APTBH’s mission is to help you detect issues that may yield incorrect or inaccurate APTB results. This analyzer will help you identify most (and likely all) transactions that are causing APTB reconciliation issues and provide you the action needed to resolve the problem. The APTBH will also keep you updated on the last patches needed for APTB to work at its best.

R12: Oracle Payments (IBY) Funds Disbursement Analyzer 

Failures in payment processing requests can result in unconfirmed payments which can have an adverse impact on your Period Close. Oracle Payments Funds Disbursement Analyzer minimizes disruptions to your payment process by proactively identifying and addressing any environment (patching) and setup related issues. The Analyzer contains proactive scans to identify stuck payment process requests (PPR's), payments related data anomalies and proposes a Generic Data Fix (GDF) patch to resolve them. The Analyzer can be used as a troubleshooting assistant to address issues related to PPR invoice selection, remittance advice delivery and BI Publisher integration with Oracle Payments .

R12: Internet Expenses Setup Helper - Diagnostic to Validate OIE Setup Data:

This diagnostic will allow you to identify many (possibly all) of the transactions which may cause Internet OIE setup issues with the corrective action suggested to resolve them without requiring you to log a Service Request with support.

R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax :

The MGD will scan a date range of AP, Payments, Suppliers and eBTax transactions (proactive use) or a single transaction for known data integrity issues. If data integrity problems are found it will recommend the exact GDF needed to fix the data without further confirmation from Support or Development (use of GDFs without confirmation is fully supported). The tool will also provide additional recommendations such as crucial patches and specify which Application flows might be affected by the issues found. Use the tool in date range mode through the month and stay ahead of last.

Order Management Analyzers:

R12: Order Management (ONT) Sales Order Analyzer Diagnostic Script :

This 'Health Check' script can be used at any time to review the data relating to Sales Orders, including : Sales Order Headers and Lines Workflow Issues Drop / Ship Orders Models and Kits Sets Shipping / Delivery Data. Each script used by this report looks for specific symptoms which have been known to cause problems in the past. It can either be run manually in SQL *Plus, or as a concurrent request. The script may be run safely at any time as no data is created, updated, or deleted.

R12: Shipping Execution (WSH) Analyzer Diagnostic Script :

This Self-Service Health-Check script can be used at any time to review the data relating to Shipping including : Trips, Trips Stops, Deliveries and Assignments, Delivery Details and Freight Setup . Each script used by this report looks for specific symptoms which have been known to cause problems in the past. It also lists Open Inventory Periods and WMS / OPM Enabled Warehouses. The script may be run safely at any time as no data is created, updated, or deleted.

Procurement Analyzers:

R12: PO Approval Analyzer Diagnostic Script

The PO Approval Analyzer is a script that you can use proactively to prevent known issues in Purchasing as well as to collect data to troubleshoot approval problems with a single document or group of documents.

R12: IP Item Analyzer Diagnostic Script 

The IP Item Analyzer is a script that you can use proactively to prevent known issues in iProcurement as well as to collect data to troubleshoot items not found in iProcurement search with a single document or group of documents.

R12: EBS Procurement Encumbrance Accounting Analyzer

The Procurement Encumbrance Accounting Analyzer checks for known funds related errors and provides solutions. It is commonly used to diagnose incorrect encumbrance values found for a Purchasing document.

R12: EBS Procurement Accrual Reconciliation Analyzer 

The Procurement Accrual Reconciliation Aanlyzer is a script that can be used when encountering accruals issues on Purchasing documents. The single document check prints all the information needed to troubleshoot the problem with the accrual reconciliation process.

Reference : Oracle Support Note# 1545562.1

Globalization Profile Options

if you are setting up country-specific globalization and you use custom responsibilities, then you may need to know about the profile options you would set up for a non-multi-org product such as Fixed Assets.  For each custom responsibility that uses windows with country-specific or regional features that belongs to a non-multi-org product. you must set the JG: Application, JG: Territory, and JG: Product profile options.
 Note:  You do not need to set these profile options for multi-org products such as Payable and Receivables, which make use of the organization field.
These globalization profile options are:

• JG: Application:

Used to determine which Oracle Applications product the responsibility is associated with.  The list of values for this profile option consists of a complete list of Oracle Applications products.

• JG: Territory:

Used to determine which country the responsibility is associated with.  The list of values for this profile option consists of a list of countries.

• JG: Product:

Used to determine which Global Financials product the responsibility is associated with.  The list of values for this profile option consists of a list of Global Financials products.

You will find additional information about globalization setups in the Oracle® Financials Country-Specific Installation Supplement.