FRM:40654 Error Occurs While Creating a Purchase Order if there is a Custom Trigger which updates the ORDHEAD table.
Last updated on JUNE 18, 2018
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:
- Login RMS Application.
- Go to ordering => orders => create new order.
- Fill the required details in PO Header Screen.
- From Options select Custom Flex Attributes. Enter the required details and exit.
- When the control returns to PO Header Screen, the above error occurs.
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