My Oracle Support Banner

CSXSRISR: Cannot Create Service Request When Contact Time Zone Is Not Enabled In FND_TIMEZONES_B Table (Doc ID 557116.1)

Last updated on FEBRUARY 06, 2022

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

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

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