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
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]