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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms