Delete Balance Level Reporting Currency from Accounting Setup Manager (Oracle GL)

Deletion of Balance Level Reporting Currency is not supported by Oracle EBS. Workaround is to stop running translation. But I needed to get rid of the reporting currency anyway. So I've tested the deletion from the oracle base table where it stores the Relationship of the ledger with the reporting currency. It worked!


delete from GL_LEDGER_RELATIONSHIPS where relationship_id = 1001;

Of course, I took a backup of the table before running the statement ;-)

Cheers!