Service Tax Repository Showing Duplicate Records & Service Tax Processing Showing Error "ORA-00001: unique constraint (JA.JAI_RGM_TRX_RECORDS_UK1) violated" (Doc ID 1542232.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Service Tax - P2P

ACTUAL BEHAVIOR
---------------
Service Tax Repository is updated twice in some case of invoice. Also service tax processor showing following error:-
"ORA-00001: unique constraint (JA.JAI_RGM_TRX_RECORDS_UK1) violated"

EXPECTED BEHAVIOR
-----------------------
Expects that service tax repository should correctly updated and the concurrent should complete normal

STEPS
-----------------------
The issue can not be reproduced at will

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have correct service tax reporting

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