EBS 12.2 adadmin failing with Error in addgbc(): Multiple Sets of Books is not compatible with MultiOrg

 Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
AD code level : [C.15]
*** Maintaining the Run File System (in Hotpatch mode) ***
*** Edition Enabled User ***

Error in addgbc():
Multiple Sets of Books is not compatible with MultiOrg

AD Administration error:
Error getting configuration information in adadmin_main()
You should check the file
/prod/fs_ne/EBSapps/log/adadmin/log/adadmin.log
for errors.


*** Edition Enabled User ***

Cause: After adding custom top using adsplice, there are chances of duplicate product entries

Action: Delete those duplicate entries and run adadmin 

Steps:

SQL> set lines 200

SQL> col APPLICATION_SHORT_NAME for a25

SQL> col PRODUCT_CODE for a15

SQL> col BASEPATH for a10

SQL> select * from fnd_application where APPLICATION_SHORT_NAME like '%XXTOP%';

APPLICATION_ID APPLICATION_SHORT_NAME    LAST_UPDA LAST_UPDATED_BY CREATION_ CREATED_BY LAST_UPDATE_LOGIN BASEPATH   PRODUCT_CODE    ZD_EDITION_NAME                ZD_SYNC

-------------- ------------------------- --------- --------------- --------- ---------- ----------------- ---------- --------------- ------------------------------ ------------------------------

         20003 XXTOP                       11-DEC-02            1027 11-DEC-02       1027              2484 XX_TOP    XXTOP             SET1                           SYNCED

SQL> SELECT LAST_UPDATE_DATE, APPLICATION_ID, STATUS, ORACLE_ID FROM apps.FND_PRODUCT_INSTALLATIONS WHERE APPLICATION_ID =20003;

LAST_UPDA APPLICATION_ID S  ORACLE_ID

--------- -------------- - ----------

08-MAY-12          20003 L        900 -->delete this entry with status "L"

26-MAR-25          20003 I      20033

SQL> delete from apps.FND_PRODUCT_INSTALLATIONS where APPLICATION_ID=20003 and ORACLE_ID=900;

1 row deleted.

SQL> SELECT LAST_UPDATE_DATE, APPLICATION_ID, STATUS, ORACLE_ID FROM apps.FND_PRODUCT_INSTALLATIONS WHERE APPLICATION_ID =20003;

LAST_UPDA APPLICATION_ID S  ORACLE_ID

--------- -------------- - ----------

26-MAR-25          20003 I      20033

SQL> 

SQL> commit;

Commit complete.

SQL>

Rerun admin and it works fine.

Happy troubleshooting, please comment if you need any further information or hep 👍