Thursday, June 30, 2016

Peoplesoft CRM 9.2 DMS script


-----***********************************
-----** 360 Degree View Configuration **
-----***********************************
----- This section contains all the configuration related to 360 Degree;

SET OUTPUT PT_UPG_360_EXPORT.DAT;
SET LOG PT_UPG_360_EXPORT.LOG;

---********************
---** Profile Setup  **
---********************
---Navigation: SetUpCRM > Common Definitions > 360 Degree View > Set Up Profile

--Configurable Profile Setup;
EXPORT PS_RB_TD_PROF_SET;

--Configurable Profile Details;
EXPORT PS_RB_TD_PROF_DTL;

---******************************
---** Transaction Group Setup  **
---******************************
---Navigation: SetUpCRM > Common Definitions > 360 Degree View > Transaction Group

--Transaction Header;
EXPORT PS_RB_TD_TRANS_HDR;

--Transaction Actions;
EXPORT PS_RB_TD_TRANS_ACT;

---*************************
---** Dynamic Grid Setup  **
---*************************
---Navigation: SetUpCRM > Common Definitions > 360 Degree View > Dynamic Grid

----- To Export the 360 Degree View Grid Configuration;
EXPORT PS_RB_TD_DYNGRDLN;

--Dynamic Grid Header record;
EXPORT PS_RB_TD_DYNGRDHDR;

--Dynamic Grid key record;
EXPORT PS_RB_TD_DYNGRDKEY;


---*********************************
---** 360 degree View Node Setup  **
---*********************************
---Navigation: SetUpCRM > Common Definitions > 360 Degree View > Node

--Node record is used to store all the information about a node;
EXPORT PS_RB_TD_NODE;

--Tree Node;
EXPORT PS_RB_TD_TREE_NDE;

EXPORT PS_RB_TD_EIP;

EXPORT PS_RB_TD_EIP_FLDS;

EXPORT PS_RB_TD_NODE_RGRD;

EXPORT PS_RB_TD_PCDE_FLDS;

EXPORT PS_RB_TD_PCODE;

EXPORT PS_RB_TD_RGRD_FLDS;

EXPORT PS_RB_TD_VIEW;

EXPORT PS_RB_TD_VW_FLDS;



---*********************************
---** 360 degree View Tree Setup  **
---*********************************
---Navigation: SetUp CRM > Common Definitions > 360 Degree View > Tree

--Tree Header;
EXPORT PS_RB_TD_TREE_HDR;

---*******************************
---** Relationship View  Setup  **
---*******************************
---Navigation: SetUp CRM > Common Definitions > Customer > Configure Relationship Views

--Relationship viewer configuration repository;
EXPORT PS_BO_REL_CFG1;

--Relationship viewer  Level 2;
EXPORT PS_BO_REL_CFG2;

--Relationship viewer;
EXPORT PS_BO_REL_CFG3;

---**********************
---** Role Type Setup  **
---**********************
---Navigation: SetUp CRM > Common Definitions > Customer > RoleType

---Relationship viewer Role Defaults;
EXPORT PS_BO_REL_ROLEDFLT;



-----********************************
-----** AAF Configuration **
-----********************************

SET OUTPUT PT_UPG_AAF_EXPORT.DAT;
SET LOG PT_UPG_AAF_EXPORT.LOG;

