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

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 🙂