Peoplesoft AWE Workflow configuration DMS scripts

Peoplesoft AWE Workflow configuration and setup tables. Ver 9.0

User the following scripts to move the AWE configuration / setup data from the one instance to another instance.

Note :- add where clause if you need to move only configuration specific to particular AWE transactions.

Export script

-- "Register Transaction"
EXPORT PS_PTAFAW_TXN;
EXPORT PS_PTAFAW_TXN_LNG;
EXPORT PS_PTAFAW_TXN_LBL;
EXPORT PS_PTAFAW_TXN_LVL;

-- "Approvals > Workflow Transaction "
EXPORT EO_TRANSACTIONS;
EXPORT EO_TRANS_LNG;

-- "Configure Transactions"
EXPORT PS_PTAFAW_NOTIFY;
EXPORT PS_PTAFAW_NOT_USER;
EXPORT PS_PTAFAW_TXN_CFG;

-- "Setup Process Definitions"
EXPORT PS_PTAFAW_PATH;
EXPORT PS_PTAFAW_PATH_LNG;
EXPORT PS_PTAFAW_PRCS;
EXPORT PS_PTAFAW_PRCS_LNG;
EXPORT PS_PTAFAW_STAGE;
EXPORT PS_PTAFAW_STG_LNG;
EXPORT PS_PTAFAW_STEP;
EXPORT PS_PTAFAW_STEP_LNG;

-- "Criteria Definitions"
EXPORT PS_PTAFCRTA;
EXPORT PS_PTAFCRTA_REC;
EXPORT PS_PTAFCRTA_VAL;

-- "Maintain User Lists"
EXPORT PS_PTAFUSER_LIST;
EXPORT PS_PTAFUSER_LNG;
-- "Generic Templates"
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PS_WL_TEMPL_GEN_RS;

 

4 comments:

  1. Anonymous said,

    Hi, could you post the same for version 9.1?

    on October 6, 2010 at 8:09 AM  


  2. Jimmy said,

    I have the same question here, can the same list be used 9.1 ?

    Thanks in advance

    on December 3, 2010 at 5:46 PM  


  3. Anonymous said,

    Has anyone compiled the list for 9.1 tools 8.50?

    on January 13, 2011 at 11:47 AM  


  4. Anonymous said,

    Hi,

    I did for Financials 9.1 and PT 8.50, just replace PTAF in the table name with EOAW.

    Juras

    on January 27, 2011 at 3:04 PM