- Peoplesoft Workflow Transaction Tables Templates
- Peoplesoft Workflow Configuration
- Peoplesoft Workflow Transaction Tables Template
- Peoplesoft Workflow Tables
Difference between jira and azure devops. Last updated on DECEMBER 02, 2019
Applies to:
Transaction Tables The following chart shows a Transaction Table example: Department Table EMPLID Name Effective Date Action Department EMP0003 Kim Rogers Transfer Public Affairs EMP0003 Kim Rogers Data Change Finance Transaction tables store data about day-to-day business activities. Understanding the PeopleSoft Online Help and PeopleBooks The PeopleSoft Online Help is a website that enables you to view all help content for PeopleSoft Applications and PeopleTools. The help provides standard navigation and full-text searching, as well as context-sensitive online help for PeopleSoft users. PeopleSoft Hosted Online Help. NOTE: These Tables do not contain any information that you could not otherwise find using files delivered with the PeopleSoft System. Page 1 of 4 RECORD (TABLE) NAME RECORD (TABLE) DEFINATION & DESCRIPTION VENDORS VENDOR Vendor Header Table - Main Vendor table which contains many important fields related to the vendor. Vendor ID, Name.
PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 9.1 to 9.1 [Release 9]PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Promotions Management - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.Symptoms
The following lists describe the indexes recommended for each Cross Reference (XREF) Table and the Target associated with it. Find the Product, and AWE Process ID, and create the Indexes.
The following example is for the 9.1 Applications, which use Approval Framework (AWE) fields prefaced with 'EOAW'. For the 9.0 Applications, these same AWE fields are prefaced with 'PTAF'.
Each Application released their distinct cross reference tables with one index for the primary AWE keys by default. The default index created for the AWE keys is on these fields:
(EOAWTHREAD_ID, EOAWPRCS_ID)
Besides this basic index, additional indexes are generally needed for specific application transactions as well.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
Don't have a My Oracle Support account? Click to get started! |
| Symptoms |
| Changes |
| Cause |
| Solution |
| Recommended Cross Reference AWE Indexes: |
| FSCM 9.1 |
| HCM 9.1 |
| ELM 9.1 |
| Implementation Instructions: |
Tables in Asset Management
List of Tables that gets populated when a transaction is done in Asset Management
1. Asset Creation
When you create an Asset for the First time the details will be update in the below tables
- PS_ASSET
- PS_BOOK
- PS_COST
- PS_ASSET_ACQ_DET
- PS_ASSET_LOCATION
- PS_OPEN_TRANS
When the depreciation calculation process is run and completed then the data is update in below tables
- PS_DEPRECIATION (Inserted)
- PS_OPEN_TRANS (a field data is updated)
- PS_BOOK (few fields will be updated)
When you run the Create Accounting entry process below tables will be affected
- PS_DIST_LN
- PS_OPEN_TRANS
Below tables will be updated when you run the depreciation close process
Peoplesoft Workflow Transaction Tables Templates
- PS_DIST_LN
- PS_COST
- PS_OPEN_TRANS
- PS_DEPRECIATION
- PS_DIST_LN
- PS_RETIREMENT
- PS_INTFC_FIN (if retired through Disposal Worksheet)
- PS_OPEN_TRANS
- PS_DEPRECIATION
- PS_DIST_LN
- PS_COST
- PS_BOOK_HIST
- PS_OPEN_TRANS
- PS_DEPRECIATION
- PS_DIST_LN
Peoplesoft Workflow Configuration
8. Interface loading/Excel to CIPeoplesoft Workflow Transaction Tables Template
Peoplesoft Workflow Tables
- PS_INTFC_FIN
- PS_INTFC_PHY_A
- PS_INTFC_PHY_B