How To Pass A Workflow Process Property To A Data Map To Set As A Value For A Target Output Field? (Doc ID 2247557.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

PRODUCT VERSIONS:
------------------------------
SIEBEL VERSION: Siebel 15.9 [IP2015]
SIEBEL APP O/S: Linux x86

ISSUE STATEMENT:
----------------------------

A custom data mapper has been created to map output returned by a Siebel outbound web service call to a SiebelMessage which gets passed to EAI Siebel Adapter Upsert to create a new attachment. In the data mapper definition, a workflow process property was specified in the Integration Component Field Source Expression as [&sDocumentClassName] where sDocumentClassName is the workflow process property name and should be outputted/set to the "FIN AccntFileName" IC Field. When executing the data map, the value from the sDocumentClassName process property was not retrieved and thus the "FIN AccntFileName" IC field was null.

Since the "FIN AccntFileName" was empty, then the EAI Siebel Adapter failed to insert the attachment and resulted in error.

ERROR MESSAGE:
--------------------------
The error message that occurs with this issue is:

StpExec Task 4 0000000258cd2560:0 2017-03-19 01:10:33 Invoking method 'Upsert' on business service 'EAI Siebel Adapter'.
StpExec TaskArg 4 0000000258cd2560:0 2017-03-19 01:10:33 Input: @0*0*0*1*0*0*4*2*13*SiebelMessage0*9*MessageId0*13*IntObjectName5*AccIO11*MessageType18*Integration Object15*IntObjectFormat19*Siebel Hierarchical0*1*11*ListOfAccIO0*1*1*5*AccIC0*5*AccNo14*123456789012340*1*11*ListOfAttIC0*3*0*5*AttIC0*23*FIN Accnt Attachment Id7*1-1D6G817*FIN AccntFileName0*16*FIN AccntFileExt3*tif1*1*11*Attachments0*7*1-1D6G80*1*0*8*Document2*53838
...
...
EAISiebAdpt EAISiebAdptErr 1 0000000258cd2560:0 2017-03-19 01:10:33 [0] Required field is missing in instance of Integration Component 'AttIC' with the user key '[FIN AccntFileExt] = "tif" AND [FIN AccntFileName] IS NULL': 'FIN AccntFileName' is a required field. Please enter a value for the field.(SBL-DAT-00498)(SBL-EAI-04389) (0x7501f2)
EAISiebAdpt EAISiebAdptTrcDebug 5 0000000258cd2560:0 2017-03-19 01:10:33 Finished execution of Upsert method
EAISiebAdpt EAISiebAdptTrcDebug 5 0000000258cd2560:0 2017-03-19 01:10:33 Finished execution of Upsert method
ObjMgrBusServiceLog InvokeMethod 4 0000000258cd2560:0 2017-03-19 01:10:33 Business Service 'EAI Siebel Adapter' invoke method 'Upsert' Execute Time: 0.619 seconds.
ObjMgrBusServiceLog InvokeMethod 4 0000000258cd2560:0 2017-03-19 01:10:33 End: Business Service 'EAI Siebel Adapter' invoke method: 'Upsert' at 22b3fa28
ObjMgrLog Error 1 0000000258cd2560:0 2017-03-19 01:10:33 (stepexec.cpp (1586)) SBL-BPR-00162: Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Siebel Adapter'.

STEPS TO REPRODUCE:
---------------------------------
The behaviour occurs as follows:

1. Created a custom data map with the Integration Component Field Source Expression as [&sDocumentClassName] where sDocumentClassName is the workflow process property name and should be outputted/set to the "FIN AccntFileName" IC Field.

2. In a workflow process, invoke the business service:

Business Service: EAI Data Transformation Engine
Method: Execute

Pass in values for the following arguments for the business service:

MapName
SiebelMessage
OutputIntObjectName

3. Simulate the business service, the error occurs.

LOSS OF FUNCTIONALITY / BUSINESS IMPACT:
--------------------------------------------
Eventually the attachment file name would be retrieved dynamically via the workflow process property so the data mapper must be able to get this value and set it in the "FIN AccntFileName" IC Field in order for the adapter to create the attachment. Otherwise, the attachment cannot be created and the rest of the workflow execution fails.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.