EXPORT PS_EOCF_ACTION_DEF;
EXPORT PS_EOCF_ACTION_LNG;
EXPORT PS_EOCF_ACTION_OBJ;
EXPORT PS_EOCF_ACTION_SET;
EXPORT PS_EOCF_ACTN_TYPE;
EXPORT PS_EOCF_ACTOBJ_LNG;
EXPORT PS_EOCF_ACTTYP_LNG;
EXPORT PS_EOCF_ACT_BUNDLE;
EXPORT PS_EOCF_ACT_EV_TYP;
EXPORT PS_EOCF_ACT_VALEVT;
EXPORT PS_EOCF_AL_DTL_LNG;
EXPORT PS_EOCF_AL_DTL_TRM;
EXPORT PS_EOCF_BIND_SPEC;
EXPORT PS_EOCF_BNDDEF_LNG;
EXPORT PS_EOCF_BUNDLE_DEF;
EXPORT PS_EOCF_BUSDOM_LNG;
EXPORT PS_EOCF_BUS_DOMAIN;
EXPORT PS_EOCF_CLR_CACHE;
EXPORT PS_EOCF_CLR_RESULT;
EXPORT PS_EOCF_CLR_STATS;
EXPORT PS_EOCF_CONSTANTS;
EXPORT PS_EOCF_CONTEXT;
EXPORT PS_EOCF_CTX_IMPDTL;
EXPORT PS_EOCF_CTX_LANG;
EXPORT PS_EOCF_CTX_STORE0;
EXPORT PS_EOCF_CTX_STORE1;
EXPORT PS_EOCF_CTX_TMPSEQ;
EXPORT PS_EOCF_CTX_TYPE;
EXPORT PS_EOCF_CTX_VARSNW;
EXPORT PS_EOCF_CTX_VARS_L;
EXPORT PS_EOCF_DE_LOG;
EXPORT PS_EOCF_DE_LOG_DTL;
EXPORT PS_EOCF_DE_NATIVE;
EXPORT PS_EOCF_DL_LOG;
EXPORT PS_EOCF_DSP_ALERT;
EXPORT PS_EOCF_DSP_AL_DTL;
EXPORT PS_EOCF_DSP_AL_LNG;
EXPORT PS_EOCF_DSP_MSG;
EXPORT PS_EOCF_DS_ALT_TRM;
EXPORT PS_EOCF_DS_MSG_TRM;
EXPORT PS_EOCF_DTYPEXT_SY;
EXPORT PS_EOCF_ELEM_HIER;
EXPORT PS_EOCF_ELEM_SUBJ;
EXPORT PS_EOCF_EVENT_DEFN;
EXPORT PS_EOCF_EVENT_LNG;
EXPORT PS_EOCF_EVENT_SEQ;
EXPORT PS_EOCF_EVENT_TYPE;
EXPORT PS_EOCF_EVTYPE_LNG;
EXPORT PS_EOCF_FILTER_DFN;
EXPORT PS_EOCF_FILTER_FLD;
EXPORT PS_EOCF_FILTER_USR;
EXPORT PS_EOCF_FLTR_SAVED;
EXPORT PS_EOCF_HIER_SPACE;
EXPORT PS_EOCF_IACATEGORY;
EXPORT PS_EOCF_IACAT_LNG;
EXPORT PS_EOCF_IMPDEN_LNG;
EXPORT PS_EOCF_IMPL_BINDS;
EXPORT PS_EOCF_IMPL_DEFN;
EXPORT PS_EOCF_IMPL_PARMS;
EXPORT PS_EOCF_INSTALL;
EXPORT PS_EOCF_LINK_SPEC;
EXPORT PS_EOCF_OPER_DEFN;
EXPORT PS_EOCF_OPER_LNG;
EXPORT PS_EOCF_OPER_SET;
EXPORT PS_EOCF_OPRSET_LNG;
EXPORT PS_EOCF_OPRSET_SEQ;
EXPORT PS_EOCF_OPTIONS;
EXPORT PS_EOCF_PHRASE_DFN;
EXPORT PS_EOCF_PHRASE_LNG;
EXPORT PS_EOCF_PHRASE_XPR;
EXPORT PS_EOCF_PHR_TERMS;
EXPORT PS_EOCF_REMTD_PRMS;
EXPORT PS_EOCF_RESMTH_LNG;
EXPORT PS_EOCF_RESPRM_LNG;
EXPORT PS_EOCF_RES_DTYPES;
EXPORT PS_EOCF_RES_METHD;
EXPORT PS_EOCF_RSET_LNG;
EXPORT PS_EOCF_RSET_SEQ;
EXPORT PS_EOCF_RULESET;
EXPORT PS_EOCF_RULE_DEFN;
EXPORT PS_EOCF_RULE_LNG;
EXPORT PS_EOCF_SA_TREE;
EXPORT PS_EOCF_SUBJECT;
EXPORT PS_EOCF_SUBJ_LNG;
EXPORT PS_EOCF_TBINDS_LNG;
EXPORT PS_EOCF_TBIND_MAP;
EXPORT PS_EOCF_TERMD_LNG;
EXPORT PS_EOCF_TERM_ATTRS;
EXPORT PS_EOCF_TERM_BINDS;
EXPORT PS_EOCF_TERM_CFG;
EXPORT PS_EOCF_TERM_CTX;
EXPORT PS_EOCF_TERM_DEFN;


SET OUTPUT PT_UPG_BO_SEARCH_EXPORT.DAT;
SET LOG PT_UPG_BO_SEARCH_EXPORT.LOG;


--BO Search Adapter Definition record;
EXPORT PS_RBQ_ADPTR;

--BO Search Adapter Definition Section record;
EXPORT PS_RBQ_ADPTR_SECT;

--BO Search Adapter Definition Field record;
EXPORT PS_RBQ_ADPTR_FLD;

--BO Search Adapter Definition Role record;
EXPORT PS_RBQ_ADPTR_RL;

--BO Search Adapter Definition Label;
EXPORT PS_RBQ_ADPTR_LBL;

--BO Search Adapter Extesions;
EXPORT PS_RBQ_ADPTR_EXT;

--BO Search Criteria Definition setup record;
EXPORT PS_RBQ_CRITDFN;

--BO Search Criteria Definition Field record;
EXPORT PS_RBQ_CRITDFN_FLD;

--BO Search Definition setup record;
EXPORT PS_RBQ_SRCHDFN;

--BO Search Definition Field record;

EXPORT PS_RBQ_SRCHDFN_FLD;


