Last updated on AUGUST 31, 2017
Applies to:Siebel System Software - Version 126.96.36.199  to 188.8.131.52  [Release V8]
Siebel CRM - Version 184.108.40.206 SIA  to 220.127.116.11 SIA  [Release V8]
Information in this document applies to any platform.
This behavior occurs in 18.104.22.168/22.214.171.124 versions.
The ddlsync is not creating indexes in correct order. All the DESC indexes are getting created with ASC order even after using /9 option.
Steps to Reproduce
The issue can be reproduced as follows:
1. In Siebel Tools 126.96.36.199 create an index. Then add to this index a column and set up sort order as DESC.
2. Go to dbsrvr/oracle and open file driver_ddlsync.ucf. For each ddlimp command, add the option /9 Y at the end of the command; save the file.
3 Then run the DB config wizard > DB utilities > apply schema changes to synchronize logical and physical schemas.
4. Notice that the index created does not contain the column in DESC order, but ASC.
Due to this issue, the logical and physical schemas are out of sync and all the indexes are created in ASC order. In addition, there may be related performance issues in the application.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms