PeopleSoft AWE Open Data Conversion Errors for Requisition. For doing data conversion from PeopleSoft 8.9 Instance to PeopleSoft 9.1 Instance as part of upgrade, few points should be considered with respect to AWE data migration in 9.1 instances for Requisition. Cleanmymac 2 license key filmora. This table holds the Approval Process definition properties. Fable 3 no cd patch. Peoplesoft. This Blog is no longer actively managed. Tuesday, March 13, 2012. AWE Tables and Migration script. AWE 9.0 Application Tables.
- Entries in worklist are stored in database tables. You define the structure content of these tables by creating worklist records. The worklist record determines which fields of information the system stores for each work item and in what order the work items appear. When a business event routes a work item to a worklist, it adds a row to the table.
- The following is a list of some of the key campus solutions records grouped by functional area. This is by no means a complete list, but hopefully it proves to be a handy reference.
1. Accounts Payable
- PS_VOUCHER
- PS_VOUCHER_LINE
- PS_DISTRIB_LINE
- PS_PYMNT_VCHR_XREF
- PS_PAYMENT_TBL
- PS_VCHR_ACCTG_LINE
- PS_PYMNT_ADVICE
- PS_VCHR_PPAY_XREF
- PS_INTFC_FIN
- PS_INTFC_PHY_A
- PS_ASSET
- PS_BOOK
- PS_COST
- PS_DEPRECIATION
- PS_BOOK_HIST
- PS_DIST_LN
- PS_ASSET_ACQ_DETAIL
- PS_ASSET_LOCATION
- PS_OPEN_TRANS
- PS_DEPR_RPT
- PS_ASSET_NBV_TBL
- PS_RETIREMENT
- PS_JRNL_LN
- PS_JRNL_HEADER
- PS_LEDGER
- PS_PO_HDR
- PS_PO_LINE
- PS_PO_LINE_DISTRIB
- PS_PO_LINE_SHIP
PeopleSoft AWE Open Data Conversion Errors for Requisition. For doing data conversion from PeopleSoft 8.9 Instance to PeopleSoft 9.1 Instance as part of upgrade, few points should be considered with respect to AWE data migration in 9.1 instances for Requisition. Cleanmymac 2 license key filmora. This table holds the Approval Process definition properties. Fable 3 no cd patch. Peoplesoft. This Blog is no longer actively managed. Tuesday, March 13, 2012. AWE Tables and Migration script. AWE 9.0 Application Tables.
- Entries in worklist are stored in database tables. You define the structure content of these tables by creating worklist records. The worklist record determines which fields of information the system stores for each work item and in what order the work items appear. When a business event routes a work item to a worklist, it adds a row to the table.
- The following is a list of some of the key campus solutions records grouped by functional area. This is by no means a complete list, but hopefully it proves to be a handy reference.
1. Accounts Payable
- PS_VOUCHER
- PS_VOUCHER_LINE
- PS_DISTRIB_LINE
- PS_PYMNT_VCHR_XREF
- PS_PAYMENT_TBL
- PS_VCHR_ACCTG_LINE
- PS_PYMNT_ADVICE
- PS_VCHR_PPAY_XREF
- PS_INTFC_FIN
- PS_INTFC_PHY_A
- PS_ASSET
- PS_BOOK
- PS_COST
- PS_DEPRECIATION
- PS_BOOK_HIST
- PS_DIST_LN
- PS_ASSET_ACQ_DETAIL
- PS_ASSET_LOCATION
- PS_OPEN_TRANS
- PS_DEPR_RPT
- PS_ASSET_NBV_TBL
- PS_RETIREMENT
- PS_JRNL_LN
- PS_JRNL_HEADER
- PS_LEDGER
- PS_PO_HDR
- PS_PO_LINE
- PS_PO_LINE_DISTRIB
- PS_PO_LINE_SHIP
- PS_PO_HDR_STG
- PS_PO_ITM_STG
- PS_PO_DISTRIB_STG
- PS_RECV_HDR
- PS_RECV_LN_SHIP
- PS_RECV_LN_ACCTG
Peoplesoft Awe Tables Vs
- PS_VENDOR
- PS_VENDOR_ADDR
- PS_VENDOR_LOC
- PS_VENDOR_PAY
- PS_VENDOR_INVOICE
- PS_VENDOR_CNTCT
- PS_VNDR_BANK_ACCT
- PS_VNDR_IBANK_ACCT
- PS_VNDR_WTHD_JUR
Peoplesoft Awe Workflow Tables
7. Accounts Receivables- PS_ITEM
- PS_ITEM_ACTIVITY
- PS_ITEM_DST
- PS_CUST_DATA
- PS_CUST_AGING
- PS_CUSTOMER
Peoplesoft Awe Tables 2020
8. BillingPeoplesoft Awe Tables Definition
So, here is the list of tables that need to be cleaned up, if ever this requirement arises:
1. GP_ABS_SS_DAT
2. GP_ABS_SS_STA
3. GP_ABSSS_V_XREF
4. EOAW_USERINST
5. EOAW_STEPINST
If the above requirement arises for Time and Labor, the following list of impacted tables need to be cleaned up:
Reported Time Approval:
1. TL_APP_HDR
2. TL_APP_RPT_LINE
3. TL_APP_RPTD_XRF
4. EOAW_USERINST
5. EOAW_STEPINST
Payable Time Approval;
1. TL_APP_PAY_HDR
2. TL_APP_PAY_LINE
3. TL_APP_PAY_XRF
4. EOAW_USERINST
5. EOAW_STEPINST
Note that this post only lists the tables involved in the AWE processes of PeopleSoft Absence Management and Time and Labor. Ensure that correct SQL scripts are written and tested, prior to executing the actual cleanup. If necessary, consult support.oracle.com where there is good amount of documentation on this subject, as well as sample delete scripts.