Siebel Server , Cannot Expose A Custom Column To An Inbound Web Service

(Doc ID 2188488.1)

Last updated on OCTOBER 12, 2016

Applies to:

Siebel Service Enterprise - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.0 [IP2015] version, Siebel EAI

ACTUAL BEHAVIOR

Siebel Server , cannot expose a custom column to an Inbound Web Service

We have a Siebel server "testserver.us.testing1.com" ,
database is on a different machine, testdb.us.testing1.com, instance TESTING_INST1 DBName/Owner TEST123

We are using Business Service "Service Request" and Integration Object : WC_Service_Request_IO , Integration Component "Service Request" -- and inside we want to have a Custom Field called "IntegrationSite".
This IO is exposed to an Inbound Web Service.

The problem is that, when we create the custom field, expose it to the DB, Apply the DB, compile the objects-- the field does not keep the value inside.

The new field name shows up in the WSDL of the web-service; and, you can create a Service Request *with a value in the field* -- but, when you retrieve the same service request, the value is empty!
 Also--there is no value saved in the corresponding column in the DB.

http://testserver.us.testing1.com/eai_enu/start.swe?SWEExtSource=CustomUI&SWEExtCmd=Execute&WSSOAP=1

We found the INSERT statement in the EAI logs - it has INTEGRATION_ID column in the INSERT statement but it does not have X_INTEGRATION_SITE column in the INSERT statement at all.
Also the following lines exist for “Integration Id”, which works, but do not exist for IntegrationSite:

WebSvcInbound WSInboundTrace 3 0000013a57db0cec:0 2016-09-15 15:36:18 Executing web service operation 'WC_Service_Request_BSInsert' by calling method 'Insert' of business service 'WC_Service_Request_BS'
Executing Operation '&1' by calling method '&2' of business service '&3'

EAISiebAdpt EAISiebAdptTrcIntObj 4 0000013a57db0cec:0 2016-09-15 15:36:18 Integration component: 'Service Request'


EAISiebAdpt EAISiebAdptTrcBusObj 4 0000013a57db0cec:0 2016-09-15 15:36:18 Creating new record in business component 'Service Request'

AISiebAdpt EAISiebAdptTrcIntObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Get integration component field: 'Status', Value: 'Open'

EAISiebAdpt EAISiebAdptTrcIntObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Get integration component field: 'Contact Id', Value: '1-33V6'

EAISiebAdpt EAISiebAdptTrcIntObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Get integration component field: 'Abstract', Value: 'test cont id 1-33V6 inc 78 fake'

EAISiebAdpt EAISiebAdptTrcIntObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Get integration component field: 'Integration Id', Value: '78,160804-000078'

EAISiebAdpt EAISiebAdptTrcBusObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Set business component field: 'Integration Id', Value: '78,160804-000078'

EAISiebAdpt EAISiebAdptTrcBusObj 4 0000013a57db0cec:0 2016-09-15 15:36:20 Get business component field: 'Integration Id', Value: ''



EXPECTED BEHAVIOR

When retrieving the same service request, the "IntegrationSite" value is not empty


STEPS

What has been done most of the same as the following Doc:
Creating inbound web service to allow external application to create SRs in Siebel (Doc ID 486681.1)

- Integration Object : WC_Service_Request_IO(Lock Project "Custom UI Samples")
  Integration Component : Service Request
  Add an Integration Component Field
  Name : Integration Id
  Data Type : DTYPE_TEXT
  Type: Data
  External and XML Sequence: unique (not currently used)
  Length : 30

- Integration Object : WC_Service_Request_IO(Lock Project "Custom UI Samples")
  Integration Component : Service Request
  Add an Integration Component Field
  Name : IntegrationSite
  Data Type : DTYPE_TEXT
  Type: Custom
  External and XML Sequence: unique (not currently used)
  Length : 128

- Table : S_SRV_REQ
  Add Column:
  Name: X_INTEGRATION_SITE
  Text Length: 128
  Type: Extension

 Click "Apply/DDL" button on table S_SRV_REQ
  - Apply
  - Specify Table Space, Database User/Password, ODBC datasource: the server that is using

- Business Component: Service Request (Lock Project "Service"
  Add Field: IntegrationSite
  Column: X_INTEGRATION_SITE
  Text Length: 128
  Type: DTYPE_TEXT

- Compile the selected Projects ("Custom UI Samples", "Service")
and the Table S_SRV_REQ Object (Compile Selected Objects)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms