CSXSRISR: Cannot Create Service Request When Contact Time Zone Is Not Enabled In FND_TIMEZONES_B Table

(Doc ID 557116.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Teleservice - Version 12.0.4 and later
Information in this document applies to any platform.
CSXSRISR.fmb


Symptoms

On release 12:
When creating a Service Request (SR) on the Service Request form,
the contact time zone is determined correctly, but cannot be saved,
if the enabled flag for the determined time zone is not set to 'Y' in the
FND_TIMEZONES_B table.

Error received:

"FRM-40212: Invalid value for field TIME_ZONE."

-- Steps To Reproduce:
1. create a contact in the contact center and enter a contact address which is in Germany. - The
timezone Berlin will be determined.

2. create a SR, select the created contact under step1, select necessary other information and save
the SR. -- an error message will show "FRM-40212: Invalid value for field TIME_ZONE."

Changes

Upgraded to release R12.

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