R12: AP: Alternate Supplier Name Is Not Getting Updated Through API. (Doc ID 2993746.1)

Last updated on DECEMBER 20, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Alternate Supplier Name is not getting updated.

When trying to update Alternate Supplier Name from backend. Although the value is null in AP_SUPPLIERS table, still see some value is displayed in front end.

EXPECTED BEHAVIOR
-----------------------
The VENDOR_NAME_ALT should pick the value from AP_SUPPLIERS when updating through API and same should be displayed in Supplier forms/details.

STEPS
-----------------------
1. Create a PL/SQL script that calls the Payablas Vendors Public API AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC to update the VENDOR_NAME_ALT. 
2. Run the script via SQL*PLUS.
3. Session completed successfully and yet the value is null in AP_SUPPLIERS table for column VENDOR_NAME_ALT.

Cause

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