Case: On a screen, I am getting SQL error saying "An error has occurred executing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)"
Root Cause: I have generated spool and go that screen. Now, check in spool file and find that some new column (imported by seed data) not found error in sql query. I have checked in Tools and find that this column is available in Table. That means, its not applied in database. So, all i need to Apply/DDL this column to database.
Problem: I was getting permission error while Apply/DDL using DB User/Pass.
Solution: Use SIEBEL as username and user passw as password. see below screen:
Twist: You might get an error if you are setting default value for that column.
Twist solution: You have to generate DDL and use alter query by removing its default value. Later, we can update that column to that default value.
Thats all. Please feel free to have your comments below.