My Oracle Support Banner

Legal entity is duplicated (Doc ID 1186763.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Legal Entity Configurator - Version 12 and later
Information in this document applies to any platform.

Goal

When creating the legal entity that was created twice, appears with the same organization number

scripts to determine duplicate ids:
a. use the ledger name to identify the ledger
select ledger_id, configuration_id from GL_LEDGERS
where name = '&ledgername'

b.use the ledger id to find out what legal identities are assigned

Select Legal_entity_name,legal_entity_id
FROM GL_LEDGER_LE_V
WHERE ledger_id = &ledger_id
/

c. use the configuration id returned in b
select * from GL_LEDGER_CONFIG_DETAILS
where configuration_id = &configuration_id

d. If there are duplicate lines for the legal entity use the OBJECT_NAME from C to see if there are duplicate details

Select * from XLE_REGISTRATIONS
WHERE REGISTERED_NAME = '&OBJECT_NAME'



Upload the results and the sql run in spreadsheet format please.


Solution

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
Goal
Solution
References


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