My Oracle Support Banner

Vatdlxpl Process Failing With ORA-30926 Error For Multiple Vat_item (Doc ID 2831691.1)

Last updated on JANUARY 10, 2022

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


The process Vatdlxpl failed with the following error:

After analysing the error it was because of the merge done in the cursor c_merge_iscl that has more than one line that match the "ON" condition.

The data of vat_item that was creating the problem was


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.