What We Are Announcing

EBS Inventory Support has now released the EBS Inventory Counting Analyzer

Get the analyzer from the following note in My Oracle Support (MOS):

(Doc ID 2820764.1) – EBS Inventory Counting Analyzer

 

Highlights:

This Analyzer is a self-service health-check script that reviews Inventory related data, analyzes current configurations and settings for the environment and provides feedback and recommendations on best practices.

Sample Output screenshot:

 

 

Why Use This?

You can get immediate analysis and output of basic EBS Physical Inventory and Cycle Count data from a particular environment, as the analyzer:

  • Identifies Inventory system setup and configurations
  • Provides recommended actions and best practices
  • Runs as a standalone or Concurrent Request
  • Collects the Required Data of Inventory tables for Counts, Items and Calendar File
  • Collects the apps check file versions of INV and WMS products.
  • Collects data of indexes, profiles, invalid packages, recommended patches to be applied, one off patches that are already applied.

 

Parameters

 Organization Code: (Required) The organization_code for the Organization where the Physical Inventory or Cycle Count is being processed

 Physical Inventory Name: The name of the Physical Inventory(Optional)

 Cycle Count Name: Enter the Name of the Cycle Count (Optional)

 Item: Enter the Item Name / Part Number (Optional)

 Cycle Count Date: Enter Date of Cycle Count to Analyze. Format: DD-MMM-YY (Optional)

 Maximum Rows to Display: Enter Maximum Rows to Display(Do not exceed 500)

 Debug Mode:  Y(Default)

 

Note:  The EBS Inventory Counting Analyzer can either be run as a Concurrent Request or via SQL*Plus. Instructions for both options are listed below.

System Administrators / DBAs may choose to install one or more Analyzers as Concurrent Programs or run individual Analyzers via SQL*Plus directly from the E-Business Suite Support Analyzer Bundle Menu Tool. For details see Doc ID 1939637.1.