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