My Oracle Support Banner

Transactions Workbench Error: Manually Entered Tax Amount Raises Error: FRM-40654 Record has been updated by another user (Doc ID 352456.1)

Last updated on MAY 08, 2018

Applies to:

Oracle Receivables - Version and later
Information in this document applies to any platform.

FORM:ARXTWMAI.FMB - Transactions


Manually entered Tax amounts cannot be changed in the Transaction Entry screen. When you attempt to change, the following error is raised:
FRM-40654 Record has been updated by another user. Re-query block to see

Steps to reproduce:

  1. Transaction type must have Calculate Tax unflagged as the customer wants to enter all tax information  manually and it should not be calculated through the tax engine.
  2. Any tax code needs to be defined with adhoc flag = Yes
    In this note's testcase, used tax code VAT
  3. Enter invoice with this transaction type and fill in all header information
  4. Click Line button
    Choose any description enter Quantity 1 and
    Leave TAX Code Field blank -- it should not be mandatory
  5. Click Tax Button
  6. Enter any tax rate from the LOV
  7. Enter any amount , for instance 30 as tax amount --> tax rate defaults
  8. Save
  9. Pay Attention here:
    proceed with Changing the tax amount from 30 to 50, then the form raises:
    Message: FRM-40654 Record has been updated by another user. Re-query block to see
  10. Re-query the tax line
  11. This time you are able to change the tax amount and save.


To view full details, 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 a vibrant support community of peers and Oracle experts.