My Oracle Support Banner

Pre-Upgrade Steps for Migration from 11i Consulting VAT reporting solution to R12 VAT reporting solution for Israel (Doc ID 1088633.1)

Last updated on JUNE 22, 2022

Applies to:

Oracle Financials for EMEA - Version 11.5 to 12 [Release 11.5 to 12]
Information in this document applies to any platform.
REPORT:JEILAPVR:Israeli VAT AP Detailed Report
REPORT:JEILR835:Israeli VAT File Related To 835
REPORT:JEILSVAT:Israeli Summary VAT to Tax Authorities
REPORT:JEILN835:Israeli VAT File Non Related to 835


This document provides the steps to resolve the R12 migration issues for customers using 11i Israeli VAT reporting solution provided by Israeli Consulting.

This is applicable to the customers planning to upgrade to R12.
It is not applicable to the users who have already migrated their environments from 11i to R12 or the new implementations.

The below solution is to fix the following issues with upgraded transactions:

1. Unreported transactions from R11i are not available for reporting in R12;

2. VAT reports are not showing invoice cancellation information properly, when the invoice is created and reported in 11i and is cancelled in R12.
a. E.g., invoice “123” was created and reported 11i. If the invoice “123” is cancelled in R12, only the cancellation information should be included in the report. Currently the Israeli VAT reports in R12 are not including these invoices in the VAT reports.

The solution consists of both pre and post-upgrade steps. This note only covers the Pre-Upgrade steps.

Troubleshooting Steps

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
Troubleshooting Steps
 Pre-upgrade steps
 Post-Upgrade steps

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