R12: AP: Create Supplier Contact API Does Not Return "Duplicate Contact" Error. (Doc ID 3042959.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

Create Supplier Contact API (AP_VENDOR_PUB_PKG.Create_Vendor_Contact())does not return "Duplicate Contact" error.

Steps to reproduce
=======================================================
Run a PL/SQL block similar to the following. First name, Last name, Area Code, Phone and Email Address already exist for a contact assigned to the supplier

DBMS OUTPUT shows ...

And so it begins ...
return status E
l_msg_count 0
And now it ends ...

This means that there was an error in the call to Create_Vendor_Contact, but there are no messages in the error stack

Cause

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