My Oracle Support Banner

R12: Recommendation On Histograms On Columns VENDOR_ID, INVOICE_NUM , ORG_ID , EARLIEST_SETTLEMENT_DATE , INVOICE_DATE Of Table AP_INVOICES_ALL (Doc ID 2695336.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

While working on optimizing a query based on table AP_INVOICES_ALL, customer noticed that capturing histograms on certain columns of the table, gives an optimized plan for SQL.  By default, only three columns are present in FND_HISTOGRAM_COLS for histogram collection.
Since creating histogram for few more columns helping to improve performance of the query:

  1. Is there any recommendation from the product team on what all columns of table AP_INVOICES_ALL we should collect histograms?

  2. Are there any know issues If we collect histogram on the following columns of table AP_INVOICES_ALL?
    EARLIEST_SETTLEMENT_DATE
    INVOICE_DATE
    INVOICE_NUM
    ORG_ID
    VENDOR_ID

  3. How to purge entries from FND_HISTOGRAM_COLS in case it is needed to rollback the new columns histogram collections?
     

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 QUESTION #1:  Is there any recommendation from the product team on what all columns of table AP_INVOICES_ALL we should collect histograms?
 QUESTION #2:  Are there any know issues If histogram are collected on columns  EARLIEST_SETTLEMENT_DATE, INVOICE_DATE , INVOICE_NUM , ORG_ID , VENDOR_ID of table AP_INVOICES_ALL?
 QUESTION #3:  How do I purge entries from FND_HISTOGRAM_COLS in case I need to rollback this change?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.