Description:
This is because the Sort Specification defined in the Business Component takes effect only for the View Modes defined in the Business Component and not for the other view Modes. However, the Adapter posts the query to Siebel in "All View" mode. For the sort Specification to take effect for all the View Modes including "All View" mode, set the user property "All Mode Sort" of the Business component to "Normal".

To set the user property, go to the Business Component definition in Siebel Tools:
- Expand "Business Component" in the Object Explorer.
- Go to "Business Component User Prop"
- Change the value for "All Mode Sort" to "NORMAL".
- Compile the project and restart the server.
- If you do not find the "Business Component User Prop" in the Object Explorer, go to view -> Options -> Object Explorer, expand "Business Component" and select "Business Component User Prop".

Please note that setting the "All Mode Sort" to "Normal" may have an impact on performance and should be thoroughly tested in a Test environment before rolling to production environment.