--BO Search Definition Group record;
EXPORT PS_RBQ_SRCHDFN_GRP;


--BO Search Definition Role record;
EXPORT PS_RBQ_SRCHDFN_RL;

--BO Search Role Definition record;
EXPORT PS_RBQ_SRCHRL;


--BO Search Role Definition Field record;
EXPORT PS_RBQ_SRCHRL_FLD;

--Main Field Definition record;
EXPORT PS_RBQ_FLDDFN;

--Record and Field Mapping;
EXPORT PS_RBQ_FLDDFN_REC;

--Role and Field Mapping;
EXPORT PS_RBQ_FLDDFN_RL;


SET OUTPUT PT_UPG_COFIGSRCH_EXPORT.DAT;
SET LOG PT_UPG_COFIGSRCH_EXPORT.LOG;

-- Configurable Search Set up;
EXPORT PS_RB_FILTER_DEFN;

EXPORT PS_RB_FILTER_FIELD;

EXPORT PS_RB_FILTER_RSLT;

                       
SET OUTPUT PT_UPG_DISP_TMPL_EXPORT.DAT;
SET LOG PT_UPG_DISP_TMPL_EXPORT.LOG;

EXPORT PS_RDT_CFG_COMP;
EXPORT PS_RDT_CFG_OPT;
EXPORT PS_RDT_CFG_PAGE;
EXPORT PS_RDT_CFG_SECTION;
EXPORT PS_RDT_CFG_STATE;
EXPORT PS_RDT_CFG_FIELD;
EXPORT PS_RDT_FIELD_REF;
EXPORT PS_RDT_LABEL_REF;
EXPORT PS_RDT_TMPL_OPT_RO;
EXPORT PS_RDT_TMPL_DEFN;
EXPORT PS_RDT_TMPL_COMP;
EXPORT PS_RDT_TMPL_PAGE;
EXPORT PS_RDT_TMPL_SECTN;
EXPORT PS_RDT_TMPL_STATE;
EXPORT PS_RDT_TMPL_FIELD;
EXPORT PS_RDT_TMPL_FLD_ST;
EXPORT PS_RDT_TMPL_OPT;


SET OUTPUT PT_UPG_EMAILTMPL_EXPORT.DAT;
SET LOG PT_UPG_EMAILTMPL_EXPORT.LOG;

--Template Definition Record;
EXPORT PS_RBC_TEMPLAT_DFN;

--Template File Record;
EXPORT PS_RBC_TEMPLAT_FIL;

--Template Token Record;
EXPORT PS_RBC_TEMPLAT_TKN;

--Template Internal Layout Record;
EXPORT PS_RBC_INTLAYOUT;

--Template Package definition Record;
EXPORT PS_RBC_PACKAGE_DFN;

SET OUTPUT PT_UPG_QC_EXPORT.DAT;
SET LOG PT_UPG_QC_EXPORT.LOG;


--Business Object Role Type Setup Definition;
EXPORT PS_BO_ROLE_TYPE;

--Quick Create Template setup record: RBQ_QCTMPL;
EXPORT PS_RBQ_QCTMPL;

--Quick Create Template Field Definition record;
EXPORT PS_RBQ_QCTMPL_FLD;

--Quick Create Template Relationship record;
EXPORT PS_RBQ_QCTMPL_REL;

--Quick Create Template Role record: RBQ_QCTMPL_RL;
EXPORT PS_RBQ_QCTMPL_RL;

--Quick Create Definition setup record;
EXPORT PS_RBQ_QCDFN;

--Quick Create Definition Template record;
EXPORT PS_RBQ_QCDFN_TMPL;

SET OUTPUT PT_UPG_TABLES_EXPORT.DAT;
SET LOG PT_UPG_TABLES_EXPORT.LOG;


---Navigation: Set Up CRM > Business Unit Related > Call Center Definitions;

EXPORT PS_BUS_UNIT_TBL_FS;
EXPORT PS_BUS_UNIT_TBL_RC;
EXPORT PS_BUS_UNIT_RC_DEF;
EXPORT PS_BUS_UNIT_RC_RDT;

--exporting the web profile Authentication Domain Name
REM EXPORT PSWEBPROFNVP

-----********************************
-----** Case History Configuration **
-----********************************
---Navigation: JPMC Utilities > Case History Configuration;

-- Case History configuration Record;
EXPORT PS_PT_CASE_HIST_CF;

-----**************************
-----** Solution State Setup **
-----**************************
----- This Setup controls the Resolution section in the Main Case page.

---Navigation: Set Up CRM > Product Realted > Call Center > Solution Section Configuration:
EXPORT PS_PT_SOLN_STATE;

-----**************************
-----** Lockbox Site Mapping **
-----**************************
----- This Setup table holds the Mapping between CSX Lockbox site values.
EXPORT PS_PT_LBX_SITE_TBL;

EXPORT PS_SET_CNTRL_GROUP;

EXPORT PS_SET_CNTRL_REC;

