Can't Update the Supplier Site Which Doesn't Have Any Contact via API (Doc ID 2988629.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Symptoms

On : 12.2.7 version, Requisition Creation

During requisition creation,the supplier contact(PO_REQUISITION_LINES_ALL.vendor_contact_id) is set automatically
if there is only one contact defined on supplier site.

Ref)How Supplier Contact Is Set on Standard Porchase Order Import (Doc ID 2716551.1)

While trying to update the supplier and supplier site of existing requisition which has PO_REQUISITION_LINES_ALL.vendor_contact_id
via API(PO_REQUISITION_UPDATE_PUB.update_requisition), if the new Supplier and Supplier site which doesn't have any supplier contact,
this API update was failed with the below error message.

ERROR
-----------------------
Requisition Lines in Error: 1 The suggested vendor contact is not a valid contact.

Cause: You entered an invalid vendor contact.

Action: Enter a valid vendor contact.
-----------------------

When they update the original PO_REQUISITION_LINES_ALL.vendor_contact_id to NULL directly (UPDATE PO_REQUISITION_LINES_ALL set vendor_contact_id = NULL)
and tried to update via API again,there was no error and success to update the supplier and supplier site.
So this error only occur when,
1. The original PO_REQUISITION_LINES_ALL.vendor_contact_id is not NULL
2. The new supplier site doesn't have any supplier contact

We can update the supplier and supplier site which doesn't have any supplier contact via API.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create requisition with vendor_contact_id value.
2. Try to update the supplier site which have no supplier contact setup via API.
Failed with error.

Cause

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