GST: On applying Adhoc Taxes on Sales order getting Error: FRM-40654: Record has been updated. Re-query block to see change.

(Doc ID 2324153.1)

Last updated on NOVEMBER 02, 2017

Applies to:

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

Symptoms

Reported Issue
----------------
On applying "ADHOC" based taxes over Sales order transactions and on Saving , system is throwing an error.
So , taxes , Tax Categories are NOT getting applied .

Error message
----------------
Error: FRM-40654: Record has been updated. Re-query block to see change.

Expected Behavior
---------------------
All Taxes are to be allowed for application over transactions without any errors.

Steps for Replication
-----------------------
1.Pick a ADHOC tax type assigned to a tax category.
2.On trying to apply tax category created in step 1 , system throws an message
   Error: FRM-40654: Record has been updated. Re-query block to see change.

Business Criticality
--------------------
Due to this issue relevant taxes cannot be applied on orders resulting in shipment of goods without taxes
which leads to compliance issues.

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