PeopleSoft FSCM

               Let us look in to underlying base tables for User Preference page. Understanding the base tables will come handy when we migrate user setup from one instance to different instance. Also when we need to setup test users for any load or performance testing. Below is the list of few important tables: Overall Preference: PS_OPR_DEF_TBL_FS OLE Information: PS_OPR_DEF_TBL_OLE Process Group:  PS_RTM_OPR_SOURCE; PS_RTM_OPR_GROUP  Asset Management: PS_OPR_DEF_TBL_AM IT Asset Management: PS_OPR_DEF_TBL_IT Billing: PS_OPR_DEF_TBL_BI Contracts: PS_OPR_DEF_TBL_CA Contract Status Authorization: PS_CA_OPRID_CASTAT  General Ledger: PS_OPR_DEF_TBL_FS Journal Entry Options:  PS_OPR_DEF_TBL_GL Inventory:  PS_OPR_DEF_TBL_IN Procurement: PS_OPR_DEF_TBL_PM Payables Online Vouchering:  PS_OPR_DEF_TBL_AP Requisition Authorizations: PS_OPR_PO_RQSTR PO Authorizations -  Buyer User Authorization: PS_OPR_PO_BUYER Supplie...