Legal entity is duplicated
(Doc ID 1186763.1)
Last updated on DECEMBER 03, 2021
Applies to:Oracle Legal Entity Configurator - Version 12 and later
Information in this document applies to any platform.
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
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.
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