My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

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: XXXXX 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.