Supplier Contacts LOV Values Differs From The Requisition Form Compared to The Purchase Order Form.
Last updated on JUNE 29, 2017
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Requisitions
Inactive status supplier Contact value is listed in the Contact LOV in Requisition form.
1. Query the Contact list for one example supplier.
There are two Contacts.
2. Inactivate one Contact.
3. Navigate to Purchasing responsibility: Requisitions> Requisitions form.
4. Enter line details, including Supplier, Supplier Site.
5. Press on Contact LOV. Inactive contact value is still visible in Contact LOV.
Note: This issue is not occurring in Purchase Order form.
In Purchase Order form only active Contact is visible in Contact LOV.
The sql statement to query the Contact LOV:
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 hundreds of Community platforms