Last updated on MARCH 02, 2017
Applies to:Siebel System Software - Version 188.8.131.52  to 184.108.40.206  [Release V8]
Siebel CRM - Version 220.127.116.11 SIA  to 18.104.22.168 SIA  [Release V8]
Information in this document applies to any platform.
This behavior occurs in 22.214.171.124/126.96.36.199 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 188.8.131.52 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
Million Knowledge Articles and hundreds of Community platforms