My Oracle Support Banner

After Upgrade To R12 - AP_Supplier_Contacts Have Null Value In Vendor_Site_Id Field (Doc ID 1459316.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.3 and later
Oracle Common Applications - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2013***


On : 12.1.3 version, Assign Resource Subinventories

Supplier Contacts are being imported in CRM Resource as a Supplier Contact (Resource Category). Once that is completed, the Resource Address/Subinventory is created. Once saved, that address is automatically created as an internal customer in AR. Since there is a null value in the vendor_site_id, the party created from the resource gets created with full resource name in the first and last name fields. As a result, first name appears as in last name in Customer form LastName, FirstName - American Telephone and Telegraph

Expecting the First and Last name to be as specify in Supplier Payable.

The issue can be reproduced at will with the following steps:
1. Payable Responsibility > Supplier
Create a new contact under Supplier American Telephone and Telegraph
The First Name is FirstName
The Last Name is LastName
Then add an address

2. FS Manager Responsibility
FS Setup > CRM Foundation > Resource Manager > Maintain Resources > Import Resource
And create resource for new supplier contact
Resource imported

3. FS Dispatcher > Spares Management > Setup > Addresses and Subinventories
Assign address and subinventory to the supplier contact.

4. Receivable Responsibility,
Query for the customer and I see the
First Name is LastName, FirstName - American Telephone and Telegraph
Last Name is LastName, FirstName - American Telephone and Telegraph


 Upgrade from to release 12


To view full details, 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 a vibrant support community of peers and Oracle experts.