IsHoliday Method of FS Holiday API Service throwing error in Multilingual Application (Doc ID 2048192.1)

Last updated on JANUARY 27, 2017

Applies to:

Siebel Field Service - Version 8.2.2.14.5 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.2.2.14.5 [IP2014] version, Field Service

ISSUE

IsHoliday method of FS Holiday API Service throwing error message in Non-ENU application.

While simulating in French application this method, it throwing error: Le jour du calendrier n'est pas valide(SBL-SFS-00116)

Expected result: TRUE or FALSE value should get returned.


In English application it is working fine.
 
Note: This issue is occuring when we are trying to get French Value in Start Day and Type field in Administration - Service > Schedules > Schedule hours.
 

ACTUAL BEHAVIOR
---------------
In English application it is working fine.
While simulating in French application this method, it throwing error: Le jour du calendrier n'est pas valide(SBL-SFS-00116)

EXPECTED BEHAVIOR
-----------------------
Should work fine French too

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Configuration Done/Steps to reproduce:

1.Login to Siebel Tools. Goto Table: S_SCHED_CAL_HRS

2. Set Translate Table Name property of 'START_DAY' = S_LST_OF_VAL
 
3. Compile the changes and do Apply/Activate.

4. Login to Siebel Application. Goto Administration - Data > List of Values. Create new LOVs (for French application) as below:
Type Display Value LIC Language Active/Translate/Multilingual
DAY_NAME Dimanche Sunday French Y Y Y
DAY_NAME lundi Monday French Y Y Y
DAY_NAME Mardi Tuesday French Y Y Y
DAY_NAME Mercredi Wednesday French Y Y Y
DAY_NAME jeudi Thursday French Y Y Y
DAY_NAME Vendredi Friday French Y Y Y
DAY_NAME Samedi Saturday French Y Y Y

5. Login to French Application. Simulate IsHoliday method of FS Holiday API Service business service.
Navigate to Administration - Business Service > Simulator, enter the following:
 
Business Service: FS Holiday API Service
Method: IsHoliday
 
3 input parameters and values:
 
Calender Id: 1-ODGEM7
Time Zone:
Date Time: 08/12/2015 10:00:00
 
Click on Run button to execute.
 
The Result is: Error popup message is comming
Le jour du calendrier n'est pas valide(SBL-SFS-00116)


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Not able to use the functionality

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