My Oracle Support Banner

FRM-40654 - Pending Asset Numbers Error (Doc ID 1555842.1)

Last updated on APRIL 12, 2019

Applies to:

Oracle Enterprise Asset Management - Version and later
Information in this document applies to any platform.


On : version, Asset Definition


When attempting to use the Pending Assets Form to modify the pending rows in the MTL_EAM_ASSET_NUM_INTERFACE_V,
the following error occurs.

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

The issue can be reproduced at will with the following steps:

1. Insert rows in the mtl_eam_attr_val_interface and mtl_eam_asset_num_interface tables.
The user inserted asset numbers that already existed.

2. Run Import Asset Number concurrent request and wait for it to complete successfully.

3. Some rows error. The error is : "Asset already exists. Please provide a unique combination of Asset Group and Asset Number. "

4. Now go to Pending Assets Form d try to change the asset number to a new one or try to change some other detail for the errored records. Get the error:

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

5. Cannot update errored row via the forms.

6. There are no trailing spaces - this has already been checked.


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.