Legal entity is duplicated
Last updated on AUGUST 09, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms