Peoplesoft. This Blog is no longer actively managed. Tuesday, March 13, 2012. AWE Tables and Migration script. AWE 9.0 Application Tables. One of the best and easy way to find the PeopleSoft Query tables is to know the fact that the PeopleSoft Query tables follow a naming convention, which is table names start with PSQRY. The SQL that you see is generated on the basis of all these tables rather than being stored in one column in one table.
Last updated on OCTOBER 21, 2019
- Setting up Approval Process in PeopleSoft Approval Workflow Engine (AWE) Being part of an organization which houses its HRIS system in PeopleSoft, we as an employee do various Self Service transactions like submit a planned leave request for a week or so which then goes to manager for their approval and upon final approval the database changes.
- (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.
Applies to:
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. Call of duty modern warfare keygen download. Assumption made is these rows are slowing down performance.
Solution
To view full details, sign in with your My Oracle Support account. |
Don't have a My Oracle Support account? Click to get started! |
Below are the list of tables used in PeopleSoft Financial modules
- 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
Peoplesoft Awe Workflow Tables
- PS_RECV_HDR
- PS_RECV_LN_SHIP
- PS_RECV_LN_ACCTG
- 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. This Blog is no longer actively managed. Tuesday, March 13, 2012. AWE Tables and Migration script. AWE 9.0 Application Tables. One of the best and easy way to find the PeopleSoft Query tables is to know the fact that the PeopleSoft Query tables follow a naming convention, which is table names start with PSQRY. The SQL that you see is generated on the basis of all these tables rather than being stored in one column in one table.
Last updated on OCTOBER 21, 2019
- Setting up Approval Process in PeopleSoft Approval Workflow Engine (AWE) Being part of an organization which houses its HRIS system in PeopleSoft, we as an employee do various Self Service transactions like submit a planned leave request for a week or so which then goes to manager for their approval and upon final approval the database changes.
- (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.
Applies to:
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. Call of duty modern warfare keygen download. Assumption made is these rows are slowing down performance.
Solution
To view full details, sign in with your My Oracle Support account. |
Don't have a My Oracle Support account? Click to get started! |
Below are the list of tables used in PeopleSoft Financial modules
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
Peoplesoft Awe Workflow Tables
- PS_RECV_HDR
- PS_RECV_LN_SHIP
- PS_RECV_LN_ACCTG
- 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 Approval Workflow Engine
- PS_ITEM
- PS_ITEM_ACTIVITY
- PS_ITEM_DST
- PS_CUST_DATA
- PS_CUST_AGING
- PS_CUSTOMER
