2009 年 7月 27 日随笔档案 - Kevin's Blogy

Check Email Address and Type on a PeopleSoft Grid

摘要： What I would like to accomplish is every time the user adds a new email address i would want to check for the following:1. Check for blank email type2. Edit to check for '@' character3. Check if email... 阅读全文

posted @ 2009-07-27 16:13 Kevin's Blogy 阅读(405) 评论(0) 推荐(0)

Traversing the Dept Security tree

摘要： We can use the connect by prior function provided by Oracle to traverse the Dept security Tree . Suppose an Organization has 7 levels in Dept tree i.e. 1 to 7 .We want to traverse the dept tree from l... 阅读全文

posted @ 2009-07-27 14:49 Kevin's Blogy 阅读(325) 评论(0) 推荐(0)

Database Table Space Statistics

摘要： An SQL to help gathering storage tablespace statistics. The SQL will list all tablespace names in a particular database along with available, used and percent used storage space in MB.SELECT a.tables... 阅读全文

posted @ 2009-07-27 13:25 Kevin's Blogy 阅读(200) 评论(0) 推荐(0)

Permission List's Accessibility

摘要： 1. Pages that could be accessed by a specific permission list.SELECT b.menuname, b.barname, b.baritemname, b.pnlitemname AS pagename, c.pageaccessdescr, DECODE (b.displayonly, 0, 'No', 1, 'Yes') AS di... 阅读全文

posted @ 2009-07-27 13:18 Kevin's Blogy 阅读(328) 评论(0) 推荐(0)

Add Leading Characters to a Value or Field

摘要： A function to facilitate the addition of a leading character to a field value. The function takes three parameters:- &LEADCHAR: The character you want to append to your value.- &FIELDZISE: The... 阅读全文

posted @ 2009-07-27 13:10 Kevin's Blogy 阅读(205) 评论(0) 推荐(0)

A List of Pages a Peoplesoft Role Name can Access

摘要： A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page.... 阅读全文

posted @ 2009-07-27 13:03 Kevin's Blogy 阅读(257) 评论(0) 推荐(0)

Dynamic Prompt Table Depending on a Drop Down Value

摘要： how to dynamically assign a prompt table depending on a drop down value (see image below)The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field ... 阅读全文

posted @ 2009-07-27 11:30 Kevin's Blogy 阅读(365) 评论(0) 推荐(0)

PeopleSoft XML Publisher

摘要： This article explains how to create XML Publisher also called BI Publisher reports in PeopleSoft. XML Publisher is the only Reporting platform in the Fusion Application. Before we talk about how to cr... 阅读全文

posted @ 2009-07-27 11:02 Kevin's Blogy 阅读(668) 评论(0) 推荐(2)

To create POPUP menu

摘要： To create popupmenu.Create new menu as follows.Select popup opion.-Click on define transfer.Assign any menu, component, page (comp item), click the check box at bottom.Click ok then save the menu.Then... 阅读全文

posted @ 2009-07-27 10:38 Kevin's Blogy 阅读(328) 评论(0) 推荐(0)

Debugging Functionality in Peoplesoft

摘要： Open Configuration Manager -> Profile ->Create.• Select Connection Type as Application Server.• Enter Application Server Name• Machine Name or IP Address should be your machine... 阅读全文

posted @ 2009-07-27 10:14 Kevin's Blogy 阅读(295) 评论(0) 推荐(1)

2009年7月27日