My Oracle Support Banner

VAT Invoice Number are getting skipped (Doc ID 2111196.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India AP Localizations

ACTUAL BEHAVIOR
---------------
When India-VAT Invoice Number generation concurrent ran into error ,
for such transactions VAT Invoice is skipped. This is observed for cases despite having Incompatibility setup for this concurrent with itself.


ERROR MESSAGE
-------------------
Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process ORA-00060: deadlock detected while waiting for resource

EXPECTED BEHAVIOR
-----------------------
Even if India-VAT Invoice number generation concurrent is running into error ,
the VAT Sequence shouldn't be skipped.

STEPS
-----------------------
This issue is not reproducible but observed sporadically for transaction flow containing below steps:
1. Create Sales Order with VAT taxes
2. Pick release and ship confirm the order
3. Run the India VAT invoice generation
4. For cases where India-VAT Invoice generation concurrent is failing with deadlock
   deduction , VAT invoice number is skipped.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
due to this issue, as VAT being a statutory document sequence / number
skipping causes statutory impact for reporting to the taxation authorities.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.