Hi Oracle Guru,
This is the first time I'll post so be kind if I did not follow rules on posting,
Can Anyone help. I have updated mtl_system_items_b table to correct data, but the consequence is we are getting this error.
“FRM-40654: Record has been updated. Requery block to see change” each time we click the item on application resulting us unable to proceed on any action we must on application in inventory module.
I will really appreciate any kind of help. Thanks in advance.
Pl post details of OS, database and EBS versions. How did you update the table ? Directly updating base tables using SQL is not supported - hopefully you used an API. This error is typically caused when there are leading/trailing spaces in the data. Check by comparing the LENGTH function of the column with the LENGTH function of the column after LTRIM and RTRIM
You can also see this threads: FRM-40654 Frustration
(On the block, set the property value of "DML Returning Value" to "Yes")
--(Check if you have any custom database triggers on MTL_SYSTEM_ITEMS_B)--
Edited by: stefan nebesnak on Feb 2, 2013 6:14 AM
here are our db apps versions
RDBMS : 220.127.116.11.0
Oracle Applications : 12.1.3
Seems we are in trouble because our developer directly update it without using api. :(
is there still a way to fix this? he told us there were only 8 records he updated.
Pl post the update statement used. Have you checked the LENGTH of the columns for those 8 updated rows ?
See the troubleshooting steps in these MOS Docs (assuming leading/trailing spaces is the issue)
How To Troubleshoot FRM-40654 Errors On Purchasing Documents? [ID 1203796.1]
How to Find and Fix FRM-40654 errors in MTL_CATEGORIES_B? [ID 1243085.1]
One way to recover would be to restore the database from a previous good backup
Thank you all for the continuous reply,
Please see query the was used. Thanks
update mtl_system_items_b set
SECONDARY_DEFAULT_IND = 'D'
TRACKING_QUANTITY_IND = 'PS',
DUAL_UOM_DEVIATION_LOW = 100,
DUAL_UOM_DEVIATION_HIGH = 100,
SECONDARY_UOM_CODE = 'PCS',
where segment1 = 'K5000078'
Ouch - I would recommend you open an SR with Oracle.
Maybe an FRD trace may help
R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications [ID 438652.1]
Steps To Take FRD Trace in 11.5.10 & R12 [ID 867943.1]
How To Collect And Use Forms Trace (FRD) in Oracle Applications Release 12 [ID 373548.1]