What next ...finding notes on metalink or raise a SR with Oracle,with the assumption they can fix this. Did you ever realized how many hours or days it takes in resolution. Therefore very similar to FirstAid in our daily life during emergency, why not utilize Oracle Diagnostics.

Payables currently has 15 diagnostics as part of Oracle Diagnostic based out of all common issues faced in earlier releases.

About Oracle Diagnostic

Lets recap , based out of one earlier post regarding Oracle Support Diagnostics which designed to improve:

â€¢Resolving configuration and data issues that would cause processes to fail
â€¢Resolving problems without the need to contact Oracle Support
â€¢Reduction in Resolution time by minimizing the time spent to resolve an issue

Typically Oracle Diagnostic consist of

Diagnostic tests : This provided as part of the Oracle Support Diagnostics patch gather and analyze information from your E-Business Suite

Results : This display the information gathered, the findings of the analysis and appropriate actions to take if necessary

Tests : The good is that these do not alter data or setup.

Purpose : These have clear purpose for automation that ensure after successful installation

What are the Oracle Diagnostics Available in AP

Very similar to other products, Payable does have three major Diagnostics

Mass Additions -This test verifies if a given invoice or invoice distribution line meets the conditions to be transferred to Oracle Assets when running Mass Additions Create.

Payment Batch Status -This test will validate a payment batch .

Payment Document -This test will validate the setup for a specific payment document

Period Closing -This test will help in determining if a period can be closed and if not, why it cannot be closed.

Trial Balance -This test will identify and report common problems for invoice(s) appearing or not appearing on the trial balance

With in Data Collection Diagnostics of AP , these key areas are covered:

For Invoice-This diagnostic test will display ALL of the data for ALL of the tables used to process an invoice in Payables.

Open Interface -This test is designed to display all related interface data for a specified invoice interfaced from Oracle source applications or a 3rd-party (legacy) source.

Most important,the reports which appears after running the scripts also have the required patch set information. These diagnostics were created from manual/standalone SQL scripts that Oracle normally providing during data fixing and data collection process against a particular SR. Indeed really good collaborative approach.

Best Practices

To prevent issues always check status of periods in sub ledgers

Clear all the exceptions

Get use of Period end Exception Report - If user want some additional column enhance the reports.

Period Close Exception Report

This report will shows ALL exceptions that would prevent a period from being closed:

Unaccounted Transactions

Untransferred Journal Entries

Unconfirmed Payment Batches

Unmatured Future Dated Payments

You will notice this report got enhanced ( in 11.5.10/Family Pack F). The new improved Payables Accounting Process report covers the error message section. It has also added section to the end of the Payables Accounting Process Report output to show what transactions could not be accounted by the process. And included in that section a comment to see the corresponding transaction number in the log file to see why the accounting could not be created

Therefore.. Lets the end user/core user know how and when to use these tools to address such of problem on daily basis or during closure time and make a better experience with EBS.