A couple of people have asked me recently about the inactive “Edit Web Layout” menu item in Siebel Tools. Well, that functionality is gone – web templates are no longer stored locally in files, but in the database, and so the ability to access this function in Siebel Tools has simply been deactivated. However, all is not lost – “Edit Web Layout” is still available, but you’ll have to access that function through the new Web Tools.
To make matters even more entertaining, that function is not enabled by default nor is it enabled automatically via any of the Patch Sets currently available (up to 17.6 at the time of writing). However, 17.6 does dump a little gem into your Siebel Server BIN folder for you to stumble across, if you happen to read the entire contents of the “Known Issues” section of the patch release notes. Here’s a quick summary of what you have to do, in a Windows environment, to work around “Bug Id 27113012”:
- Install the latest Patch Set (17.6 is what I’ve been using) to your Siebel Enterprise
- Open a command line and change directory to the Siebel Server installation BIN folder (e.g. <SIEBEL_HOME>\ses\siebsrvr\bin\)
- Execute the batch file named “EditWebLayout.bat”
- After executing the batch file, you will be prompted to enter the following information:
123456Full path of ODBCSQL: <Siebel Server BIN Location>ODBC Data Source: <ODBC DataSource Name>Table Owner Name: <Table Owner User - 'SIEBEL' in most cases>Table Owner Password: <Table Owner Password>TBLO Name: <A cryptic one this. The batch file gives some garbage about ORAPQ100, or some such. I just used the table owner again, 'SIEBEL'>Repository Name: <Repository Name - '"Siebel Repository"' in most cases. Yes, you have to put the quotes around it or the batch file will fail>
- Check the output of the command in the log file, EditWebLayout.log, and you’ll see that a bunch of seed data has been loaded
- Clear the browser cache and re-login to the Web Tools application
- Navigate to your Applet then Applet Web Template
- You’ll see an “Edit” icon in the bottom right (cunningly, the tooltip says “Preview” – great job, Oracle!)
- Click this and you’re back on familiar(ish) ground
Some wee observations:
- Why do Oracle insist on disabling functionality before they fully implement an alternative?
- Why do Oracle still find it so difficult to deliver repository and seed data fixes, outside of horribly written, unintuitive, manually executed batch scripts that I have to hunt in their obscure documentation to find?
Ho hum, I guess this sort of hack-around is what we’ve come to expect and accept from Siebel releases these days.