Scripts - Flexfield Values

Key Flexfields are stored in the following tables:

1. FND_FLEX_VALUE_SETS


2. FND_FLEX_VALUES

SELECT *
FROM FND_FLEX_VALUES
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = :VALUE_SET_NAME
)
AND ENABLED_FLAG = 'Y' -- For Active Values
AND SUMMARY_FLAG = 'N' -- For Child Values

Pass the Value Set Name as Parameter

Technical - Territory / Jurisdiction Tables

Below is the list of tables concerned when you create territories, jurisdictions, legal entities, establishments and registrations:

1. XLE_JURISDICTIONS_VL


2. XLE_REGISTRATIONS


3. XLE_ENTITY_PROFILES


4. XLE_ETB_PROFILES


5. XLE_FIRSTPARTY_INFORMATION_V


6. XLE_REGISTRATIONS

I had an issue with creation on Legal Entities in R12.0.4. When I created the legal entity, it created the legal entity twice and created 2 registrations as well. I was unable to disable one of them as any change to one would reflect on the other.

As a consequence when I was attaching the Legal Entity in my accounting setup, I had to attach both legal entities. This was not acceptable however.

When I checked, even the jurisdiction was created twice. Going through the above tables and clearing the inappropiate lines resolved the issue.

Note however that this is not a recommended solution.

Shameem Bauccha

18 June 2009