LAST_UPDATE_DATE / LAST_UPDATED_BY Gets Updated Through Receivables Inquiry Responsibility (Doc ID 2122123.1)

Last updated on MARCH 31, 2016

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 

ACTUAL BEHAVIOR
----------------------------
The "Last_Updated_By / Last_Update_Date" gets updated even if any user
navigates to the Business Purpose section (Bill-To/Ship-To) for any customer
account. This happens even through "Receivables Inquiry" responsibility
The following tables get updated
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_CUST_PROFILE_AMTS
HZ_CUSTOMER_PROFILES



EXPECTED BEHAVIOR
----------------------------
The "Last_Updated_By / Last_Update_Date" should not get updated if any
user navigates to the Business Purpose section (Bill-To/Ship-To)

 

STEPS to reproduce issue
-----------------------------------
The issue can be reproduced at will with the following steps:
1.   Enter the Customer (e.g. Account number 1001) and Click Go button
2.   Click Details icon in Accounts section
3.   Click Details icon in Account Sites section
4.   Click Late Charges tab
5.   Select the radio button in "Currency Rates and Conditions" section (in the middle of screen) to show the interest of each currency
6.   Click Business Purposes tab
7.   Click Details icons of Bill To Purpose
8.   System WILL update the LAST_UPDATE_DATE, LAST_UPDATED_BY field in
HZ_CUSTOMER_PROFILES table and LAST_UPDATE_DATE, LAST_UPDATED_BY field in
HZ_CUST_PROFILE_AMTS table (Note: number of records updated depend on how many currency you have selected in Late Charges tab)

 

BUSINESS IMPACT
--------------------------
The issue has the following business impact:
Due to this issue, records have an incorrect posting on last update date/time and user

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