Customers Workbench: Error 'Tax Registration Number is already in use for party type: Third Party, Party Name: XXX' when creating customer with same tax registration number as suppliers

(Doc ID 1320761.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

In R12.1.1, there are companies that are set up as both Suppliers and Customers as they do business as both.  If the VAT Number is already assigned to the Supplier record, users can not add their VAT Number to their Customer record as they get this error:

Error
Tax Registration Number is already in use for party type: Third Party, Party Name: XXX, and party site name: YYY, for the same period.

The issue remains after applying <Patch 10402027>:R12.ZX.B

Steps to reproduce:

(1) Create Supplier record including VAT Number
(2) Create Customer record and enter same VAT Number.
(3) Receive Error on Customer Master since VAT Number was already used on the Supplier record.

Changes

 

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