----- Update Realtionship Cascading Table ;               
EXPORT PS_RC_REL_ACTN_CFG;

EXPORT PS_RBC_PACKAGE_USG;

-----To retain the delivered Verdana fonts instead of the aerial fonts
EXPORT PSOPTIONS;

EXPORT PS_RC_HIST_ACTION;

EXPORT PS_PT_HIST_BIND_CF;

EXPORT PS_RC_HIST_ACT_TRM;

EXPORT PS_RC_PRIORITY_TBL;

-----********************************
-----** Case Status Configuration  **
-----********************************

EXPORT PS_RC_STATUS_TBL WHERE SETID = 'SHARE';

EXPORT PS_PT_CUSTINFN_ROW;

EXPORT PSSIGNONPPC;

EXPORT PS_RB_ACT_RQST;

EXPORT PSPRUHTABPGLT;

EXPORT PSPRSMHPASGPGLT;

EXPORT PS_RB_TSK_PRTY_TBL;

SET OUTPUT PT_UPG_TOOLBAR_EXPORT.DAT;
SET LOG PT_UPG_TOOLBAR_EXPORT.LOG;

---Navigation: Set Up CRM > Common Definitions > Component Configuration > Toolbar > ToolBar Button Definition:

--Toolbar Button Configuration Record;
EXPORT PS_RB_BUTTON_DEFN;

--Toolbar Button Definition Configuration;
EXPORT PS_RB_TOOLBAR_DEFN;

--Toolbar Buttons Record;
EXPORT PS_RB_TOOLBAR_BTNS;

--Toolbar Content Display Record;
EXPORT PS_RB_TOOLBAR_DISP;

EXPORT PS_RB_TOOLBAR_TMZN;

SET OUTPUT PT_UPG_RSEC_EXP.DAT;
SET LOG PT_UPG_RSEC_EXP.LOG;

- Security Group

EXPORT PS_RSEC_FUNCGP_DTL;
EXPORT PS_RSEC_FUNCMSGCAT;
EXPORT PS_RSEC_FUNC_DEFN;
EXPORT PS_RSEC_FUNC_GROUP;
EXPORT PS_RSEC_OBJECTDEFN;
EXPORT PS_RSEC_OBJECT_REL;
EXPORT PS_RSEC_STAT_MENU;

-----********************************
-----** OOTB Delivered Tables *******
-----********************************
SET OUTPUT PT_UPG_OOTB_EXPORT.DAT;
SET LOG PT_UPG_OOTB_EXP.LOG;

