My Oracle Support Banner

Table FND_TERRITORIES Column ISO_TERRITORY_CODE Is Set To Null On Update In Territory Form (Doc ID 1271116.1)

Last updated on AUGUST 17, 2021

Applies to:

Oracle Application Object Library - Version 11.5.6 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


Upon saving a change made to the description field in the Territories form (FNDNLDTI), the FND_TERRITORIES_VL.iso_territory_code field is set to NULL.

Steps to reproduce:
1. Open Territories form (
2. Responsibility: System Administrator.
3. Navigation: Install > Territories.
4. Query a record in FND_TERRITORIES_VL that has a value in iso_territory_code.
5. Query that same territory in the Territories forms.
6. Change its description.
7. Now query again in FND_TERRITORIES_VL and you will notice that the iso_territory_code was set to null.




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

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