The SF Framework when generating a SQL command to update Oracle takes the column name and append a 4 character "_ORG" to the name to form the parameter. The max length in Oracle is 30 characters. Is there a work around or do we need to shorten the column names in Oracle tables to 26 characters?

Hi Ross.

I don't think the _ORG has anything to do with Oracle specificaly, but with the concurrency type you choose. Have a look at this post:

http://forum.strataframe.net/FindPost16677.aspx

Ivan is right on the money.  If you use a Row Version or a TimeStamp column for concurrency, then this will not be an issue.  Also, you are FAR better off using row versions (or timestamp columns) than the all fields optimistic concurrency.  It will be significantly faster and actually make what you are trying to do less complicated.