Legal entity is duplicated (Doc ID 1186763.1)

Last updated on AUGUST 09, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms