Although you typically don’t want to do this, let’s say you set up a GLBU in a non-production environment that really shouldn’t be there. Here is some SQL to get rid of the GLBU. Other ideas would be to enable BU security and restrict access to the GLBU’s or just manage them through the Open/Closed periods control, but this should get them out of everyone’s prompt list.
My hope is that SOMEDAY Oracle / PeopleSoft will allow for the INACTIVATION of GLBU’s, but that’s been a feature request for what seems like ever. Don’t hold your breath.
Note: replace US001 with your business unit(s). Also, this is valid as of PeopleSoft Financials v9.1, Tools 8.52.
DELETE FROM PS_BUS_UNIT_TBL_GL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BUS_UNIT_TBL_FS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_SETID_TBL WHERE SETID = ‘US001’;
DELETE FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = ‘US001’;
DELETE FROM PS_SET_CNTRL_GROUP WHERE SETCNTRLVALUE = ‘US001’;
DELETE FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = ‘US001’;
DELETE FROM PS_SET_CNTRL_TREE WHERE SETCNTRLVALUE = ‘US001’;
DELETE FROM PS_BU_JE_ID_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_JE_IC_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_JE_BS_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_JE_ES_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_JE_AS_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BUL_JE_RA_CFS WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BUS_UNIT_IDS_GL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_ADB_INCR_CONTRL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_LGRP_ADB_ACT WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_LED_TBL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_LED_GRP_TBL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BU_LED_COMB_TBL WHERE BUSINESS_UNIT = ‘US001’;
DELETE FROM PS_BUL_CNTL_BUD WHERE BUSINESS_UNIT = ‘US001’;