My Oracle Support Banner

Date Fields Converted Using ToChar() In Data Maps Are Missing Date Separators In Integration Objects in Linux For Asynchronous Server Request Starting From Siebel 24.3 (Doc ID 3032842.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Siebel CRM - Version 24.5 and later
Information in this document applies to any platform.

Symptoms

After update from Siebel 24.1 to 24.5, web service responses were failing to display date field values correctly

For example, Source Expression in the Data Map such as:
ToChar([Start Date], 'MM/DD/YYYY')

In Siebel 24.1 and prior, this Map Expression returns date with "slash" separators, e.g., '01/10/2009'. After applying 24.5, the value returned is '01102009'. This results in XML payloads with invalid dates, such as 01102009.

Issue can be reproduced at will with the following steps:

 

1. Update from Siebel 24.1 to 24.5 or 24.6

2.Import attached aa.sif file which has customized workflow file, datamap and IO and deliver the objects to Main.

3.Please note down the rowid by navigating to Contact List Applet > Note (detail applet) > Contact Note View which is Public Notes

4.Goto Siebel Client > Sitemap > Administration - Business Service > Simulator View > click the {Load From File} button > select the "Asynchronous Server Requests.xml". Add Input Arguments

   in  second applet> click the {Load From File} button > select the "Asynchronous Server Requests BS Simulator Inputs.xml"

Then, click the {Run} button.

5.Issue is seen only in Asynchronous Server Requests with below output

 

<?xml version="1.0" encoding="UTF-8"?><?Siebel-Property-Set EscapeNames="true"?><PropertySet
reqId="1-5X-B"
><PropertySet
sblValueVariant="CCFVT_UTF8"
Process_spcInstance_spcId="1-Z1C"
PrimaryRowId="1-S3Q"
Object_spcId=""
Siebel_spcOperation_spcObject_spcId=""
Error_spcCode=""
Error_spcMessage=""
>
<?xml version="1.0" encoding="UTF-8"?><SiebelMessage
MessageId="1-XF"
IntObjectName="ADV EAI LOY Member Contact Note IO Datamap"
MessageType="Integration Object"
IntObjectFormat="Siebel Hierarchical"
><ADVEAIMemberCommentsResponse
><ListOfADVEAIMemberComments
><ADVEAIMemberComments
><CommentText
>AA TEST</CommentText
><CommentTypeCode
>Note</CommentTypeCode
><CreationDate
>06262024</CreationDate
><CreatorSourceId
>Open Point</CreatorSourceId
></ADVEAIMemberComments
></ListOfADVEAIMemberComments
></ADVEAIMemberCommentsResponse
></SiebelMessage
><SiebelMessage
MessageId="1-XF"
IntObjectName="ADV EAI LOY Member Contact Note IO Datamap"
MessageType="Integration Object"
IntObjectFormat="Siebel Hierarchical"
><ListOfADV_spcEAI_spcLOY_spcMember_spcContact_spcNote_spcIO_spcDatamap
><ADVEAIMemberComments
CreationDate="06262024"  /////////// It fails only in Linux and works fine in Windows
CreatorSourceId="Open Point"
CommentText="AA TEST"
CommentTypeCode="Note"
></ADVEAIMemberComments
></ListOfADV_spcEAI_spcLOY_spcMember_spcContact_spcNote_spcIO_spcDatamap
></SiebelMessage
></PropertySet

Changes

 Update from Siebel 24.1 to Siebel 24.5

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


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