R12: Several Values for Supplier Business Classification Not Available in the Payables Supplier Interface (Doc ID 471207.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Symptoms

The supplier interface (APXSUIMP.rdf) does not have options to setup a supplier with some of the Business Classification information available from the Suppliers Entry form.

From the Oracle Documentation on the Supplier interface:
Oracle® Payables, Reference Guide Release 12, Part No. B25455-02.
Appendix A: Payables Open Interface Tables, Understanding the Suppliers Open
Interface Tables:

AP_SUPPLIERS_INT (Page A-73)

MINORITY_GROUP_LOOKUP_CODE
If the supplier is a minority-owned business, enter the minority group in this column.
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'MINORITY GROUP'
Destination: PO_VENDORS.MINORITY_GROUP_LOOKUP_CODE

WOMEN_OWNED_FLAG
Indicates if the supplier is a woman-owned business. This value defaults to 'N'.
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.WOMEN_OWNED_FLAG

SMALL_BUSINESS_FLAG
Indicates if the supplier is a small business. This value defaults to 'N'.
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.SMALL_BUSINESS_FLAG

Those are the fields that exist.

- Service-disabled Veteran Owned
- Hub Zone
- Veteran Owned

Are not part of the interface, therefore any supplier that need these options will have to be updated manually via the Suppliers Entry form.

The Supplier Interface should provide an option to set these Business Classifications.

Cause

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