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 FEBRUARY 03, 2019

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.

Symptoms

On : 12.1.3 version, Assign Resource Subinventories

ACTUAL BEHAVIOR
---------------
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 -< company name>

EXPECTED BEHAVIOR
-----------------------
Expecting the First and Last name to be as specified in Supplier Payable.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payable Responsibility > Supplier
Create a new contact under Supplier <company name>
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 - <company name>
Last Name is LastName, FirstName - <company name>

Changes

 Upgrade from 11.5.10.2 to release 12

Cause

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
Symptoms
Changes
Cause
Solution
References


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