Unable To Execute VB Script

 

Error Message

Unable to load the scripting extension language DLL ‘sscfbas’!
Scripting was enabled in this instance of Siebel, but the DLL which is needed to implement it could not be loaded.(SBL-DAT-00228)

 

 

Root Cause

I received this error on executing a Client side script written in Siebel Visual Basic (VB) language on a Unix Server. Unix systems does not support VB Script.

 

 

Background

  • eScript is supported by both Windows and Unix systems.
  • VB Script is only supported by Windows systems.

 

Utility Tool – ColumnArranger v1.0

 

Hello Readers

Today I have got another interesting utility – ColumnArranger. It is used to automatically re-arrange the order of columns in MS Excel to a predefined format.

For example, you receive a report for Accounts-Opportunity in MS Excel.
Provided sequence of columns – OPTY_NUM, ACCOUNT_ID, CITY, POSTAL_CODE, COUNTRY, STATE, STATUS.
Expected sequence – ACCOUNT, COUNTRY, STATE, STATUS, CURRENCY, POSTAL_CODE, OPTY_NUM.

In this scenario, ColumnArranger utility comes handy. Instead of re-arranging columns manually, only specify the column header in desired sequence and run an embedded macro.

 

Origin Of The Tool

During EIM Load, we used to receive data extracts from Data Conversion Team. They designed their own SQL and used to send the data in MS Excel sheet. And in parallel, my team was working on the design of EIM Loads and developed the CTL files with data order not in sync with select part of SQL statements. Therefore, data in received sheets could not be fed to the EIM loads directly.

At this point, I developed ColumnArranger tool. Instead of manually ordering the columns in Excel, I utilized it eliminating the manual efforts.

 

Presentation And User Guide

For additional details and user guide, please refer this document >> ColumnArranger – Presentation

 

Tool Setup

To download this tool, click here >> ColumnArranger – Setup

 

What is Harm, Hazard and Risk?

Harm – Physical injury and/or damage to the health of people or damage to property or the environment.

 

Hazard – A possible source of harm

 

Risk – It is the combination of the probability of occurrence of harm and the severity of that harm. Risk has following three primary components:

  • A hazard
  • Probability of the hazard occurring (likelihood)
  • Potential impact of that hazard (severity).

 

 

 

 

To Start With Siebel BIP Reports

 

Before start working with reports, following are the two pre-requisites:

1.      BI Publisher Desktop Add-In

  •  A report template is edited using Microsoft Word with BI Publisher Desktop add-in.
  • This add-in provides an additional toolbar and menu options to work with reports.

 

  2.      Sample Data File

  • It is a XML file generated in Siebel application using integration object associated with report.
    • Administration – BIP Reports > Sample Data File Generation view.
    • XML is generated at location – <SiebelInstallDir>\XMLP\Data.
  • Data File defines the data elements that would be available at run-time.
  • It also provides sample values for previewing reports.
  • Before start working with reports, it is required to load the data file.

 

 

Oracle SQL – Remove Trailing Zeroes From Phone Columns

 

Requirement

I designed the sql to extract Contacts from Siebel Database (Oracle Database in this case) including phone columns. The challenge that I faced with phone columns:

  • Trailing zeroes (Used by Siebel to capture phone number format)

My extract was not supposed to contain them.

 

Concept

Siebel puts a Newline character between actual phone data and its format.

Also, in my case, Siebel database was installed on a Unix server. In Unix, Newline character is represented by LineFeed (LF) character (\n), Its ASCII code is 10

 

Solution

I put up three in-built SQL library functions to use as follow:

Select
  PC.WORK_PH_NUM “Full WorkPhone#”,
  Case When INSTR(PC.WORK_PH_NUM,CHR(10)) > 0
     Then SUBSTR(PC.WORK_PH_NUM,0,INSTR(PC.WORK_PH_NUM,CHR(10))-1)
     Else PC.WORK_PH_NUM
  End “Updated WorkPhone#”
From Siebel.S_Contact PC;