2015 in review

The stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 16,000 times in 2015. If it were a… Read More ›

How to Navigate another view using BusService “Shopping Service”

You can use “GotoView” method of vanila Business service “Shopping Service” to navigate another view. Please find below eScript Code Snnipet/Pseudo Code in which I am navigating to view “Order Entry – Line Items View (Sales)”. var oApplication,sCurrentOrderId,bsGotoView,psInput,psOutput;oApplication = TheApplication();sCurrentOrderId =  oApplication.GetProfileAttr(“CurrentOrderId”);if(sCurrentOrderId… Read More ›

File Count from specific Folder in eScript

function fnFileCount(Inputs, Outputs) { try { var sFileSysObj = COMCreateObject(“Scripting.FileSystemObject”); var sFolder = “E:\\Abc\\Study Material\\Siebel 8.0\\books”; var sDirectory = sFileSysObj.GetFolder(sFolder); var sFiles = sDirectory.Files; var sCountFiles = sFiles.Count; //file count } catch(e) { TheApplication().RaiseErrorText(e.toString()); } finally { sFileSysObj = null;… Read More ›

Finding Encryption Key for User in Siebel

To find Encryption Key in Siebel to connect local database you can use below query providing USER ID. SELECT PREF_CD, VAL FROM SIEBEL.S_NODE_PREF s1, SIEBEL.S_NODE s2 WHERE s1.PREF_CD =’RemLocSec:PlainKey’ AND s1.NODE_ID = s2.ROW_ID AND s2.NAME =’USER ID’