When trying to add operating unit and tax classification code in tax classification form, the following error appears:
ERROR: This name already exists. Please enter a unique name
STEPS: The issue can be reproduced at will with the following steps: 1. Navigation: Setup > Billing > Event types > button “Tax Classification Code” 2. Enter values in Tax Classification Code window 3. Save. Get the error.
In PA_EVENT_TYPE_OUS_ALL table OUTPUT_TAX_CLASSIFICATION_CODE is NULL.
select * from PA_EVENT_TYPE_OUS_ALL where output_tax_classification_code is null;
Reference Oracle Document Doc ID 2375986.1
Reason: Tax Rate Code may be deleted or not active.
Query
Select * from zx_rates_b where ACTIVE_FLAG = ‘N’