6
Siebel 2000 Adapter Functionality

This chapter provides an overview of the functionality of the Siebel adapter. The following topics are discussed:

Control Flow Overview

This section contains these topics:

Design Time

When the Siebel 2000 adapter starts up, using the login credentials and system information from iStudio, it creates and pools one or more instances of the Siebel Application object. The Siebel 2000 adapter presents lists of Business Object, Business Components and Business Services in the browser. When you click on one of these, its logical methods display, along with their signatures. You can import these methods in iStudio to create application views.

Runtime

Runtime is the time where the Siebel 2000 adapter is servicing requests or waiting for requests. The distributed application in the Siebel 2000 adapter is up and running. All calls into the Siebel Application are synchronous calls. The data for the calls get transformed into Java values that Siebel receives through the Siebel Java Data Bean.

Siebel Interfaces

The Siebel 2000 adapter allows you to browse and call Siebel Business Services (objects with methods) and Business Components (data sets which you can query and update).

Under the hood, all Siebel applications use Business Components and Business Services, the basic building blocks. Business components are representations of a set of one or more joined tables. They have certain table-like behaviors such as the ability to query a set of records. Business Services are effectively containers for code. Custom business services can be defined using the Siebel Tools, including defining a list of arguments and data types.

Business Services

Business Services are also called "services" in Siebel. The Siebel repository contains Business Service methods and typed method arguments. The Siebel 2000 adapter uses a query interface to find the repository objects for Business Services. All method arguments are passed into the Business Service through a single invocation API. Arguments of all Siebel Simple Business Service types are supported. Custom "methods" (function calls) can be defined using the Siebel Tools, including defining a list of arguments and data types. Either Siebel Basic (much like Visual Basic) or Siebel eScript (similar to jscript or Java) is used to implement these functions.

For Business Components, each record can have fields of the following types:

String--An unbound string (not fixed length).
Number--A numeric string with a total length of 22. This total length includes any plus or minus sign, exponent symbols, decimal symbol, integer or decimal fraction digits.
Date--A date in the format MM/DD/YYYY. For the months of January through September and days from the first through the ninth a single character is acceptable.

Business services that have hierarchy of property set parameters are not currently supported.

Note:

Limitation: Many business service method parameters are not strongly typed in Siebel meaning that when they are created you can choose to type a parameter as a string even though internally it is used as a Number or Date. If such a business service method is found, you can remedy this by changing the parameter type to match how the parameter is actually used. See your Siebel system administer or Siebel Tools expert for more information.

Business Objects and Business Components

Business Components are representations of a set of one or more joined tables. They have certain "table-like" behaviors such as the ability to retrieve a set of records. Business Objects are containers for Business Components.

For Business Components:

Their data types are all complex.
These complex data types are record sets.
These are presented as Java vectors or arrays containing Java objects with the values.

For business components, each record can have fields of the following types:

DTYPE_BOOL--Boolean T/F.
DTYPE_CURRENCY--A numeric string (has no currency symbols, but handles the locale-based decimal symbol, and +/- prefix/suffix.
DTYPE_DATE--A date in the Siebel adapter's Date format.
DTYPE_DATETIME--A datetime in the Siebel adapter's DateTime format.
DTYPE_TIME--A time in the Siebel adapter's Time format.
DTYPE_INTEGER--A 32-bit integer.
DTYPE_NOTE--An unbounded text field.
DTYPE_NUMBER--Similar to DTYPE_CURRENCY but not used as currency in Siebel.
DTYPE_PHONE--A string representing a phone number. It can be of two formats: +<any string>, or US area code and number: XXX-XXX-XXXX.
DTYPE_TEXT (includes length of the string)--Strings of fixed length. The exact length of a DTYPE_TEXT field is visible in the Siebel 2000 adapter browser.

Unformatted DTYPE_PHONE Values

Siebel DTYPE_PHONE is mapped to Oracle Application Server InterConnect Adapter for Siebel 2000 Installation and User's Guide as java.lang.String. The Siebel adapter expects unformatted phone number values for inserts and updates.

A formatted phone number looks like:

(514) 332-6430 x909

An unformatted phone number looks like:

5143326430x909

If you submit a formatted phone number where the format matches the locale for which the Siebel application server has been set, for any business component phone field (of type DTYPE_PHONE), the insert/update will succeed but all subsequent queries to retrieve that record will fail with a seemingly unrelated error message back from Siebel. If you insert multiple records, the first will succeed and the rest will fail.

As a workaround, submit all phone numbers as unformatted.

The following is the exception in the ACB log if formatted phone number values are submitted:

Exception occurred:
Source: Siebel
Error Code: 65538 (0x10002)
Cause: Siebel://exception=SBLException (Unique ID <none)

E-SBL0041: Call to business component Insert failed- Check record at index 1- Siebel error msg- Failed to retrive the new record that was inserted. Contact Siebel Administrator Could not move the record pointer to first record. The insert operation failed at index 1- Siebel error code- 65538- Siebel record index- 1

6 Siebel 2000 Adapter Functionality