R12: Several Values for Supplier Business Classification Not Available in the Payables Supplier Interface

(Doc ID 471207.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
REPORT:APXSUIMP.RDF - Supplier Open Interface Import


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms