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

Oracle Apps R12 - GL - Creating a territory

Legal Entity Administrator --> Lookups --> Define Lookups

[caption id="attachment_7" align="alignnone" width="756" caption="Legal Entity Configurator Lookup"][/caption]

You can define your own values for Legal Entity, Establishment and Legal Entity Person Registration.

Query ‘LE Registration Code’, ‘Establishment Registration Code’ or ‘Legal Entity Person Registration Code’ in the description field and update accordingly.

Clear the cache to ensure the values appear in your lookups.

Legal Entity Administrator --> Jurisdictions

[caption id="attachment_8" align="aligncenter" width="300" caption="Legal Entity Configurator"][/caption]

Select the Legislative Category

[caption id="attachment_17" align="aligncenter" width="120" caption="Legislative Category"][/caption]

Click on ‘Go’.

[caption id="attachment_10" align="aligncenter" width="300" caption="Jurisdictions"][/caption]

Add Legal Functions if required.

[caption id="attachment_14" align="aligncenter" width="300" caption="Add Legal Functions"][/caption]

You can add any combination of the following functions:

[caption id="attachment_12" align="aligncenter" width="207" caption="Legal Functions"][/caption]

Click on ‘Apply’.

You should get a confirmation message.

[caption id="attachment_15" align="aligncenter" width="442" caption="Confirmation"][/caption]

Your jurisdiction must now be available.

The territory will now be available when you create your Legal Entity.

Shameem Bauccha

18 June 2009

Click here to download the file.