My Oracle Support Banner

FRM:40654 Error Occurs While Creating a Purchase Order if there is a Custom Trigger which updates the ORDHEAD table. (Doc ID 2409877.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 and later
Information in this document applies to any platform.


In RMS 14.1.3, The following error occurs while creating the Purchase Order upon selecting the custom flex attributes and after that when the control is returned to Purchase Order(PO) Header Screen. A custom trigger is called to update the ORDHEAD table.

Error: FRM:40654-Record has been updated by another user. Re-query to see changes.

Steps to reproduce:

  1. Login RMS Application.
  2. Go to ordering => orders => create new order.
  3. Fill the required details in PO Header Screen.
  4. From Options select Custom Flex Attributes. Enter the required details and exit.
  5. When the control returns to PO Header Screen, the above error occurs.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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