R12 : Updating Payment Terms On A Specific Supplier Site Results Incorrectly Updates The All Other Sites (Doc ID 2112728.1)

Last updated on MARCH 03, 2016

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, when a user attempts to update payment terms on a supplier site on a supplier with multiple sites the following occurs:

ERROR
-------
Timestamps (last_update_date, last_updated_by) are updated on all sites for that supplier


BUSINESS IMPACT
----------------------
Due to this issue, timestamps are incorrect on the un-updated sites


STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
1) check the timestamps columns prior to updating the supplier site :

select last_update_date,last_updated_by,terms_id
from apps.ap_supplier_sites_all assa
where vendor_id = <vendor_ID>

2) Navigate to any suppliers with multiple sites and only attempt to update one site changing the Terms field

3) run the SQL from step1 ; you will notice the last_update_date field have changed for all sites


EXPECTED OR ACCEPTABLE RESULT
-----------------------------------------
Update a site without having all sites on that supplier updated

Cause

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