2008年8月8日

摘要： PSOPRDEFN - UserIds created. PSCLASSDEFN - Permission List definition. PSROLEDEFN - Role Definition table PSAUTHITEM - Menus, Components and Pages attached to a permission list. PSROLEUSER - Contains ... 阅读全文

摘要： start with .. connect by clause can be used to select data that has a hierarchical relationship. Usually, it is some sort of parent child relationship like supervisor and an employee. Let’s assume we ... 阅读全文

摘要： The Oracle SQL below compares table1 that has 2 key fields and 3 regular fields. Note: For the SQL below to work, your password needs to be the same in both environments. If not, then a connection usi... 阅读全文

摘要： A quick function that will allow you to verify if a specific vendor has any pending transaction(s). Function vendor_pnding_transactions(); &VENDOR = VENDOR_ID; SQLExec("select 'X' from ps... 阅读全文

摘要： In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file. Navigate to th... 阅读全文

摘要： 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 f... 阅读全文

摘要： General Ledger Tables PS_LEDGER: The general ledger data table. PS_JRNL_HEADER: Stores general ledger journal header data. PS_JRNL_LN: Stores general ledger journal line data. ps_combo_rule_tbl: Store... 阅读全文

摘要： The sql will identify duplicate objects in different application designer projects to eliminate duplicate work by developers. You will find the SQL very handy during the analysis phase of a peoplesoft... 阅读全文

摘要： PeopleSoft stores object definitions types such as Record, Field and SQL definitions as numbers in PeopleTools meta-tables. Here is a list of what each number means with respect to its definition. Def... 阅读全文

摘要： The function is ConvertCurrency to convert currency from US dollar to any other currency on the PS_RT_RATE_TBL . ConvertCurrency(amt, currency_cd, exchng_to_currency, exchng_rt_type, effdt, converted... 阅读全文