Skip to main content

On 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.)

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… (?)

 

 

This 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. 😞

 

 

Reply


Terms & ConditionsCookie settings