Getting FRM-40654 Error While Updating The Requisitions (Doc ID 1634792.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to update Incomplete Requisitions, the following error occurs.

FRM-40654: Record has been updated. Requery block to see changes


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using a Purchasing responsibility, create a new requisition, save it without approving it
2. Query the above Requisition in Requisition Summary form and open it
3. Attempt to update the requisition-> error occurs

Trace will show

 SELECT * FROM PO_REQUISITION_HEADERS WHERE ROWID = :B1 FOR UPDATE OF
  REQUISITION_HEADER_ID NOWAIT

 SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY,
  SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 =
  M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME
  AND M.APPLICATION_ID = A.APPLICATION_ID
  END OF STMT
  BINDS #47995608708992:
  Bind#0
  oacdty=01 mxl=32(19) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1206001 frm=01 csi=560 siz=192 off=0
  kxsbbbfp=2ba6d9d9ff40  bln=32  avl=19  flg=05
  value="FORM_RECORD_CHANGED"


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