Hi Don,
There is a problem on how ETP makes use of CR. Basically ETP makes use of tree_sortkey to know the ordering the the content items in a content folder. ETP needs a column to determine the sort order of the item in a folder. You can use rownum to emulate this but its not really good since you can't update rownum. (I think... not really familiar with rownum).
But since ETP was original ported by Jon and you so there must be a way that I am not aware of.
The way I see it is to add another column in cr_items or create a table in ETP that holds mapping for the sort order. Although I think there must be a better solution to the problem since I am not really an Oracle guru.
Please give me some ideas and if its easy to put in I will try to put it in. Otherwise I hope a more capable Oracle guy to help out.
