Unable to View the Registration Details when a Tax Associated is Defined Under Multiple Operating Units
(Doc ID 1941027.1)
Last updated on JANUARY 06, 2021
Oracle E-Business Tax - Version 12.1.3 and later Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!