Unable to View the Registration Details when a Tax Associated is Defined Under Multiple Operating Units (Doc ID 1941027.1)

Last updated on MAY 17, 2017

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There are twenty-seven (27) companies that belong to the same Holding.
These companies are all configured with a Legal Entity, Establishment, Operating Unit and VAT Registration.
All companies have the same Vat Registration Number > Group Vat Registration Number.

You are attempting to enter a Tax Registration, under the Establishment of the Legal Entity, and receive the following error:

This tax registration number is already in use for party type: First Party Legal Establishment and party name: Allseas Welding Services SA for the same period.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT RegistrationEO.PARTY_TAX_PROFILE_ID,
RegistrationEO.REGISTRATION_ID,
RegistrationEO.TAX_REGIME_CODE,
RegistrationEO.TAX,......

TAX_REGIME_CODE = RegistrationEO.TAX_REGIME_CODE
), null) as ALLOW_ROUNDING_OVERRIDE_FLAG,
NVL2(RegistrationEO.TAX, (select distinct
ROUNDING_RULE_CODE
from ZX_MCO_LV_TAXES_V
where
TAX = RegistrationEO.TAX and
TAX_REGIME_CODE = RegistrationEO.TAX_REGIME_CODE
), null) as ROUNDING_RULE_CODE_VALUE
FROM ZX_REGISTRATIONS RegistrationEO,
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
Exception: ORA-01427: single-row subquery returns more than one row

Reviewing the SQL, that is failing, and found that ZX_MCO_LV_TAXES_V is not returning any rows.

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