hankinfotec.blogspot.com
PeopleSoft 361°: PeopleSoft integration with External Restful Webservice via SOA Suite
http://hankinfotec.blogspot.com/2015/07/peoplesoft-integration-with-external.html
PeopleSoft integration with External Restful Webservice via SOA Suite. Nowadays the cloud solutions are covering everywhere in daily lives by thousands of providers - daily expenses, property management, online stores, project management, customer relationship management, or even smart house technologies. Below is the screen shot of one example Expense record. Nothing shining too much. On the market cloud services are providing their own API. They do have different levels of security settings. Si...This ...
hankinfotec.blogspot.com
PeopleSoft 361°: How to get trace enabled for COBOL Programs executed from PeopleSoft in 2 tier and/or 3 tier?
http://hankinfotec.blogspot.com/2012/04/how-to-get-trace-enabled-for-cobol.html
How to get trace enabled for COBOL Programs executed from PeopleSoft in 2 tier and/or 3 tier? Source: hmmm… my apologies to the original writer, I really can’t recall where I took this note from… apologies again.]. PeopleSoft trace supports only objects only within PeopleTools, so we cannot trace COBOL SQLs. Is this true? It is possible to generate COBOL SQL(cobsql.) Trace along with bind values. And it is possible to generate cobsql.trc files in both TWO TIER and THREE tier modes. 2) Check all or select...
hankinfotec.blogspot.com
PeopleSoft 361°: Scheduled PSJob distribution list
http://hankinfotec.blogspot.com/2010/06/scheduled-psjob-distribution-list.html
Scheduled PSJob distribution list. When you want to detect the distribution list within a scheduled job, the two tables will be fancy to see:. Select * from PS SCHDLITEM - All scheduled items. Select * from PS SCHDLRPTDIST - All distribution list. Subscribe to: Post Comments (Atom). Scheduled PSJob distribution list. After being a deadlock victim, rerun VAT1001 SQR r. View my complete profile. Grey Sparling PeopleSoft Expert's Corner. Dynamic Java in PeopleCode. The PeopleSoft DBA Blog.
hankinfotec.blogspot.com
PeopleSoft 361°: PeopleSoft Batch Server
http://hankinfotec.blogspot.com/2010/06/peoplesoft-batch-server.html
From [http:/ visualsuccess.com/mediawiki/index.php/PeopleSoft Batch Server]. Peoplesoft 8.4 added a master process scheduler which acts as a load balancer for other process schedulers. PS PRCSSEQUENCE Process Sequence Number. PS PRCSRUNCNTLDTL Destination Options. PS BATRUNCNTL Process Specific Run Control. PS PRCSRQSTDIST Distribution Requests. PSPRCSPARMS Process Request Parameters. PS PMN PRCSLIST Process Monitor list (five stars! Troubleshooting Peoplesoft Batch Server. View my complete profile.
hankinfotec.blogspot.com
PeopleSoft 361°: [PeopleSoft] File layout converting spaces to blanks - UseSpaceForNull
http://hankinfotec.blogspot.com/2012/04/peoplesoft-file-layout-converting.html
PeopleSoft] File layout converting spaces to blanks - UseSpaceForNull. Source: http:/ peoplesofthrms.blogspot.com.au/search/label/File%20Layouts. Ran into a peculiar problem while writing to a file using File Layouts today. Fields that had. A space in the database was being converted to null while writing to the file. Did all the obvious. Checks like ensuring the Trim Spaces and Strip White Spaces properties of the FileLayout were unchecked. If &FILE1.IsOpen Then. FILE1UseSpaceForNull = True;. Setting En...
hankinfotec.blogspot.com
PeopleSoft 361°: T&L Inactive Time Reporter appears twice on calendar timesheet views (HRMS8.9/9.0)
http://hankinfotec.blogspot.com/2010/09/t-inactive-time-reporter-appears-twice.html
T&L Inactive Time Reporter appears twice on calendar timesheet views (HRMS8.9/9.0). On the Daily, Weekly and Monthly Time Calendar View the Inactive Time Reporters have two duplicate rows. When Employee is Active in Job Data, but Inactivate as Time Reporter there are two rows displayed in the Calendar View. When Employee is Inactivated in Job Data and Inactive as Time Reporter, too there is only one row displayed in Calendar Views. Labels: Time and Labor Timesheet Peoplesoft. View my complete profile.
hankinfotec.blogspot.com
PeopleSoft 361°: Peoplesoft - howto find the navigation to components using SQL
http://hankinfotec.blogspot.com/2012/06/peoplesoft-howto-find-navigation-to.html
Peoplesoft - howto find the navigation to components using SQL. This record is used in setup manager -. PS PTLT COMP NAV. Which defines Components Navigation. The field. Reflects component name, but there's ".GBL", or other Global extension like ".AUS". It doesn’t work for the transaction components like "PERSONAL DATA". SELECT * from PS PTLT COMP NAV;. For the transaction components,. A platform-independent SQL snippet is found here. Provide navigation location for component */. I found another (.
hankinfotec.blogspot.com
PeopleSoft 361°: Refreshing Security Join Tables
http://hankinfotec.blogspot.com/2010/07/refreshing-security-join-tables.html
Refreshing Security Join Tables. To refresh security join tables, use the Nightly SJT Refresh Process component (SCRTY SJTDLY RC), Refresh Trans. SJT tables component (SCRTY SJT RC), the Refresh SJT CLASS ALL component (SCRTY OPR RC), and the Refresh SJT OPR CLS component (SCRTY OPRCLS RC). PeopleBook (PeopleSoft Enterprise HRMS 9.1 Application Fundamentals PeopleBook Setting Up and Administering HRMS Security) describes when to use the refresh processes and discusses how to:. Labels: security join tables.
hankinfotec.blogspot.com
PeopleSoft 361°: PeopleSoft Time and Labor Tips: tracing TRC and migrating rules
http://hankinfotec.blogspot.com/2012/04/peoplesoft-time-and-labor-tips-tracing.html
PeopleSoft Time and Labor Tips: tracing TRC and migrating rules. HOWTO: trace TL TIMEADMIN. By following the Application Engine program convention, either we can override or append a Parameter List, say “ -TRACE 135 -TOOLSTRACESQL 31. Main Menu PeopleTools Process Scheduler Processes. Process Name: TL TIMEADMIN. When debugging PeopleSoft T&L rules, the SQL below can be used to trace a specified TRC (take “SH125” as my example):. And CEXPRESSIONTEXT like '%SH125%' /* the TRC focused*/. EXPORT TL RULE STEPS.
hankinfotec.blogspot.com
PeopleSoft 361°: HowTo achieve process instance of scheduled process
http://hankinfotec.blogspot.com/2012/04/howto-achieve-process-instance-of.html
HowTo achieve process instance of scheduled process. Source: http:/ peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/peoplecode-to-discover-process-instance-of-scheduled-process-892219. In 844, when you schedule a process, you are returned a ProcessRequest object which has as a property - ProcessInstance. Here is the entry from PeopleBooks:. ProcessInstance Description - -. This property is read-write. RQST = CreateProcessRequest();. Set all the Required Properties */. Grey Sparling Peo...
