R12: AP: Supplier Site Import Not Populating Data In Hz_party_sites Table For Employee Suppliers. (Doc ID 1296910.1)

Last updated on DECEMBER 03, 2019

Applies to:

Goal

The Supplier Site Import populates data in all the tables except HZ_PARTY_SITES table for the Employee Supplier when the vendor_type is 'EMPLOYEE'.
It populates data in HZ_PARTY_SITES for all other vendor_types except 'EMPLOYEE'.

When an Employee Type Supplier is created through front end Oracle form or created from the back end using Standard API, there is no entry created in HZ_PARTY_SITES (Data is populated in all other relevant tables) which is a standard functionality in R12.

This only happens for the Employee Type Supplier, for all other supplier data can be found in all Supplier relevant tables including HZ_PARTY_SITES

Solution

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