Wednesday Oct 29, 2014

Webcast: Inventory Period Close - Stuck Transactions

Webcast_icon.jpgWebcast: Inventory Period Close - Stuck Transactions

Date: November 5th, 2014 at 1:00 pm ET, 12:00 pm CT, 11:00 am MT, 10:00 am PT, 6:00 pm, GMT Summer Time (London, GMT+01:00)

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

Details & Registration: Doc ID 1290983.1

Monday Mar 24, 2014

Get Help to Verify Your General Ledger Balances Anytime!

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:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?

Wednesday Mar 12, 2014

Meet the Payables Period Close Analyzer!

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):


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

R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] DocID 1360390.1

Best Practices for E-Business Suite Payables Period Close (one hour webcast)

The "Period Close Analyzer" thread on the Payables Community

Thursday Feb 14, 2013

Reasons why I Run Create Accounting on a Daily Basis

Implementation of accounting best practices can significantly reduce your company’s workload while improving accuracy and ensuring data quality.  The Create Accounting program processes eligible accounting events to create subledger journal entries. 

The Create Accounting program:

  1. Validates and creates subledger journal entries
  2. Transfers the final journal entries in the current batch run to General Ledger and starts the General Ledger posting process
  3. 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!

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.

Stay Connected



« July 2016