Application Developer/Engine - 随笔分类 - Kevin's Blogy

Query看不到的问题！

摘要：1. Make sure that this table exists in the Query Access Manager under the appropiate tree name.(People Tools - Security - Query security - Query Access Manager).If not, add the table.2. Run Query Acce... 阅读全文

posted @ 2010-11-11 19:03 Kevin's Blogy 阅读(271) 评论(0) 推荐(0)

Display pdf file , image, website on peoplesoft page using html area

摘要：inser an html area in page then copy the following code into it....then open the same page in PIA.<html><body><iframe src ="\\psserver\temp\purchase.pdf" width="700" height="500"> &l... 阅读全文

posted @ 2010-03-15 11:56 Kevin's Blogy 阅读(627) 评论(1) 推荐(0)

PeopleCode Run-Time Error

摘要：自己开发了个Application Engine，一个Section有两个steps，Step1是update statement，Step2 run一个shell command，同步模式。然后程序能跑出结果，但是No-success，报错信息：Think-time PeopleCode event (Exec), but a SQL update has occ urred in the c... 阅读全文

posted @ 2009-10-28 19:54 Kevin's Blogy 阅读(250) 评论(0) 推荐(0)

Call Exec in PeopleCode

摘要：我想在Application Engine里加一段调用命令行的代码，All PeopleCode is executed on the application server. So if you're calling an interactive application, you receive an error. There shouldn't be any application intera... 阅读全文

posted @ 2009-09-23 18:27 Kevin's Blogy 阅读(424) 评论(1) 推荐(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)

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 阅读(255) 评论(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)

Application Engine Actions

摘要：Specifying SQL ActionsReUse Statement PropertyThe ReUse Statement property is available for all SQL action types (SQL, Do When, Do While, Do Until, Do Select). You use the ReUse Statement property to ... 阅读全文

posted @ 2009-07-24 14:17 Kevin's Blogy 阅读(487) 评论(0) 推荐(0)

Call Component Interface from AE

摘要：Local File &Source, &fileLog;Local string &strLine, &FilePath, &EmplStatus;Local array of string &Item;Local number &Line, &SucCNT, &FailCNT;Local ApiObject &oS... 阅读全文

posted @ 2009-07-10 15:11 Kevin's Blogy 阅读(630) 评论(0) 推荐(0)

PS发送邮件实例！

摘要：/* AREVA T&D – Project – Kevin He - 16/FEB/2009 – Begin *//* Send email with payslip to the corresponding employee. */import PT_MCF_MAIL:*;Local File &File;Local string &... 阅读全文

posted @ 2009-05-21 16:24 Kevin's Blogy 阅读(813) 评论(0) 推荐(0)

测试AE时fail后如何让run_control仍然可用！

摘要：The OPRID (USER) that has "locked" this run control from continuing on should take the followings steps: 1. Go to the Details link for the process that has No Successed, if the process is a sub proces... 阅读全文

posted @ 2009-02-27 17:58 Kevin's Blogy 阅读(311) 评论(0) 推荐(0)

Scheduling and emailing PeopleSoft Query results

摘要：You could E-Mail the Query results by embedding the paramters in a nVision Layout. Create a Tabular nVision Layout. Add the Query parameters to the Tab. Then, when you execute the nVision Report on... 阅读全文

posted @ 2009-02-22 20:14 Kevin's Blogy 阅读(308) 评论(0) 推荐(1)

PeopleSoft Audit

摘要：Same way as a delivered record (or you can add audits to a delivered record if it doesn't already have them). You can either turn audit on for individual fields or build a custom audit record. To au... 阅读全文

posted @ 2009-02-12 09:53 Kevin's Blogy 阅读(301) 评论(0) 推荐(1)

Create flat file with AE

摘要：Local File &File; Local string &FILE_NAME, &CHARSET, &COMPANY_NAME, &COMPANY_PADDED, &LINES_PADDED, &AMOUNT_PADDED; Local number &LINES, &AMOUNT; Local Record &HEADER_REC, &TRANSACTION_REC; Local SQL ... 阅读全文

posted @ 2009-01-13 17:02 Kevin's Blogy 阅读(268) 评论(0) 推荐(0)

Tracing App Engine Programs

摘要：Tracing an application engine program can be easily done without modifying the trace settings in your application server. Here are some simple guidelines to follow to trace an app engine program. Go... 阅读全文

posted @ 2009-01-09 14:38 Kevin's Blogy 阅读(223) 评论(0) 推荐(0)

Record Level Auditing

摘要：I'm sure you are aware that PeopleSoft has built in Field Level Auditing that allows you to track any adds, changes, or deletes to a specific field in a record. This is good to use at times when you... 阅读全文

posted @ 2009-01-09 14:17 Kevin's Blogy 阅读(229) 评论(0) 推荐(0)

Definition in View&Database

摘要：Here is the definition in Application Designer: SELECT a.SETID , a.PROD_GRP_TYPE , a.PRODUCT_GROUP , a.DESCR , a.GLOBAL_FLAG , a.eff_status FROM %Table(PROD_GROUP_TBL) a WHERE (%EffdtChe... 阅读全文

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

Call Crystal Report from Application Engine

摘要：Before doing this, check the conditions below: 1. Make sure Process Definition of the Crystal Report has been setup correctly. 2. Make sure the Process Groups of AE also has permission t... 阅读全文

posted @ 2008-12-31 17:14 Kevin's Blogy 阅读(379) 评论(0) 推荐(0)

Call Query from Application Engine

摘要：Function SG_ExecQuery() Returns boolean; Local string &sOutFile; Local Record &rcdQryRunParms; Local Record &rcdQryPrompts; Local SQL &sqlSelectQryParms; Local number &cnt, &i, &Result;... 阅读全文

posted @ 2008-12-31 09:50 Kevin's Blogy 阅读(453) 评论(0) 推荐(0)

随笔分类 - Application Developer/Engine