Peoplesoft Awe Tables

Posted on by

  1. Awe In Peoplesoft
  2. Peoplesoft 9.2 Awe Tables
  3. Peoplesoft Awe Tables Ideas
  4. Peoplesoft Approval Workflow Engine
  5. Peoplesoft Awe Tables 2020
Peoplesoft

Last updated on OCTOBER 21, 2019

AWE Tables and Migration script. AWE 9.1 Application Tables:- Export Transaction Registry Export EOAWADMMONCFG. Complete List of PeopleSoft Tables at 05:56.

Peoplesoft Awe Tables

Applies to:

  • (a MAX is really all that is needed). I usually populate this with a value that is a bit larger than the current maximum value for the entire table. 2) Check your cross reference table (defined in the registry) for the same field. 3) Confirm the registry and approval process are completely populated and identical between the two environments.
  • Peoplesoft AWEhcmdelegationframework 1. PeopleSoft Red Paper Series Delegation Framework for HCM v. 9.0 By: Robbin Velayedam & Renli Wang HCM Shared Components Team February 2007INCLUDING:. Understanding the Delegation Framework for HCM v. 9.0. Registering self service transactions in the Delegation Framework. Implementing and maintaining the Delegation Framework.
  • This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel free to add to or correct the list, this is a wiki page, so jump in! PeopleSoft Projects.
PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.52 [Release 8.4]
Information in this document applies to any platform.

Goal

How best to approach the Archiving of the Approval Framework (AWE) row in the USERINST (PS_PTAFAW_USERINST, for 9.0 or PS_EOAW_USERINST for 9.1 Applications)?
Noticing performance issues with AWE and discovered 1,700,000 rows of data. Assumption made is these rows are slowing down performance.

Solution

Peoplesoft Awe Tables

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Awe In Peoplesoft

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

Peoplesoft 9.2 Awe Tables

AWE Transaction Configuration Data Mover Export Script

Data Mover Import Script

Peoplesoft Awe Tables Ideas

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.

Peoplesoft Approval Workflow Engine

Download Script

Peoplesoft Awe Tables 2020

Hope this helps 🙂