随笔档案「2008年8月8日」：Manipulating Data on a Grid: Scroll Peop... - Kevin's Blogy

Manipulating Data on a Grid: Scroll PeopleCode

摘要： When you have a grid that is filled with data; data that you don't want. How do you clear it out and then fill it with the data set that you do want? Well, here are the simple steps to do just that. ... 阅读全文

posted @ 2008-08-08 17:21 Kevin's Blogy 阅读(438) 评论(0) 推荐(0)

Read a File Using File Layout and insert data into a record

摘要： Local File &MYFILE; Local Record &REC; Local array of string &ARRAY; Local string &FILE_DIRECTORY, &FileName; &FileName = "MY_FILE_NAME.txt"; &FILE_DIRTORY = "/MYDIRECTORY/" /*open file for reading*/... 阅读全文

posted @ 2008-08-08 17:05 Kevin's Blogy 阅读(377) 评论(0) 推荐(0)

Security Tables

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

posted @ 2008-08-08 16:41 Kevin's Blogy 阅读(230) 评论(0) 推荐(0)

START WITH and CONNECT BY in Oracle

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

posted @ 2008-08-08 16:13 Kevin's Blogy 阅读(323) 评论(0) 推荐(0)

Compare Data from the Same Table in two Different Environments

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

posted @ 2008-08-08 15:30 Kevin's Blogy 阅读(308) 评论(0) 推荐(0)

Vendor Pending Transactions

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

posted @ 2008-08-08 15:24 Kevin's Blogy 阅读(254) 评论(0) 推荐(0)

Trace Application Engine Processes Using Process Definitions

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

posted @ 2008-08-08 15:21 Kevin's Blogy 阅读(265) 评论(0) 推荐(0)

PeopleSoft PeopleTools Meta-Tables

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

posted @ 2008-08-08 15:19 Kevin's Blogy 阅读(454) 评论(0) 推荐(0)

PeopleSoft Financials Tables

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

posted @ 2008-08-08 14:58 Kevin's Blogy 阅读(483) 评论(0) 推荐(0)

Migration: Find Duplicate Objects in Application Desinger Projects

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

posted @ 2008-08-08 14:55 Kevin's Blogy 阅读(229) 评论(0) 推荐(0)

PeopleSoft Object Types Definitions

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

posted @ 2008-08-08 14:39 Kevin's Blogy 阅读(302) 评论(0) 推荐(0)

Convert From One Currency to Another

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

posted @ 2008-08-08 14:26 Kevin's Blogy 阅读(339) 评论(0) 推荐(0)

Unlock PeopleSoft Objects All at Once

摘要：

阅读全文

posted @ 2008-08-08 11:25 Kevin's Blogy 阅读(208) 评论(0) 推荐(0)