1. Navigation: System Administrator -> Responsibility -> Define
2. Query for the Responsibility Name to which we want to restrict the button
3. Under the Menu Exclusions tab include the Menu ‘Project Status Function Security Menu’
This will grey out the 'Change Status' button and the user will not be able to update the status.
Saturday, July 17, 2010
Form error while trying to update Projects 'FRM-40654: Record has been updated. Requery block to see change'
While trying to update a Project we were getting the following error:
'FRM-40654: Record has been updated. Requery block to see change'
On investigation we found that the issue is due to trailing or leading spaces in attribute columns for the project. Oracle has provided a fix for this:
Refer to the Metalink DOC ID 362800.1
Run this script with the 'Automatically Fix all the errors Found' parameter as 'N' initially to determine the columns with the trailing or leading spaces. Once you analyze the data and everything looks good then we can run the script again with 'Automatically Fix all the errors Found' parameter as 'Y'.
'FRM-40654: Record has been updated. Requery block to see change'
On investigation we found that the issue is due to trailing or leading spaces in attribute columns for the project. Oracle has provided a fix for this:
Refer to the Metalink DOC ID 362800.1
Run this script with the 'Automatically Fix all the errors Found' parameter as 'N' initially to determine the columns with the trailing or leading spaces. Once you analyze the data and everything looks good then we can run the script again with 'Automatically Fix all the errors Found' parameter as 'Y'.
Subscribe to:
Posts (Atom)