EXPORT PS_AUTO_NUM_TBL;
EXPORT PS_BO_NAME_TYPE;
EXPORT PS_BO_REL_CATEGORY;
EXPORT PS_BO_REL_CAT_ITEM;
EXPORT PS_BO_REL_CFG4;
EXPORT PS_BO_REL_TYPE;
EXPORT PS_BO_ROLE_ELEMENT;
EXPORT PS_BO_ROLE_ELE_MAP;
EXPORT PS_BO_ROLE_MAP;
EXPORT PS_BO_ROLE_TYPE_QC;
EXPORT PS_BO_SRCH_FLT;
EXPORT PS_BO_SRCH_GROUP;
EXPORT PS_BO_SRCH_GRP_TYP;
EXPORT PS_BO_TYPE;
EXPORT PS_BO_TYPE_ABE;
EXPORT PS_CM_MAINT_SYSD;
EXPORT PS_CM_PURP_TYPE;
EXPORT PS_CM_TYPE;
EXPORT PS_CM_TYPE_REL;
EXPORT PS_CM_TYPE_ROLE;
EXPORT PS_COUNTRY_TBL;
EXPORT PS_CP_CONSTANT;
EXPORT PS_CR_INSTALL;
EXPORT PS_CR_INSTALL_CON;
EXPORT PS_CR_INSTALL_SEQ;
EXPORT PS_CR_INST_PROMPT;
EXPORT PS_INSTALLATION_BO;
EXPORT PS_PROD_DISP_TMPL;
EXPORT PS_RBB_BPEL_ORMI;
EXPORT PS_RBB_BPEL_STATES;
EXPORT PS_RBB_BPLACT_STES;
EXPORT PS_RBB_TRNSTYP_DFN;
EXPORT PS_RBB_TRNSTYP_DTL;
EXPORT PS_RBB_VIEW_SETUP;
EXPORT PS_RBC_CAT_LASTNUM;
EXPORT PS_RBC_CM_SYSDEFN;
EXPORT PS_RBC_SUBTMPL_DFN;
EXPORT PS_RBC_TEMPLT_CAT;
EXPORT PS_RBC_TEMPLT_TYPE;
EXPORT PS_RBC_TKNGRP_DFN;
EXPORT PS_RBC_TKNGRP_DTL;
EXPORT PS_RBC_USAGE_DFN;
EXPORT PS_RBC_USAGE_DTL;
EXPORT PS_RBF_NAV_SRTY;
EXPORT PS_RBF_ROLE_MAP;
EXPORT PS_RBF_TREECTL_HDR;
EXPORT PS_RBF_TREECTL_NDE;
EXPORT PS_RBG_MAP_QRY_FLD;
EXPORT PS_RBG_MAP_QRY_REC;
EXPORT PS_RBI_CLAIM_STATS;
EXPORT PS_RBT_ACTION;
EXPORT PS_RBT_CATEGORY;
EXPORT PS_RBT_CONFIG_TBL;
EXPORT PS_RBW_ASSET_CATEG;
EXPORT PS_RBW_CAT_DEF_TBL;
EXPORT PS_RBW_REL_CLASS;
EXPORT PS_RBW_REL_CLS_ROL;
EXPORT PS_RB_AAF_CNTXT_BP;
EXPORT PS_RB_ACT_DEFN;
EXPORT PS_RB_ACT_LIST_DFN;
EXPORT PS_RB_APPCLASS_BAS;
EXPORT PS_RB_APPCLASS_EXT;
EXPORT PS_RB_APPCLASS_REG;
EXPORT PS_RB_APPSET_EXT;
EXPORT PS_RB_APP_SRV_DEFN;
EXPORT PS_RB_CHART_SETUP;
EXPORT PS_RB_CHATSSMAP_PG;
EXPORT PS_RB_CHAT_POPUP;
EXPORT PS_RB_CHAT_POP_APP;
EXPORT PS_RB_CHAT_SETUP;
EXPORT PS_RB_CHAT_SET_PG;
EXPORT PS_RB_CHAT_SS_MAP;
EXPORT PS_RB_CLONE_DEFN;
EXPORT PS_RB_CLONE_FLDS;
EXPORT PS_RB_CLONE_REC;
EXPORT PS_RB_CLON_IGNRFLD;
EXPORT PS_RB_COMP_FLD_DFL;
EXPORT PS_RB_COMP_FLD_HDR;
EXPORT PS_RB_CONFIG_EXIT;
EXPORT PS_RB_CREATE_TBL;
EXPORT PS_RB_CTIDEF_JFUNC;
EXPORT PS_RB_CTI_DEF_FUNC;
EXPORT PS_RB_CTI_JS_PARAM;
EXPORT PS_RB_CTI_SYS_DEFN;
EXPORT PS_RB_CTI_SYS_FUNC;
EXPORT PS_RB_CTI_SY_PARAM;
EXPORT PS_RB_EM_ACT_DEFN;
EXPORT PS_RB_ERMS_SYSDEFN;
EXPORT PS_RB_HIST_SOLTION;
EXPORT PS_RB_HIST_SOL_TRM;
EXPORT PS_RB_IBEH_EST_LNG;
EXPORT PS_RB_IBEH_EVENTST;
EXPORT PS_RB_IBEH_EVTSTET;
EXPORT PS_RB_IMP_GLB_TBL;
EXPORT PS_RB_IMP_MAP;
EXPORT PS_RB_IMP_MAP_FLDS;
EXPORT PS_RB_IMP_TEMPLATE;
EXPORT PS_RB_IMP_TMPL_FLD;
EXPORT PS_RB_IMP_TYPE_TBL;
EXPORT PS_RB_MARKET;
EXPORT PS_RB_MOOD_ID;
EXPORT PS_RB_MOOD_LASTNUM;
EXPORT PS_RB_PRCS_NOTIFY;
EXPORT PS_RB_PRESENCE_SYS;
EXPORT PS_RB_PRFL_TGT_TBL;
EXPORT PS_RB_PRIORTY_NAME;
EXPORT PS_RB_PRTY_LASTNUM;
EXPORT PS_RB_RELATION;
EXPORT PS_RB_RELATIONS;
EXPORT PS_RB_RELATION_SEQ;
EXPORT PS_RB_ROLE_WORKER;
EXPORT PS_RB_SDADM_MAIN;
EXPORT PS_RB_SDADM_REPORT;
EXPORT PS_RB_SMRY;
EXPORT PS_RB_SMRY_BINDS;
EXPORT PS_RB_SMRY_GRID;
EXPORT PS_RB_SRCHIDX_HDR;
EXPORT PS_RB_SRCHIDX_LINE;
EXPORT PS_RB_SRCH_PARMS;
EXPORT PS_RB_SRTY_OPER;
EXPORT PS_RB_SRTY_PRIV;
EXPORT PS_RB_STAT_ACT_GRP;
EXPORT PS_RB_STG_SQL_TBL;
EXPORT PS_RB_TARGET_DEFN;
EXPORT PS_RB_TARGT_STRUCT;
EXPORT PS_RB_TD_360SUSET;
EXPORT PS_RB_TD_ACT_CAT;
EXPORT PS_RB_TD_ACT_DFN;
EXPORT PS_RB_TD_CNF_FLDS;
EXPORT PS_RB_TD_CNF_KEY;
EXPORT PS_RB_TD_DYN_ACT;
EXPORT PS_RB_TD_HCNTRYSEC;
EXPORT PS_RB_TEMPLATE;
EXPORT PS_RB_TEMPL_CONCAT;
EXPORT PS_RB_TEMPL_INTFC;
EXPORT PS_RB_TEMPL_RULE;
EXPORT PS_RB_TEMPL_STRUCT;
EXPORT PS_RB_TSK_TYPE;
EXPORT PS_RB_TT_CATEGORY;
EXPORT PS_RB_TT_OPTIONS;
EXPORT PS_RB_TT_START_IND;
EXPORT PS_RB_TXN_DEFN;
EXPORT PS_RB_TXN_MKT;
EXPORT PS_RB_UAD_BTN_DEFN;
EXPORT PS_RB_UAD_MQSTATUS;
EXPORT PS_RB_UAD_VSTATUS;
EXPORT PS_RB_VRTY_MIMES;
EXPORT PS_RB_VRTY_PG_AOPT;
EXPORT PS_RB_VRTY_PG_BOPT;
EXPORT PS_RB_VRTY_PG_CFG;
EXPORT PS_RB_VRTY_PG_RDX1;
EXPORT PS_RB_VRTY_PG_RDX2;
EXPORT PS_RB_VRTY_PG_RDX3;
EXPORT PS_RB_WEBFORM_DEFN;
EXPORT PS_RB_WF_COMP_MAP;
EXPORT PS_RB_WF_RULE;
EXPORT PS_RB_WF_RULE_BIND;
EXPORT PS_RB_WF_RULE_LNG;
EXPORT PS_RB_WF_RULE_PRCS;
EXPORT PS_RB_WF_RULE_RTES;
EXPORT PS_RB_WF_URI_DEFN;
EXPORT PS_RB_WL_GRID_DFN;
EXPORT PS_RB_WRKR_EIP_OPN;
EXPORT PS_RB_XLAT_TBL;
EXPORT PS_RB_XLAT_TBL_LNG;
EXPORT PS_RC_ACTIVITY;
EXPORT PS_RC_ACTIV_TASK;
EXPORT PS_RC_AUDIT_DET;
EXPORT PS_RC_AUDIT_HDR;
EXPORT PS_RC_BP_INVL_ACTN;
EXPORT PS_RC_BP_TRNS_TO;
EXPORT PS_RC_BUS_PROCESS;
EXPORT PS_RC_CASETYPE_TBL;
EXPORT PS_RC_DEFINED_LNG;
EXPORT PS_RC_DEFINED_SRCH;
EXPORT PS_RC_DEFNSRCH_HDR;
EXPORT PS_RC_EMAIL_FORMAT;
EXPORT PS_RC_EMAIL_TOKEN;
EXPORT PS_RC_LAST_NBR_TBL;
EXPORT PS_RC_LAST_NBR_TYP;
EXPORT PS_RC_LINK_CAT_TBL;
EXPORT PS_RC_LINK_GROUP;
EXPORT PS_RC_LINK_GRP_CAT;
EXPORT PS_RC_LINK_KEY_TBL;
EXPORT PS_RC_LINK_TBL;
EXPORT PS_RC_RELATION_TBL;
EXPORT PS_RC_ROW_TBL;
EXPORT PS_RC_SEARCH_GROUP;
EXPORT PS_RC_SG_FIELD;
EXPORT PS_RC_SG_RECORD;
EXPORT PS_RC_TASK;
EXPORT PS_RC_TASK_EVENT;
EXPORT PS_RDH_CODE_DEFN;
EXPORT PS_RDH_MERGE_REG;
EXPORT PS_RDH_MESSAGE;
EXPORT PS_RDM_MBL_DFLT_RL;
EXPORT PS_RDM_MOBILE_DFLT;
EXPORT PS_RDT_TMPL_FAMILY;
EXPORT PS_RDT_TMPL_ICN_RO;
EXPORT PS_RD_CACHE_SYSDAT;
EXPORT PS_RD_FILTER_SET;
EXPORT PS_RD_FILTER_UICHR;
EXPORT PS_RD_PRSN_CONFIG;
EXPORT PS_RD_PRSN_OBJ_CON;
EXPORT PS_RF_INDUSTRY_CFG;
EXPORT PS_RF_IPRDHIST_ACT;
EXPORT PS_RF_IPRDHIST_TRM;
EXPORT PS_RF_IPRD_CFG_ST;
EXPORT PS_RF_MOB_SYNC_OPT;
EXPORT PS_RI_STATUS_TBL;
EXPORT PS_RPM_ACTION_LIST;
EXPORT PS_RPM_SYSTEM_DATA;
EXPORT PS_STATE_TBL;
EXPORT PS_RBC_PACKAG_TMPL;

