PeopleSoft AWE Migration Scripts

                                          Export script from the Source database

SET OUTPUT c:\temp\AWESetup.dat;
SET LOG c:\temp\AWESetup_export.log;

-- "Register Transaction"
 EXPORT PS_EOAW_TXN WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LBL WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
 EXPORT PS_EOAW_TXN_LVL WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
-- "Configure Transactions"
EXPORT PS_EOAW_NOTIFY WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
EXPORT PS_EOAW_NOT_USER WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';
EXPORT PS_EOAW_TXN_CFG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL';

-- "Setup Process Definitions"
EXPORT PS_EOAW_PRCS WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL'  AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PRCS_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_TIMEOUTDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_NOTIFYDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_NOT_USRDEF WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STAGE WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STG_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PATH WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_PATH_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_TIMEOUT WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STEP WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';
EXPORT PS_EOAW_STEP_LNG WHERE EOAWPRCS_ID = 'N_BI_INVOICE_APPROVAL' AND EFFDT = '26-AUG-12';

-- "Criteria Definitions"
EXPORT PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_LNG WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_RECLNG WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';
EXPORT PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE '%BI%2012-08-26%';

-- "Maintain User Lists"
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');
EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');
EXPORT PS_EOAW_UL_ATTRIB WHERE EOAWUSER_LIST_ID IN ('N_BI_FIN_OFF','N_BI_FIN_CREDIT_APPRV_OFF','N_BI_FIN_APPRV_OFF','N_BI_DEPT_APPRV_OFF','N_BI_DEPT_CREDIT_APPRV_OFF');

-- "Generic Templates"
EXPORT PS_WL_TEMPLATE_GEN WHERE WL_TEMPLATE_ID LIKE 'Invoice%';
EXPORT PS_WL_TEMPL_GEN_TK WHERE WL_TEMPLATE_ID LIKE 'Invoice%';

EXPORT PS_WL_TEMPL_GEN_RS WHERE WL_TEMPLATE_ID LIKE 'Invoice%';


                                     Import Script into  Target Database

SET INPUT C:\temp\AWESetup_Billing.dat;
SET LOG AWESetup_billing.log;

REM  Register Transaction;
IMPORT EOAW_TXN;
IMPORT EOAW_TXN_LNG;
IMPORT EOAW_TXN_LBL;
IMPORT EOAW_TXN_LVL;

REM Configure Transactions;
IMPORT EOAW_NOTIFY;
IMPORT EOAW_NOT_USER;
IMPORT EOAW_TXN_CFG;

rem Setup Process Definitions;
IMPORT EOAW_PRCS;
IMPORT EOAW_PRCS_LNG;
IMPORT EOAW_TIMEOUTDEF;
IMPORT EOAW_NOTIFYDEF;
IMPORT EOAW_NOT_USRDEF;
IMPORT EOAW_STAGE;
IMPORT EOAW_STG_LNG;
IMPORT EOAW_PATH;
IMPORT EOAW_PATH_LNG;
IMPORT EOAW_TIMEOUT;
IMPORT EOAW_STEP;
IMPORT EOAW_STEP_LNG;

rem Criteria Definitions;
IMPORT EOAWCRTA;
IMPORT EOAWCRTA_LNG;
IMPORT EOAWCRTA_REC;
IMPORT EOAWCRTA_RECLNG;
IMPORT EOAWCRTA_VAL;

rem Maintain User Lists;
IMPORT EOAWUSER_LIST;
IMPORT EOAWUSER_LNG;
IMPORT EOAW_UL_ATTRIB;

REM GENERIC TEMPALTES;
IMPORT PS_WL_TEMPLATE_GEN;
IMPORT PS_WL_TEMPL_GEN_TK;
IMPORT PS_WL_TEMPL_GEN_RS;