conanxun-优快云博客

转载 PeopleCode 发送邮件并给邮件添加附件

import PT_MCF_MAIL:*;Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail();&email.From = &FromAddress;&email.Recipients = &ToList;&email.Subject

2016-06-13 17:16:02 610

转载 AE中将BIPublisher 生成的报表作为邮件附件发送

想要把BIPubliser 生成的报表作为邮件附件发送，首先要知道报表路径，我们知道报表路径是存在 ps_cdm_list 和 ps_cdm_file_list 两张表里的，当报表发布之后，我们可以用SQL语句将报表在服务器的路径查出来。SQlExec("select contentid from ps_cdm_file_list where prcsinstance=:1

2016-06-13 17:15:00 738

转载跑Application Engine时需要详细的Trace可以在process定义里加入

跑Application Engine时需要详细的Trace可以在process定义里加入"-TRACE 7 – TOOLSTRACEPC 4044"，这样就可以在process monitor里面看到详细的Trace了。如图所示：

2016-06-13 17:14:26 298

转载在金额前添加货币符号

Setting Currency Field Display Properties When Developing Applications When you place a currency amount field on a page, you can choose whether to display the currency symbol in the amount field a

2016-06-13 17:13:15 968

原创配置 XML Publisher 的字体

在 bi publisher config下面配置其支持的字体。路径类似如下：C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config，然后找到 xdo example.cfg ，将其save as 为 xdo.cfg。需要什么字体就加入什么字体。

2016-06-13 17:12:30 597

转载 What Are the Tree Table Names

E-TR: What are the names of the Tree tables?Names of Tree Tables and relationship parent/childPeopleSoft Tables – Tree ManagerTable Name Table DescriptionPSTREEDEFN Stores valid tree definitio

2016-06-13 17:11:44 292

转载 Data Types in PeopleCode

Similar to all other programming languages PeopleCode also has conventional data types like NumberDateString for basic computing.It should be a common practice to declare a varia

2016-06-13 17:08:46 286

转载 PeopleCode Variable Names

A PeopleCode variable naming convention should be part of your development standards.All variables should be declared and scoped (Global, Component or Local). Undeclared variables are included in Pe

2016-06-13 17:08:10 205

转载将SQR生成的文件发布到Report Manger的方法

来源：http://peoplesoft.wikidot.com/sqr-output-to-report-repositoryIf you are developing a new SQR that creates files that need to be posted from the process scheduler to the report repository, (report

2016-06-13 17:07:42 297

转载 PeopleSoft HCM Fundamentals: Multi-Currency

PeopleSoft supports multi-currency environment. Currency from different countries tracks the currency amount up to 3 decimal positions based on their country rules.For example; India & USA tracks

2016-06-13 17:07:03 265

转载 To know the project Dependencies

Select Distinct Projectname, ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,ObjectID3, Objectvalue3,ObjectID4, Objectvalue4from PSprojectitemwhere (ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,O

2016-06-13 17:06:36 183

原创 Repetitive Error: Updated by Another User (3,1)

当在Application Designer中保存代码时，频繁的出现这个错。解决办法：When writing the peoplecode never right click on the component to go to its peoplecode from shortcut, but double click and open the component and then go

2016-06-13 17:05:38 245

转载 Sublime Text: PeopleCode Syntax Highlighter

I've created a PeopleCode syntax highlighter plugin for Sublime Text. You can download it ongithub. Alternatively, you can add the repository to Package Control in Sublime Text, and then install i

2016-06-13 17:04:24 629

转载 PeopleSoft-Project-View

ProjectView.sqlselectcase PI.OBJECTTYPE when 0 then 'Records' when 1 then 'Indexes' when 2 then 'Fields' when 3 then 'Field Formats' when 4 then 'Translate Values' when 5 then 'Pa

2016-06-13 17:04:03 275

转载 Different Ways to Integrate with PeopleSoft

Different Ways to Integrate with PeopleSoftPosted on February 7, 2012 by Chris JudsonOver the years PeopleSoft has provided many different integration points to access data and execute bus

2016-06-13 17:03:22 248

转载 Setup Integration Broker for Web Services

By david.bainIf you venture to the PeopleSoft/Fusion Middleware best practice site, you'l also see that several of the Oracle-By Example or viewlets showcasing PeopleSoft interoperability with Fus

2016-06-13 17:02:56 321

转载 Notepad++ for Peoplecode and SQR

原文：http://workingscripts.com/2009/06/notepad-peoplecode-sqr/There are a few people who mention different tools for Application Development in PeopleSoft. Over the past years I have tried many of t

2016-06-13 17:02:25 720

原创 Word 中XMLP的加载项 toolbar不存在

如果删掉 C:\Users\IBM_ADMIN\AppData\Roaming\Microsoft\Word\STARTUP下面的TemplateBuilder.dot文件，toolbar就会消失。所以如果遇到toolbar消失的情况，可以考虑这个文件是否存在。另外当更换了语言后，这个文件会从这个目录下删掉，然后再重建。

2016-06-13 17:02:01 360

原创已经完成的算薪能有什么办法重新计算吗

可以参考：重新打开finalized的月份的薪资UPDATE sysadm.PS_GP_CAL_RUN SET RUN_FINALIZED_IND='N',RUN_FINALIZED_TS=NULL,RUN_OPEN_IND='Y', RUN_OPEN_TS='', PMT_SENT_IND ='N' WHERE CAL_RUN_ID=:1;UPDATE sysadm.

2016-06-13 17:01:41 252

转载回车实现方式：Carriage Return in PeopleCode

Sometime back, I was writing an application engine using PeopleCode and I needed to insert a carriage return between two long strings getting concatenated so they look like two sentences one after the

2016-06-13 17:01:02 292

原创关于Android子线程不能更新UI的问题

假设现在有这样一个功能，通过点击界面上的按钮，可以备份手机里所有的短信，具体的布局文件就不赘述了。如下是按钮上绑定的方法：public void backUpSms(View view) { new Thread() { @Override public void run() { //备份短信，耗时操作

2016-06-12 23:00:19 368

原创 COBOL LICENSE

Serial Number: PEOPLESOFT-SX-DEV64License Number: 01030 A0000 194A2 BBF0C 96AA

2014-04-09 21:58:09 281

转载 Open文件时第三个参数(编码)要小心赋值

我们常常也会用Application Engine来写一些报表，自然就会用到Open File。当我们写一个CSV file的时候一定要注意不要随意的给第三个参数即编码。大家都知道CSV file是用","隔开就可以了，用Excel打开时逗号间的字符就占用一个单元格。如果像下面这样赋值成"U"，即使用逗号隔开，当用Excel打开时数据不会因为逗号来分开成多个单元格，而是所有数据都在第一个单元格

2013-03-19 14:38:19 179

转载查看某个用户对Component Interface的使用权

SELECT A.BCNAME,A.BCDISPLAYNAME,A.MENUNAME ,A.DESCR, A.DESCRLONGFROMPSBCDEFN A WHERENOT EXISTS (SELECT B.CLASSID FROMPS_PSBCDEFN_VW B, PSOPRCLS C WHEREB.BCNAME = A.BCNAME A

2013-03-19 14:36:33 81

转载在Application Engine 中调用Query

Function SG_ExecQuery() Returns boolean;Local string &sOutFile;Local Record &rcdQryRunParms;Local Record &rcdQryPrompts;Local SQL &sqlSelectQryParms;Local number &cnt, &i, &Result;Local ApiObjec

2013-03-19 14:33:09 115

转载页面跳转的URL方式

注意，字段一定要足够长，否则会截断url。建立一个dw的记录，放一个2000字符长度的字段，然后拖一个按钮和连接的控件进去。在本记录的 fielddefault事件中，赋值如下：设置连接的文字: &RS1(1).CST_TR_PLN_UPDV.URLS.Label = &DES1; &RS1(2).CST_TR_PLN_UPDV.URL

2013-03-19 14:31:46 136

原创 Application Designer BAT 快速启动

e:\apps\pt849\bin\client\winx86\pscfg.exe -import:e:\pT849.cfg"C:\Documents and Settings\All Users\Start Menu\Programs\PeopleTools 8.49.19\Application Designer.lnk"

2013-03-19 10:13:03 101

转载 How to export PeopleSoft Project Compare Report Results into excel file

1.Execute following SQL Query in Source Database to get the peoplesoft compare report results for the specified project.----------------------------------------------------------------------SELE

2013-03-18 10:50:34 125

转载 Enhanced advice printing for 9.1 Payroll

http://mfinchps.blogspot.com/2011_04_01_archive.htmlHRMS 9.1 offers some great new features, including enhanced paycheck by Text-Enhance">self service for employees with direct access to the

2013-03-16 00:06:58 105

转载 PeopleCode取组件缓冲区（Component Buffer）数据小结

Local Rowset &RS_Level0, &RS_Level1;Local Row &Row_Level0, &Row_Level1;Local Record &Rec_TaskRsrc;Local Field &Fld_PctAvail;REM Get rowset of level0 (获取0层的行集合）;&RS_Level0 = GetLevel0

2013-03-15 11:43:14 120

转载 AE 生成XMLP report

Function Generate_xmlReport(); Local XmlDoc &xmlDoc; Local XmlNode &root_node, &sub_node, &text_node; Local Rowset &rs, &rs1; Local PSXP_XMLGEN:RowSetDS &oRS; Local PSXP_RPTDE

2013-03-15 11:41:04 178

转载利用PSXPFUNCLIB中的函数生成XMLP report

import PSXP_RPTDEFNMANAGER:*;Declare Function DeleteLocalFile PeopleCode PSXPFUNCLIB.FUNCLIB FieldFormula;Declare Function GetDirSeparator PeopleCode PSXPFUNCLIB.FUNCLIB FieldFormula;Declare Functi

2013-03-15 11:24:03 93

转载 What is the PeopleSoft "Portal Administrator" Role

The Portal Administrator role is a "special" role that gives Portal access to all folders and CREFs. Although the navigation access is given this role DOES NOT give security access to all menus and co

2013-03-15 10:57:50 122

转载 Exit(0) And Exit(1) Function in Application Engine

Exit(0) – Terminates the current PeopleCode Action in application engine.Exit(1) – Terminates the current Step in application engine.

2013-03-13 14:24:45 132

转载 Resolving employee search Issue in Job Data component

Issues:1. A user cannot view data that they have been granted access to on the Department Security Tree.2. A user can view data they have not been granted access to on the Department Security

2013-03-11 17:26:53 93

原创 ExcelToCI 登录连接到PeopleSoft的方式

Public Function buildLogin(sServer As String, sPortal As String, sNode As String, sHTTPPort As String, sProtocol As String, sPSSiteName As String, sUserID As String, sPassword As String, sCIName As St

2013-03-08 16:35:20 378

转载 Oracle's PeopleTools 8.52 Documentation Home Page [ID 1356456.1]

In this Document Purpose Details ReferencesApplies to: PeopleSoft Enterprise PT PeopleTools - Version 8.52 and laterInformation in this docu

2013-02-26 17:22:12 116

转载 PeopleTools 8.52 Release Notes [ID 1371407.1]

In this Document Purpose PeopleTools 8.52 Release NotesApplies to: PeopleSoft Enterprise PT PeopleTools - Version: 8.52 to 8.52 - Release: 8.4 to 8.4Information in this document ap

2013-02-26 17:20:41 110

转载 How to print dymanic images in XMLP report

In my project we have a requirement of printing employee photo dynamically in XMLP report.I have followed the below approach to display the employee photo on the report however image is not display

2013-02-25 16:29:32 122

转载 Upgrading PeopleSoft, part 2: Installation and the move to production

Discovering the truthArmed with your plan, and once you've confirmed your upgrade path is certified, your first step will be to install the new software. The upgrade from version 7.x to 8.x is more

2013-02-24 18:05:49 115