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