Friday, November 6, 2015

PS Blog Roll

S.No Owner Name Blog WebSite RSS Feed
0 http://peoplesoftconcept.blogspot.in/2013/06/peoplesoft-set-control-field-concept-and-tableset-sharing.html?m=1 Link
0 http://peoplesoftconcept.blogspot.in/2014/03/peoplesoft-set-control-field.html Link
1 Jiju Vengal http://peoplesofthrms.blogspot.in/ Link
2 Duncan Davies  http://peoplesofttipster.com Link
3 Ganesh Kumaran http://peoplesofthotline360.wordpress.com/ Link
4 Mohammed Hussain http://mypeoplesoftlearnings.blogspot.in Link
5 Yogesh Pandey http://peoplesoftfreetraining.blogspot.co.uk Link
6 Suresh Malneedi http://www.peoplesoftguys.com/ Link
7 Graham http://i-like-trains.blogspot.sg Link
8 David Kurtz http://blog.psftdba.com/ Link
9 Blank http://peoplesoft.in/ Link
10 Alok Bhardwaj http://peoplesoft-oracle.alokbhardwaj.com/ Link
11 Sharath Kumar http://peoplesoft5.blogspot.in/ Link
12 akshata.vm http://learningpeoplesoft-abode.blogspot.in/ Link
13 Learning Peoplesoft http://alllearningresources.blogspot.in/ Link
14 PS Guy http://psguyblog.blogspot.in/ Link
15 Peoplesoft Experts http://peoplesoftexperts.blogspot.in/ Link
16 Jim Marion http://jjmpsj.blogspot.in/ Link
17 Gasparotto http://gasparotto.blogspot.in/ Link
18 Ps Admin http://psadmin.wordpress.com/ Link
19 PS Field Book http://peoplesoftfieldbook.blogspot.co.uk Link
20 PS Code http://codepeoplesoft.blogspot.co.uk/ Link
21 Syncera http://syncera.com.au/blog/ Link
22 Peoplesoft Blog http://rdktech.blogspot.in Link
23 Oracle Java http://www.oracle-java.com/category/2017/PeopleSoft+Enterprise Link
24 Master PS Blog List http://174.37.156.90-static.reverse.softlayer.com/applications/peoplesoft Link
25 Peoplesoft Technology Blog https://blogs.oracle.com/peopletools/ Link
26 Peoplesoft Apps Strategy https://blogs.oracle.com/peoplesoft/ Link
27 Peoplesoft Legislative Updates https://blogs.oracle.com/psftlegupdates/ Link
28 PS Code http://codepeoplesoft.blogspot.co.uk/ Link
29 PS Field Book http://peoplesoftfieldbook.blogspot.co.uk Link
30 Harsha http://harshachowdaryworld.blogspot.in/ Link
31 Mike Harrison http://peoplesoftdevtips.blogspot.in/ Link
32 High Quality Service http://www.peoplesoftservices.net Link
33 System Insights http://systemsinsights.ro/ Link
34 Kovaion Consulting http://www.kovaion.blogspot.co.uk/ Link
35 DanSticka https://sites.google.com/site/dansticka/ Link
36 Tyson Moore http://www.tysonmoore.net/ Link
37 IT Wise Solution http://www.itwisesolutions.com/PsftTraining.html Link
38 Greffins Feather http://leegreffin.wordpress.com/ Link
39 Mani Iyer http://peoplesofthrms.webs.com/apps/blog/ Link
40 PS News http://peoplesoft-news.blogspot.co.uk/ Link
41 Peoplesoft Upgrades http://peoplesoftupgrades.blogspot.co.uk/ Link
42 Peoplesoft Tutorial http://peoplesofttutorial.com/ Link
43 Peoplesoft Development http://pskcw.blogspot.co.uk/ Link
44 Peoplesoft Upgrades http://upgradingpeoplesoft.blogspot.co.uk/ Link
45 Peoplesoft Journal http://www.peoplesoftjournal.com/ Link
46 PS Developer NoteBook http://danielkibler.blogspot.co.uk/ Link
47 Javier Blog http://javier-ps.blogspot.co.uk/ Link
48 Peoplesoft Support http://peoplesoftexperts.blogspot.in Link
49 Peoplesoft Analyst http://www.peoplesoftanalyst.com/ Link
50 Iouri Chadour http://workingscripts.com/ Link
51 Sivaran http://sivaran.blogspot.in/ Link
52 Peoplesoft Solutions http://hariprasadpeoplesoft.blogspot.co.uk/ Link
53 Peoplesoft Tricks http://peoplesoftaware.wordpress.com/ Link
54 Peoplesoft Ismail http://peoplesoftismail.blogspot.in/ Link
55 Peoplesoft Blog http://peoplesoft853.com/ Link
56 Remote PS Admins http://remotepsadmins.com/ Link
57 PS Developer Zone http://www.psoftdev.com/ Link
58 Jblog http://www.jaymathew.com Link
59 PSST http://psst0101.wordpress.com/ Link
60 Peoplesoft Learning http://peoplesoftlearnings.blogspot.in/ Link
61 Srikanth Blogs http://addsrikanth.wordpress.com/ Link
62 PeopleTools Files http://getlevel0.blogspot.in/ Link
63 Srinivas Reddy http://srinivasreddy18.blogspot.in/ Link
64 Capital IT http://capital-it.blogspot.in/ Link
65 Govind Rajan http://peoplesoft2u.blogspot.in/ Link
66 Sri Harsha http://hrmspeoplesoft.blogspot.in/ Link
67 Nandu's World http://nanduworld.blogspot.in/ Link
68 Khander Blogs http://khanderaotech.blogspot.in/ Link
69 Shyam Blog http://peoplesoftwiki.blogspot.in/ Link
70 Jre Consulting http://jreconsulting.blogspot.in/ Link
71 Pawan Mundhra http://pawan-mundhra.blogspot.in/ Link
72 Peoplesoft DBA Blog http://blog.psftdba.com/ Link
73 Digital Eagle http://psst0101.digitaleagle.net/ Link
74 PS Customizer http://www.pscustomizer.com Link
75 Anoop Savio Blog http://ps.mytechspeak.com/ Link
76 Peoplesoft News http://peoplesoft-news.blogspot.in/ Link
77 Peoplesoft Essentials http://amazingpeoplesoft.blogspot.in/ Link
78 PSFT_PP http://psftpp.blogspot.in/ Link
79 Jim Marion http://jjmpsj.blogspot.in/ Link
80 Extra hot PeopleCode http://xtrahot.chili-mango.net/ Link
81 Peoplesoft Wiki http://peoplesoft.wikidot.com/ Link
82 Learning Peoplesoft http://alllearningresources.blogspot.in/ Link
83 Peoplesoft Technical http://learningpeoplesoft-abode.blogspot.in/ Link
84 Peoplesoft SQR http://peoplesoftsqr.com/ Link
85 Peoplesoft Tips http://jmcmahon33.blogspot.in/ Link
86 On the Peoplesoft Road http://gasparotto.blogspot.in/ Link
87 peoplesoftnet http://peoplesoftnet.com/ Link
88 peoplesoft2fusion http://www.peoplesoft2fusion.com/ Link
89 psoftfaq http://www.psoftfaq.com/default.asp Link
90 PsoftSearch http://www.psoftsearch.com/ Link
91 PeopleCode Basics http://peoplecode-basics.blogspot.in/ Link
92 PS Online Training http://peoplesoftonlinetraining.blogspot.in/ Link
93 Application Engine Basics http://applicationenginebasics.blogspot.in/ Link
94 SQR Basics http://structuredqueryreport.blogspot.in/ Link
95 PeopleBook http://peoplesoftbook.blogspot.in/ Link
96 Niraj Patil http://nirajpatil-psadmin.blogspot.in/ Link
97 PS Admin http://psadmin.blogspot.in/ Link
98 Repettas http://repettas.wordpress.com/ Link
99 Peoplesoft Experts http://peoplesoftexperts.blogspot.in/ Link
100 Peoplesoft Answers http://peoplesoft-answers.blogspot.in/ Link
101 DB Tutor http://www.dbtutor.com/ Link
102 Melban Me http://melban.me/ Link

