Webcast: Inventory Period Close - Stuck Transactions

This one-hour session is recommended for technical and functional Users who want to learn more about the standard datafixes available for the Inventory Module. The Standard Datafix Note 568012.1 outlines over 2 dozen data issues and their solutions. Newly created content includes the datafix directly downloadable from Note for more rapid resolution. The new datafix notes include an identify script, root-cause patches check, backup script and datafix.

Topics will include:

Overview of Common Datafixes in Inventory

Most Common Data Issues

Applying Common Data Fixes

Avoiding the Issue in the Future with Root Cause Patches

A short live demonstration will walk thru an example data issue and fix

Monday Mar 24, 2014

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes.

Maintaining correct balances is crucial for reporting purposes

Financial users may want to verify balances periodically to make sure they are accurate

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Wednesday Mar 12, 2014

See Doc ID 1489381.1 in My Oracle Support to learn all about our latest analyzer script "ap_pclose_detect_pkg.sql". This script was created just for EBS: Payables, and is designed to find transactions that may be blocking the period close process from closing normally, and offers corrective actions you can take to resolve the problems yourself -- eliminating the need to contact Oracle Support for help!

Below is an example of the HTML output produced by the Payables Period Close Analyzer (PCA):

RESOURCES

To learn more about Global Data Fixes (GDFs) and what GDFs are available for Oracle Payables, along with information about the Period Close process in Oracle Payables, and access to other Payables PCA users, see the following:

R12: What is a Generic Datafix Patch (GDF) and what GDFs are available for Payables? [VIDEO] DocID 874903.1

Transfers the final journal entries in the current batch run to General Ledger and starts the General Ledger posting process

Generates the Subledger Accounting Program Report, which documents the results of the Create Accounting program

In Receivables we recommend that you run Create Accounting daily! Here’s why..............!

The Create Accounting concurrent program is run with the 'as-of' GL_DATE so running daily will allow all invalid items to be caught early and resolved before the period needs to be closed. This prevents the panic at Period Close, when you find out there is just one invalid transaction preventing the entire period from being successfully closed.

For example, for Dec-1-2012 you may have an orphan credit memo event which shows in the Subledger Period Close Exception Report. When you try to close the period on Dec-31-2012, this corrupted credit memo will prevent period close. If you had run the Create Accounting process more frequently, this invalid data would have been identified and you could have found the resolution prior to the Period Close.

Running the Create Accounting concurrent program daily will allow for quicker processing. Having the program process 100 transactions per day is a lot easier then having it process 3000 transactions on the final day of the month, especially with the performance impact of all the additional Period Close reporting and processing that has to be completed. Another option is having each user run online create accounting as soon as the transaction is completed.

Yet another benefit of running Create Accounting more frequently, is the ability to reconcile your AR and GL data in smaller and more targeted tranches of data. This is yet another Period Close process that can be started earlier in the period, in order to decrease the pressure on yourselves at the end of the period.

So you can see, running Create Accounting on a daily basis can really help you balance out your workload!

About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.