6,405
We have an installation with multiple AppDB's in a single System DB, but are only deploying BP to one of the companies (the other companies are mostly for GL consolidations, etc). I can find documentation online about how to add a new company to BP, but how do we remove any of the companies we do not wish to see in BP?
Thanks.
*This post is locked for comments
You can do what you suggested as far as setting the user role assignment from All Companies to just the one BP company. You can then run the attached scripts and this will remove the BP objects from the App DB's that you do not want to show up in BP. Getting all of the other company info from the system database gets a bit involved—uninstall BP, temporarily remove the company records that you don’t want in BP, reinstall BP—then putting the company records back in.
Scripts:
-- drop all BP 4 objects
--
-- Application DB
--
-- Modified 4/30/2012
Drop Function XMLEncode
Drop Procedure PFTE_RP_GetTime_StepTotal_PastFuture
Drop Procedure PFTE_PJSubTask_PV
Drop Procedure PFTE_Company_PV
Drop Procedure PFTE_RP_GetTime_Plan_Actual_Future
Drop Procedure PJCustomOptions_spk0
Drop Procedure pjcommun_spk3w_Home
Drop Procedure pw_WPETaskID_PV
Drop Procedure PFTE_RP_GetInfo_StepOp
Drop Procedure BP_DB_Field_Length
Drop Procedure ARDOC_swebiiall
Drop Procedure PJPTDROL_swebana
Drop Procedure PmaClearStoredProcResults
Drop Procedure pw_PJCode_LABC_PV
Drop Procedure PFTE_GetWeekInfo
Drop Procedure PFTE_GetTime_ProjTaskTotal_PastFuture
Drop Procedure PJEXPHDR_sempallstatus
Drop Procedure PJCONTRL_SPK3
Drop Procedure PFTE_RP_GetCapacity_Resource
Drop Procedure pw_WPTTaskID_PV
Drop Procedure pw_Employee_PV
Drop Procedure PFTE_Subacct_PV
Drop Procedure PFTE_RP_UpdateStepEnd
Drop Procedure PJLabDet_sWTR
Drop Procedure pw_EmployeeForTimeExpenseApproval_PV
Drop Procedure PFTE_GetsNote
Drop Procedure PJLABDET_WEBGRID
Drop Procedure PJLABAUD_insert
Drop Procedure PJLabDet_uWTR
Drop Procedure PJEMPLOY_GetDefaultApprover
Drop Procedure pw_TaskID_PV
Drop Procedure PFTE_PJvETask_sMSPTskT
Drop Procedure PFTE_RP_GetTime_Late
Drop Procedure pw_ExpType_PV
Drop Procedure pjinvdet_swebdate
Drop Procedure PJText_GetTextForExpense
Drop Procedure PFTE_RP_GetTime_LabDet_Total
Drop Procedure PJCODE_SPK3
Drop Procedure pw_PJPent_RS
Drop Procedure PFTE_GetTime_Project_W
Drop Procedure pw_ProjectID_PV
Drop Procedure pjcommun_spk3w_Co
Drop Procedure PJCustom_spk0
Drop Procedure GetIdentity
Drop Procedure PJDeleteExpense
Drop Procedure PJLabHdr_GetStartDate
Drop Procedure PFTE_FindHeader
Drop Procedure PJLabDet_sIQWTR
Drop Procedure PJInvDet_GetProjectTaskDesc
Drop Procedure PFTE_GetInfo_ProjectTask
Drop Procedure pjinvdet_swebstatus
Drop Procedure pw_Vendor_PV
Drop Procedure PFTE_RP_GetInfo_TaskStep
Drop Procedure pw_GL_Acct_PV
Drop Procedure PFTE_RP_GetTime_StepTotal_Detail
Drop Procedure PFTE_GetTime_LabDet_Emp_ProjTaskTotal
Drop Procedure ARDOC_swebiiopen
Drop Procedure PJEXPAUD_insert
Drop Procedure pw_PJProj_RS
Drop Procedure pw_AcctCat_PV
Drop Procedure PJLABHDR_sempallstatus
Drop Procedure pjproj_sweb_PV
Drop Procedure pw_EmployeeALL_PV
Drop Procedure PJCustom_Options
Drop Procedure PFTE_RP_GetTime_Plan_Actual_Past
Drop Procedure PFTE_FindCorrectingHeader
Drop Procedure PJLabDet_sIQWTRManager
Drop Procedure PFTE_FindDetail_FlexPeriod
Drop Procedure pw_PJExpType_RS
Drop Procedure PJDeleteTimecardLine
Drop Procedure pjinvhdr_sweb_PV
Drop Procedure PJExpDet_uWTR
Drop Procedure PFTE_pjproj_spk2em
Drop Procedure PJLabHdr_uSetReviewCount
Drop Procedure Customer_Exist
Drop Procedure PFTE_RP_GetTime_Operation_W
Drop Procedure PJLabHdr_GetDetailComments
Drop Procedure PFTE_GetTime_TaskTotal_Detail
Drop Procedure PFTE_GetTime_LabDet_ProjTaskTotal
Drop Procedure pjcommun_delete
Drop Procedure PJNotes_DoesCommentExist
Drop Procedure PFTE_RP_UpdateTaskEnd
Drop Procedure PFTE_FindDetail
Drop Procedure pw_PJEmpPjt_RS
Drop Procedure PFTE_GetCuryID
Drop Procedure PFTE_RP_GetTime_Late_W
Drop Procedure PJDeleteTimecard
Drop Procedure PJText_GetTextForInvoice
Drop Procedure pw_PJSubTask_PV
Drop Procedure PJLabDet_uSetReviewStatus
Drop Procedure PFTE_LaborClass_PV
Drop Procedure PFTE_GetSite
Drop Procedure PFTE_GetInfo_PTE_Proximity
Drop Procedure pw_Customer_PV
Drop Procedure pw_WPTProjectID_PV
Drop Procedure pw_WPEProjectID_PV
Drop Procedure PFTE_RP_XRPStep_PV
Drop Procedure pw_Cury_PV
Drop Procedure PJExpDet_GetProjectTaskDesc
Drop Procedure PJLABDET_WEBGRIDHourTotal
Drop Procedure PFTE_RP_GetCapPlanAct
Drop Procedure PJLabHdr_uLineApproved
Drop Procedure PJExpHdr_uSetReviewCount
Drop Procedure pjinvdet_swebunbill
Drop Procedure PJExpHdr_uLineApproved
Drop Procedure PFTE_PJEMPLOY_sACTIVE
Drop Procedure PFTE_RP_GetTime_StepTotal
Drop Procedure PFTE_PJPENT_sPK7
Drop Procedure PJEMPLOY_DoesEmployeeExist
Drop Procedure PJLabHdr_uLineRejected
Drop Procedure PFTE_pjpentem_sSched
Drop Procedure PFTE_RP_GetTime_Operation
Drop Procedure PJExpHdr_uLineRejected
Drop Procedure PFTE_GetTime_Project
Drop Procedure PJText_GetTextForTime
Drop Procedure PFTE_RP_GetTime_StepTotal_Sum
Drop Procedure PFTE_Account_PV
Drop Procedure pp_GetVenditem_QTD_YTD
Drop Procedure PFTE_GetDocNbr
Drop Procedure PJExpDet_sIQWTR
Drop Procedure PJText_SPK1
Drop Procedure PFTE_RP_GetTime_GridNewPTS
Drop Procedure PFTE_GetInfo_PJLabDet
Drop Procedure PJInvHdr_GetHeaderInfo
Drop Procedure PJExpDet_sWTR
Drop Procedure pw_PJCode_SHFT_PV
Drop Procedure pw_EmployeeForTimeExpenseApprovalCount_PV
Drop Procedure PJExpDet_sIQWTRManager
Drop Procedure PFTE_RP_GetTime_Plan
Drop Procedure pw_Contract_PV
Drop Procedure pjinvdet_swebdraft
Drop Procedure PFTE_RP_GetInfo_XRPTask
Drop Procedure pw_PJCode
Drop Procedure pw_Subacct_PV
Drop Trigger RC_Delete_Trigger
Drop Table PJCUSTOMOptions
Drop Table RC_ReportRoleAssignments
Drop Table RC_ReportUsage
Drop Table PJCUSTOM
Drop Table ApproveItemHist
Drop Table ReportCatalog
Drop Table StoredProcedureResultSet
Drop Table Approver
Drop Table PRBPTimesheet
Drop Table AdvTimecardSetup
Drop Table RC_ReportCenterAssignments
Drop Table ApproveItem
Drop View vs_kpi
Drop View vs_mbfprocessdefinition
Drop View PJContrlView
Drop View vs_mbfprocessaction
Drop View vs_mbfwindowsterminalserver
Drop View BPv_ARHistCpny
Drop View vs_mbfclientcomment
Drop View vs_kpicalcunit
Drop View PJDetAna
Drop View vs_mbfwsscsgrouppart
Drop View PJTranView
Drop View vs_mbffolderitem
Drop View vs_mbfenterpriseinfo
Drop View vs_mbfhomepage
Drop View vs_kpialternategroup
Drop View vs_mbfresourceproviderquery
Drop View vs_mbfworkitemprovider
Drop View vs_mbfsubscription
Drop View BPv_RQUserSubAct_SubAcct
Drop View vs_mbfdecisionprocess
Drop View vs_mbfuser
Drop View BPv_RQUserAcct_AcctSub
Drop View vs_mbfworkitemprocess
Drop View vs_rc_reportcenters
Drop View vs_mbfprocessproperty
Drop View vs_mbfworkitem
Drop View vs_mbfdynamicviewsecurity
Drop View vs_mbfprocesscontroller
Drop View vs_mbfactionmenuitem
Drop View vs_mbfdynamicviewpropertyrestriction
Drop View vs_mbfuserpreferencesetting
Drop View vs_mbfsystemworkitem
Drop View PFT_v_PJLabDet_Correction
Drop View vs_mbfentitytracker
Drop View PFT_v_PJLabDet
Drop View vs_kpiperiod
Drop View vs_mbfuserwindowsidentity
Drop View vs_mbfstateaction
Drop View vs_mbfroleuser
Drop View vs_mbfworkitemprocessnonstateaction
Drop View pjdetana1
Drop View vs_mbfactivityhostprocess
Drop View vs_mbfprocesslog
Drop View vs_rsprinter
Drop View vs_rc_reportseriescenters
Drop View vs_mbfpermissionadministrator
Drop View PFTE_RP_v_PJLabDet_XRPSched_Correction
Drop View vs_bpconfiguration
Drop View PFT_v_PJLabDet_Flex
Drop View PJvPentEm
Drop View BPV_SolomonReports
Drop View vs_mbfinstalleddatabases
Drop View vs_mbfnavigationmenuitem
Drop View vs_kpitimephasedvalue
Drop View PFTE_RP_v_PJLabDet_XRPSched_Flex
Drop View vs_mbfworkitemprocessstateaction
Drop View vs_mbfbuiltinstateaction
Drop View vs_mbfprovideritem
Drop View PFT_v_PJLabDet_Flex_Correction
Drop View vs_mbfhyperlinkstage
Drop View vs_mbfuiitemdescriptor_l
Drop View vs_rc_reportseries
Drop View vs_mbfsubprocessstage
Drop View vs_usertaskmapping
Drop View vs_kpialertviewerimageset_l
Drop View vs_mbfproviderworkitemaction
Drop View vs_mbfuiportalpage
Drop View BPv_RQUserAcct_AcctXRef
Drop View vs_mbfsystemworkitemnonstateaction
Drop View vs_mbfrunningprocess
Drop View vs_mbfprocessaliaslog
Drop View BPv_APHistCpny
Drop View vs_mbfprocesseventsubscription
Drop View PJTskAna
Drop View vs_mbfbuiltinstateactionmap
Drop View vs_mbfsystemworkitemstateaction
Drop View PJPrjBgt1
Drop View vs_mbfuiitemdescriptorsecurity
Drop View vs_mbfcompanybranding
Drop View vs_kpifiscalprovider
Drop View BPV_CSDDetail
Drop View vs_mbfsmartlistaction
Drop View vs_mbfurlitem
Drop View vs_mbfnavigationmenu
Drop View vs_mbfwindowsterminalserver_l
Drop View PJTskAna1
Drop View vs_mbfstageguardcondition
Drop View vs_mbfappadministration
Drop View vs_mbfbackofficeaccess
Drop View vs_mbfactivitystage
Drop View vs_mbfrole
Drop View vs_mbfanyuser
Drop View vs_mbfprocessconfigurationproperty
Drop View vs_mbfcompositeprocessstage
Drop View vs_mbfactionmenu
Drop View vs_mbfbuiltinnonstateaction
Drop View vs_reportrequest
Drop View vs_mbfnonstateaction
Drop View vs_mbfsmartlisttask
Drop View vs_mbfclientworkitemaction
Drop View PJPrjBgt
Drop View vs_mbfuiitemdescriptor
Drop View PJTskBgt1
Drop View vs_mbfworkfloweventlog
Drop View vs_mbfadministrationsetting
Drop View PFTE_RP_v_PJLabDet_XRPSched_Flex_Correction
Drop View vs_kpialternate
Drop View PJTskBgt
Drop View vs_mbfprocessalias
Drop View PJPrjAna1
Drop View vs_mbfhyperlinkprocess
Drop View vs_mbfresourceprovider
Drop View vs_mbfshortcutmenuitem
Drop View vs_mbfdynamicview
Drop View vs_mbftasksecurity
Drop View vs_mbfquerysecurity
Drop View BPv_RQUserSubAct_AcctSub
Drop View vs_rsprintersecurity
Drop View vs_mbfquery
Drop View vs_mbfworklistadapterconfiguration
Drop View vs_solomonprovider
Drop View vs_mbfsystemstateaction
Drop View vs_mbfprovideritem_l
Drop View vs_kpialertviewerimageset
Drop View vs_mbfqueuedworkitem
Drop View BPv_AcctHist
Drop View vs_userdefaultdataconfig
Drop View vs_mbfsmartlist
Drop View vs_mbfsequentialprocess
Drop View vs_defaulttasks
Drop View PFTE_RP_v_PJLabDet_XRPSched
Drop View vs_mbfshortcutmenu
Drop View vs_mbfprocesscomment
Drop View PJPrjAna
Drop View vs_mbfactivitylog
Drop View vs_mbfusersetting
Drop View vs_kpisecurity
drop schema businessportaluser
drop user BusinessPortalUser
drop schema bfgroup
drop role bfgroup
drop login businessportaluser
They are in separate AppDB's. I figured out that I can change the "User" Role assignment from "All Companies" to just the Company that is using BP, but also wonder if there is a way to remove those other companies from appearing in BP altogether.
Thanks.
Mark,
Do you have multiple companies on 1 APP DB, or do all companies have their own App DB?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (