Chesson's PeopleSoft Blog

Focus on Oracle Application

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

2012年8月2日

摘要: Peoplesoft AWE Workflow configuration and setup tables. Ver 9.0 User the following scripts to move the AWE configuration / setup datafromthe one instance to another instance.Note :- add where clause if you need to move only configuration specific toparticular AWE transactions.Exportscript-- "Re 阅读全文
posted @ 2012-08-02 15:11 chesson 阅读(433) 评论(0) 推荐(0) 编辑

摘要: As PeopleSoft maintains critical enterprise data, having an audit trail on critical data is of paramount importance. This post will help you setup Record Level Auditing in 7 simple steps.Record level AuditingAs the name suggests, record level auditing is the auditing mechanism enforced on aRecord. T 阅读全文
posted @ 2012-08-02 14:46 chesson 阅读(270) 评论(0) 推荐(0) 编辑

摘要: 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/Tracelink, then use the following SQL to determine the process's output directory:SELECT PRCSOUTPUTDIR FROM PSPRCSPARMS WHERE PRCSINSTANCE = %Process 阅读全文
posted @ 2012-08-02 13:54 chesson 阅读(184) 评论(0) 推荐(0) 编辑