My Oracle Support Banner

Israeli Vat AP Detailed Report Displaying No Data (Doc ID 1575985.1)

Last updated on AUGUST 13, 2021

Applies to:

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


 Israeli VAT AP Detail Register Report shows no data for JUL-2013

Expect to see data in the report.

In the Tax debug log file found following error:

ar.plsql.SET_WHO_INFORMATION EXCEPTION raised in POPULATE_JE_AP: -1427:ORA-01427: single-row subquery returns more than one row

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Israeli localization
2. Path: Other -> Requests -> Run
3. Run the EMEA VAT: Selection Process

Reporting Level: Ledger
Ledger: Tortech ILS
Balancing Segment: 12
Period Name: JUL-13
Source: ALL
Accounting Status: Accounted
Debug Flag: Yes

NOTE: In the log the concurrent does pick 235 invoices.

After running the emea vat selection process – the table jg_zz_vat_trx_detailed is not displaying data
in the field "repoting_code" – this field is the lookup code for each tax rate.

4. Run the Israeli VAT AP Detail Register Report

Reporting Identifier: LEDGER
Ledger: Tortech ILS
Tax Calendar Period: JUL-13

This report shows NO DATA.
The problem occurs only for AP transactions.
There is no workaround.


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

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