+19On a custom LU, I’d like to create a read-only reference field to expose MY_CLT.ROWVERSION in the client presentation. Expressions or SQL statements against t.rowversion or v.objversion don’t appear to work. Is there a way to show this field to the users, short of creating another persistent field?
(My preference would be a solution that exposes the field without intermediate functions so the database can honor an index on it.)
Best answer by paul harland
hi Kevin,
the following works fine in Apps 10. I’m guessing you’ve tried this, in which case it must be a difference Apps 9 vs. 10… (?)
+24hi Kevin,
the following works fine in Apps 10. I’m guessing you’ve tried this, in which case it must be a difference Apps 9 vs. 10… (?)
+19This is what I ended up using:
TO_DATE(v.objversion, 'YYYYMMDDHH24MISS')
The GET_ function in the _CLP package means there’s no way to enable indexing. 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.