Tuesday, September 23, 2008

Database links : Phase I

I. Database link from Oracle to Oracle

I used OracleXE (Oracle eXprEss) database.
I created a database link from one schema to another schema(all within oracle XE database)

1. A and B are two USERS (schema’s)
2. Employee table is in B
3. In OracleXE, the service name is XE(usually Orcl)

4. Database link from A to B is created as follows :
e.g…

CREATE PUBLIC DATABASE LINK XE@XE
CONNECT TO B
IDENTIFIED BY B’SPASSWORD
USING 'XE'
/

Here link name is XE@XE
First XE is used because there is some constraint regarding global_names so it is same as service name.
Second XE is due to that loopback link should append @XE.

5. select * from Employee@xe@xe
Eno Ename
----------------------
1 AAA
2 BBB



II. Database link from Oracle to MS SQL

Database link from Oracle to other database can be done by
a. Transparent Gateways
b. Connectivity
i. OLEDB
ii. ODBC

I used OBDC to create the link.
Steps to create oracle to MS SQL 2000 is available in
1) http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1

Finally the tnsnames.ora should have something like these(after having a oracle to oracle link and oracle to ms sql server link)
MYDB2DSN= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1523)) (CONNECT_DATA=(SID=MYDB2DSN)) (HS=OK) )


MYSQLSERVERDSN = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)) (CONNECT_DATA=(SID=MYSQLSERVERDSN)) (HS=OK) )

XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
The same holds good for db2 also

References:

1)
http://it.toolbox.com/blogs/oracle-guide/accessing-multiple-xe-databases-from-a-single-machine-6839
2)
http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1
3)
http://www.databasejournal.com/features/oracle/article.php/10893_3442661_2