- 博客(47)
- 资源 (1)
- 收藏
- 关注
RSS订阅转载 Peoplecode to Create BI publisher XML and XSD Data source file.
Peoplecode to Create BI publisher XML and XSD Data source file. import PSXP_RPTDEFNMANAGER:*;import PSXP_XMLGEN:*;&rs = create PSXP_XMLGEN:RowSetDS();&rsStg = CreateRowset(Record.STAG_REC);
2013-05-14 12:28:07
1379
转载 AWE Workflow Application Class Criteria
AWE Workflow Application Class CriteriaI had a little trouble creating my first App Class criteria so I thought I would share some tips on how to write an App Class for use as AWE criteria. Here
2013-05-14 11:20:34
985
转载 How to read a SQL Trace in PeopleSoft
How to read a SQL Trace in PeopleSoftAs always with so many things, I struggled initially to understand the trace file. More often, I would generate a trace file and did not understand every aspec
2013-05-14 11:15:40
1047
原创 PS日期，天数的处理函数
import PTFP_FEED:UTILITY:Utility;/******计算月数*******/Declare Function AgeInMonth PeopleCode FUNCLIB_HR.AGE FieldFormula;/******计算天数*******/Declare Function AgeInDays PeopleCode FUNCLIB_HR.AGE
2013-05-03 15:27:07
946
转载 Oracle SQL常用函数
新增：查询位置SQL ：SELECT INSTR(DESCR,'.') FROM PS_DEPT_TBL 1. ASCII 返回与指定的字符对应的十进制数; SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; A A ZERO SPACE --------- ----
2013-04-14 23:56:11
2412
转载 PS变量
PeopleCode变量名都以&开头，缺省的局部变量类型为ANY。当返回数据类型不确定时为ANY，由PeopleTools决定其类型。 Local Any &Example_Any;Local String &Test;Local String &Test2; &Example_any = "TEST";&Example_Any = &Test | ' ' | &Tes
2013-04-14 21:15:46
882
转载 仁科和Microsoft Active Directory安装单点登录
第一部分 - 实现单点登录ERP应用Vijayakumar Chinnasamy 仁科，仁科于2010年2月23日在现场手册仁科现场手册上获取最新的更新直接在您的收件箱。我的工作在项目实施过程中多个单点登录我的经验，使Hexaware。只是为了让你知道，我目前的工作在这样的一个项目。我计划整合了单点登录技术，可与不同的供应商，并提供我个人的分析和组织
2012-12-03 12:17:17
1526
转载 Oracle PL/SQL之内联接、外联接、交叉连接
oracle的联接分如下几种：内联接（inner join）。外联接（outer join）：全联接（full join）、左联接（left join）、右联接（right join）。交叉联接（cross join）。外联接与内联接不一样，外连接返回到查询结果中的不仅包含符合条件的行，还包括左表(左外连接),右表(右外连接)或者两个连接表(全外连接)中的所有不符合条件的数据行
2012-12-03 10:49:01
785
1
转载 PeopleSoft Alter Audit -- 检查Table 与 Record的差异性
Alter Audit 指的是在Application Designer中创建Alter build脚本，用以检查PeopleSoft Definition 与数据库 table之间的差异性。1. 在Application Designer中创建一个project。2. 选择Insert > Definitions into Project，将所以table 类型的record插入到当前项
2012-12-03 10:47:11
675
转载 Oracle Database - Net Service Name (tnsname)
A simple name for a service that resolves to a connect descriptor.Users initiate a connect request by passing a user name and password, along with a net service name in a connect string, for
2012-12-03 10:27:31
983
转载 Oracle Database - Oracle Net (SQL*Net)
Oracle Net, a component of Oracle Net Services, enables a network session from a client application to an Oracle Database server. When a network session is established, Oracle Net acts as the data cou
2012-12-03 10:26:17
351
转载 Oracle Database - System Identifier (SID)
目录(?)[+]SID or service nameHow to change it ?The System Identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on t
2012-12-03 10:25:12
696
转载 Process Request shows status of 'INITIATED' or 'PROCESSING' but nolonger running
当测试一个不引用任何SQC文件的SQR程序时，可能会报这个错：查看消息日志：Process Request shows status of 'INITIATED' or 'PROCESSING' but nolonger running主要原因就是该程序并不是API Ware的SQR程序。Ref:When you run an SQR, the status t
2012-12-03 10:21:01
1925
转载 在SQR中使用Break逻辑
目录(?)[+]不使用Break逻辑使用Print命令的On-Break选项使SQR程序API Ware在报表中，当一列值改变时，也就是出现break时，通常会做一些特殊处理，比如跳过一行、在break之前或之后执行某个procedure、打印小计等等。不使用Break逻辑如下例，针对选择的每一个员工，打印该员工的姓名、公司和员工薪水。该例不使用任何break逻辑：
2012-12-03 10:19:46
869
转载 (SQR 1933) The month (9月 -2012_02:01:36.000000_下午) is not valid for the current locale or database.
在将SQR API Ware的过程中，需要将#Include 'setenv.sqc' 和#Include 'stdapi.sqc'加入到SQR中。但是出现如下错：(SQR 3506) Array specified not defined with CREATE-ARRAY原因是没有加入#Include 'datetime.sqc' 。于是在SQR中加入：#Include
2012-12-03 10:16:32
958
转载 PeopleSoft SETID驱动的表
Business Unit (PS_BUS_UNIT_HR.DEFAULT_SETID)Department ——PS_DEPT_TBLJobcodes ——PS_JOBCODE_TBLLocations —— PS_LOCATION_TBLSalary Plans ——PS_SALARY_PLANSalary Gr
2012-12-03 10:12:55
865
转载 解决异常All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3
昨天在RUN一个process的时候，发现一直重复出错，tracefile信息也没有什么有意义的提示，仔细研究了一下，发现原来是在第一次出错以后，系统把出错信息记录在PS_AERUNCONTROL了，这样当下次用同样的ID和同样的Control ID运行的时候，他会重这个表里面去比较，因而总是得到同样的出错信息。要解决这个问题，只需要将这个表的相应记录删除就可以了。 在db2中执行一下s
2012-11-20 10:23:09
606
转载 Get process's navigation path by using process name
SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label),' > ')) ,' > ') PATH FROM PSPRSMDEFN WHERE PORTAL_NAME ='EMPLOYEE' AND PORTAL_PRNTOBJNAME = 'PORTAL_R
2012-11-20 09:55:08
410
转载 Check if user has access to CI
SELECT C.ROLEUSER ,B.ROLENAME ,A.CLASSID, -- OPRID A.BCNAME -- CI , A.BCMETHOD FROM PSAUTHBUSCOMP A, PSROLECLASS B, PSROLEUSER C WHERE C.ROLENAME = B.RO
2012-11-20 09:52:48
411
转载 获取Process、Component 和 Page 的导航路径
Navigation based off ProcessSELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDF
2012-11-20 09:48:28
516
转载 Migrating Queries from One User To Another从一个用户迁移到另一个查询
If you ever have a need to migrate queries from one user to another, you can do it quickly and easily with this useful SQL script. If you want to make the Query Public, simply change the NEWPSUSERID
2012-11-20 09:45:56
314
转载 Process Scheduler monitoring useful script
SELECT S.SERVERNAME, X.XLATSHORTNAME, X.FIELDVALUE, cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU, cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,
2012-11-20 09:44:31
295
转载 search for queries utilizing a specific field
The "Find Object References - Record Field" feature in Application Designer, when used to search for queries utilizing a specific field (i.e. "EMPL_STATUS"), is not accurate because it returns que
2012-11-20 09:36:29
352
转载 PeopleSoft 数据库 VS Oracle 数据库
Database一词通常被PeopleSoft用来指代Oracle或其他数据库的PeopleSoft administrative schema中的表集合。相比之下，Oracle将database描述为物理数据、日志文件和控制文件的集合。一个Oracle实例（Instance）就是互相通信的进程的集合，这些进程管理着数据库。当描述登录数据库过程的时候，这些不同之处会变得更加明显。有时，甚至是D
2012-11-20 09:34:11
1308
转载 Oracle数据库用户
每个与数据库建立了两层连接的进程都通过一个PeopleSoft User或者operator ID识别自身。对登录过程进行处理的目的是为了安全的验证PeopleSoft operator（已通过密码验证）被允许访问PeopleSoft应用。从 version 8开始，一个PeopleSoft数据库只需要三个Oracle数据库方案：Owner ID：该schema包含大多数数据库对象
2012-11-20 09:32:37
885
转载 PeopleSoft Architecture && Overview
The PeopleSoft Internet Architecture (PIA) is a server-centric component architecture that enables secure end user access to PeopleSoft applications. Its components include the following:• Interne
2012-11-20 09:27:09
2861
转载 Can't establish HTTP connection when consuming webservice
When registering in Consume Web Service Wizard, flowing error appeared:Go to integrationgateway.properties file which is in your webserv directory.search forsecureFileKeystorePasswd. Then
2012-11-20 08:41:13
551
转载 PS_PTLT_COMP_NAV
PS_PTLT_COMP_NAV – Define Components Navigation Setup record (in PT>=8.4xx). It is a very useful table especially when you are given a certain PeopleSoft link or Component and you don’t know how to id
2012-11-20 08:34:26
395
转载 Read A Flat File Using File Layout And Insert Into The Specific Component Using CI ( Bulk Insert )
Read A Flat File Using File Layout And Insert Into The Specific Component Using CI:Approach:Get the sample flat file and create a File Layout.Create the CI for the component.Create an AE and
2012-11-19 11:28:52
434
转载 AWE Tables and Migration script
AWE 9.1 Application Tables:-- Approval Process Definitionsset output EOAW_Systbls_export.dat;set log EOAW_Systbls_export.log;-- Export Transaction RegistryExport EOAW_ADMMON_CFG;Export
2012-11-19 11:25:39
692
转载 Peoplesoft AWE Workflow configuration DMS scripts
Peoplesoft AWE Workflow configuration and setup tables. Ver 9.0User the following scripts to move the AWE configuration / setup data from the one instance to another instance.Note :- add where
2012-11-19 11:23:42
921
转载 在UltraEdit中为SQR配置代码着色
可以在UltraEdit（我用的版本是ue17.00.0.1025）中为SQR配置代码着色，首先在UltraEdit中找到高级-->配置-->编辑器现实-->语法高亮，如下图： 看到“文档的完整目录名称”里指定的目录，然后在该目录下建立sqr.uew空文件，将如下代码copy到文件中，保存即可：--BEGIN FILE--/L10"SQR" Nocase Line Commen
2012-11-19 11:19:29
665
转载 %EXCEUTE在一个SQL Action里执行多条SQL语句
Example: Scenario1: Open one SQL Action............. %EXECUTE (/) UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS'; / INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................); /...
2012-11-19 11:18:14
470
转载 SQL Server 表空间问题
1.PS系统使用SQLSERVER数据库，在AD中保存RECORD的时候会提示选择表空间，但SQLSERVER根本没有表空间，所以解决办法是在“PeopleTools>实用程序>管理>PeopleTools”选项中去掉“平台兼容性模式”前面的勾.
2012-11-19 11:09:09
615
转载 PeopleSoft Rich Text Boxes上定制Tool Bars
在使用PT8.50或在8.51时，你可能遇到过Rich-text编辑框。该插件使你能够格式化文本，添加颜色、链接、图片等等。下面是效果图：如果页面中只有这么一个字段，该文本框就会有足够的空间来容纳其中的tools bars了，但是通常页面中会有许多字段，因而留给该表示该文本框的字段的所需的空间就少了，于是需要根据业务需求对文本框中的工具条目进行瘦身或者适当的扩展。简单的实现方式
2012-11-19 11:06:27
404
原创 Alter by Table Rename 与 Alter Table in Place 的一些记录
参考1：今天技术群里的某位兄弟遇到了一个奇怪的错误：Error: Cannot alter record EP_APPR_B_ITEM using Alter by Table Rename because one or more deleted field(s) has LOB storage parameters. Please alter using Alter in Place.
2012-11-19 11:03:31
862
转载 Determine File Output Location
Suppose I want to create a file (printable report, log file, etc), where should I create the file? If you want the file available from theView Log/Trace link, then use the following SQL to determine
2012-11-19 10:56:40
321
转载 Difference between FieldEdit and FieldChange events
Field Change PeopleCode is for recalculating field values based on changes made to other fields. For instance, suppose you have 2 fields, rate and quantity and there is another field which shows total
2012-11-19 10:54:00
316
转载 Understanding Peoplesoft Trace
Here are the steps to generate application and Application Engine traces, to troubleshoot any application issues.Before you start generating traces, you need to make sure that the following paramete
2012-11-19 10:52:46
1095
1
原创 计算时间间隔天数
参考1：&NUM_DAYS = Abs(Days(HIRE_Date) - Days(RELEASE_Date)); 参考2：/*计算时间差直接用系统函数AgeInYears*//*来源于修改人员页面的日期计算*/DeclareFunctionAgeInYears PeopleCode FUNCLIB_HR.AGE FieldFormula;DeclareFun
2012-11-19 10:51:29
587
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人