Customer with an Inactive Bill To Purpose Should Be Checked for Duplicate Bill To Before Allowing Second Identical Bill to Purpose to Be Created (Doc ID 1679221.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

Upon creation of business purposes, it is not possible to create a duplicate Bill To purpose, if there is already an active Bill To purpose.

If there is an Inactive Bill To purpose, the system allows you to create a duplicate.

This causes issues in Order Management (for example the contact will be duplicated with two locations) and issues in Receivables, where the user cannot search the customer upon creation of a Transaction using the Bill To Customer number.

The control that is done when there is an active purpose (Error being: Value for cust_acct_site_id - site_use_code must be unique) should also be done when there is an inactive purpose, so that a user can reactivate it, instead of creating a new one.

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