My Oracle Support Banner

HZ_TIMEZONE_MAPPING Table Is Not Sync With FND_TERRITORIES_TL (Doc ID 1164764.1)

Last updated on OCTOBER 22, 2018

Applies to:

Oracle Trading Community - Version 12.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
HZ_TIMEZONE_MAPPING,FND_TERRITORIES_TL,Canada, Bangladesh, Bosnia and Herzegovina BIH,
Croatia, Macao, Isle of Man, Macedonia, Uzbekistan,
Serbia, Saint Barthelemy, Saint Martin


Symptoms

Some records in HZ_TIMEZONE_MAPPING table ar not in sync with FND_TERRITORIES_TL ?
   
When executed:
 
   

Select * From FND_TERRITORIES_TL
Where territory_code Not In (SELECT country
FROM HZ_TIMEZONE_MAPPING);


   
There are some records are not having mapping. 

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
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
References


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