Oracle Applications

Oracle for Beginners

Technical – Territory / Jurisdiction Tables

Posted by shameemakhtar on June 18, 2009

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

Advertisements

One Response to “Technical – Territory / Jurisdiction Tables”

  1. jeremy said

    Hi Shameem,

    we have this requirement to replicate legal entity from one instance to another in R12.
    do we have an API to create and update legel entity in R12?

    Thanks a lot,
    eric

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s