Categories
Approval Workflow Engine PeopleCode

Migrate AWE Transaction Using Data Mover Script

Here is data mover script that need to migrate Approval Workflow Transaction one environment to another also DEV or UAT to Production.

If you AWE Transaction Completely new of fresh and you want to migrate to production then no backup is not required because your transaction is absent on production, but if you have some changes on AWE Configuration specially Approval Process Setup then it is good idea to take backup of current copy using this script.
Please Change the Transaction Name in this script as Per your requirements

AWE Transaction Configuration Data Mover Export Script

-- Approval Process Definitions AWE Migration
-- Begin export from UAT to PROD
-- If Transaction is Fresh or New then no need to backup in Production else
-- Please Take Backup of Production Copy For Specific Transaction Using this script
-- Transaction Name:
-- Export File Name : ZZ_EXP_EXPORT.dms
-- Import File Name : ZZ_EXP_IMPORT.dms


SET OUTPUT D:\awe_dms_data\ZZ_EXP.dat;
SET LOG E:\awe_dms_data\ZZ_EXP_EXPORT.log;


-- Export Transaction Registry and Configuration
EXPORT PS_EOAW_ADMMON_CFG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_MONDIS_DTL WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_MONDIS_HDR WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_USRMON_CFG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_USRMON_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TXN WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TXN_CFG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TXN_LBL WHERE EOAWPRCS_ID IN ('ZZ_EXP');
Export PS_EOAW_TXN_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TXN_LVL WHERE EOAWPRCS_ID IN ('ZZ_EXP');


--Export Transaction Notifications
EXPORT PS_EOAW_NOTIFY WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_NOTIFYDEF WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_NOT_USER WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_NOT_USRDEF WHERE EOAWPRCS_ID IN ('ZZ_EXP');

 
-- Export User Lists and Approver User List
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LIST WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');

EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');
EXPORT PS_EOAWUSER_LNG WHERE EOAWUSER_LIST_ID IN ('ZZ_EXP');

-- Export Process Stage Path Step Definitions
EXPORT PS_EOAW_IDS WHERE EOAWCOUNTERNAME IN ('ZZ_EXP_XREF');
EXPORT PS_EOAW_PATH WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_PATH_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_PRCS WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_PRCS_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_STAGE WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_STEP WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_STEP_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_STG_LNG WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TIMEOUT WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_TIMEOUTDEF WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_AUTH WHERE EOAWPRCS_ID IN ('ZZ_EXP');
EXPORT PS_EOAW_AUTH_DTL WHERE EOAWPRCS_ID IN ('ZZ_EXP');

-- Export Criteria Related Definitions
EXPORT PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%');
-- EXPORT PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%2014-09-16%'); -- With Effective Date Criteria

EXPORT PS_EOAWCRTA_LNG WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%');
-- EXPORT PS_EOAWCRTA_LNG WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%2014-09-16%'); -- With Effective Date Criteria

EXPORT PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%');
-- EXPORT PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%2014-09-16%'); -- With Effective Date Criteria

EXPORT PS_EOAWCRTA_RECLNG WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%');
-- EXPORT PS_EOAWCRTA_RECLNG WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%2014-09-16%'); -- With Effective Date Criteria

EXPORT PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%');
-- EXPORT PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE ('%ZZ_EXP%2014-09-16%'); -- With Effective Date Criteria


-- Export NEM (Notification and Escalations)
EXPORT PS_EOAWNEM;
EXPORT PS_EOAWNEM_EMAIL;
EXPORT PS_EOAWNEM_EVENTS;

-- Export EMC (Email Collaboration)
-- EXPORT PS_EOAWEMCLTLN_LNG;
-- EXPORT PS_EOAWEMC_LYT_HDR;
-- EXPORT PS_EOAWEMC_LYT_LIN;
-- EXPORT PS_EOAWEMC_MSGHDR;
-- EXPORT PS_EOAWFIELD_LIST;
-- EXPORT PS_EOAWFRMINPT_HDR;
-- EXPORT PS_EOAWFRMINPT_LIN;
-- EXPORT PS_EOAWXLAT_SYMBOL;

-- Export EOAW HTML Email Approvals 
-- EXPORT PS_EOAW_EML_CFG_DT WHERE EOAWPRCS_ID IN (' ');
-- EXPORT PS_EOAW_EML_CFG_LN WHERE EOAWPRCS_ID IN (' ');
-- EXPORT PS_EOAW_EML_TMPL WHERE EOAWPRCS_ID IN (' ');

-- Export Workflow Generic Template 
EXPORT PS_WL_TEMPLATE_GEN WHERE WL_TEMPLATE_ID LIKE 'ZZ_EXP%';
EXPORT PS_WL_TEMPL_GEN_TK WHERE WL_TEMPLATE_ID LIKE 'ZZ_EXP%';

-- Export Workflow Transaction Setup Tables
EXPORT PS_EO_TRANSACTIONS WHERE TRANSACTION_NAME IN ('ZZ_EXP');
EXPORT PS_HCM_EO_TXN WHERE TRANSACTION_NAME IN ('ZZ_EXP');

-- Export Self Services Tables for Workflow Config with CI Setup
EXPORT PS_WF_HR_TRANS WHERE TRANSACTION_NAME IN ('ZZ_EXP');
EXPORT PS_WF_HR_TRANS_NOT WHERE TRANSACTION_NAME IN ('ZZ_EXP');
EXPORT PS_SS_TRANS_CI_DTL WHERE TRANSACTION_NAME IN ('ZZ_EXP');

Data Mover Import Script

-- Approval Process Definitions AWE Migration
-- Begin import
-- Transaction Name:
-- Export File Name : ZZ_EXP_EXPORT.dms
-- Import File Name : ZZ_EXP_IMPORT.dms

SET INPUT D:\awe_dms_data\ZZ_EXP.dat;
SET LOG E:\awe_dms_data\ZZ_EXP_IMPORT.log;

SET UPDATE_DUPS;
IMPORT *;

For  Import we are using UPDATE_DUPS  because  it will automatically updates the duplicate with new one. else data mover produce Unique Constraint Violation Error.

Download Script

ZZ_EXP_EXPORT

ZZ_EXP_IMPORT

Hope this helps 🙂

One reply on “Migrate AWE Transaction Using Data Mover Script”

Did you try using the ADS method to migrate the AWE configuration instead of just the Data Mover. You should be able to create a new data set for the AWE tables.

Leave a Reply

Your email address will not be published. Required fields are marked *