R12.2: Quoting And Search Customer Site By Purpose Returns Sites That Is Not Active

(Doc ID 2208568.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle Quoting - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, HTML User Interface

When searching customer address by purpose from a quote, an inactive address site is displayed.
No contact is selected on the quote.

EXPECTED BEHAVIOR
-----------------------
Expect only the active addresses for the purpose to be displayed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to HTML Quoting UI
2. Open or create a new quote
3. Choose the Shipping and Billing tab
4. Choose the Select button in the Shipping area
5. In the Search and Select: Address (customer name) window , choose the purpose as Sold To and the Go button
6. See two records returned, one of which is inactive
7. If the user selects the inactive address and error would return such as -
  
 1. Bill (Ship) to Address for this customer is in-active.Please choose a different Bill (Ship)-To-Address
 2.The Site given is not a valid site for given bill to customer account/customer account


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users see incorrect addresses causing confusion and errors impacting Sales Orders.

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