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

Last updated on MARCH 15, 2022

Applies to:

Symptoms

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.