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.

Symptoms

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
 "ITEM";"VAT_REGION";"ACTIVE_DATE";"VAT_TYPE";"VAT_CODE";"VAT_RATE";"REVERSE_VAT_IND"
"1000056695";"1000";"17/04/2020";"B";"M";"10,0000000000";"N"
"1000056695";"1000";"17/04/2020";"C";"E";"0,0000000000";"N"

Cause

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
Symptoms
Cause
Solution
References


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