Italian Payables Withholding Tax Letter End With Error ORA-01427 (Doc ID 1279524.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for EMEA - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms



On : 12.1.1 version, Italian Localizations for AP

When attempting to run the Italian Withholding Tax Letter,
the following error occurs.

ERROR
-----------------------
Error 50103 (C Engine): ERR ORA-01427: single-row subquery returns more than one row
where inv.set_of_books_id = : CP_SET_OF_BOOKS_ID and inv.legal_entity_id = nvl ( : P_LEGAL_ENTITY_ID , inv.legal_entity_id ) and hzp.party_id = pv.party_id and inv.invoice_id = line.invoice_id and dist.invoice_id = line.invoice_id and dist.distribu
Error 50103 (rwfdt:rwfdtprint): ERR Error occurred sending Job output to cache
Error 50103 (C Engine): ERR REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: single-row subquery returns more than one row
where inv.set_of_books_id = : CP_SET_OF_BOOKS_ID and inv.legal_entity_id = nvl ( : P_LEGAL_ENTITY_ID , inv.legal_entity_id ) and hzp.party_id = pv.party_id and inv.invoice_id = line.invoice_id and dist.invoice_id = line.invoice_id and dist.distribu



The issue can be reproduced at will with the following steps:
1.From AP Italian responsibility
2. Request > Submit
3. Run the Italian Withholding TAX Letter

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