Incorrect Sales Reps In Customer Site's Business Purposes (Doc ID 2089162.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

On :  12.2.4 version, Customers Module

You have a problem selecting the correct Sales Rep in Business Purposes.
For example, the Business Purpose's ORG_ID equals 85.
Once you begin typing the last name of the Sales Rep in the "Salesperson" field, the drop down list shows up, and you select a Sales Rep from it.
However, that Sales Rep shown in the drop down list has the ORG_ID that equals 84.
The SITE_USE_ID equals 85, while the SALESREP_ID attached to this site use has a different ORG_ID that equals 84.

If you just paste full name of a Sales Rep into "Salesperson" field, and click "Apply," it also allows you to save and corrupt data in the database.

If you don't use the drop down list, and use search window instead, it works fine.
The search window doesn't show the Sales Reps that have different from selected site use ORG_IDs.
It is expected the same when using drop down list.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Customers > Customers > Account > Site > Business Purposes > Salesreps

Due to this issue, the wrong Salesreps have entered in the customers HZ_CUST_SITE_USES_ALL table.

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