PERSONAL_DATA record not getting updated properly Shyam 9/30/2009 1 PS_PERSONAL_DATA record is a physical table to hold snapshot of EMPLOYEES data in PeopleSoft-HCM. However, this record does not get populate...
PeopleSoft Array error due to ....... (read more to find that silly reason) Shyam 9/30/2009 5 One of my friend had written a PeopleSoft Application Engine which reads a csv file and processes data. The input csv file had only 2 column...
Getting PIA's default Process Output Directory Shyam 9/28/2009 0 How to find the path of PIA's default Process Output directory? Delivered SQC's help to retrieve the path of Process Output directo...
Oracle SQL Query to fetch data if a field value has atleast only one or all numerals Shyam 9/27/2009 1 One of my friend wanted to write a SQL query which must identify records which have atleast one numeral in a particular varchar field. To_...
Creating a folder from SQR Shyam 9/25/2009 4 There are no system commands in SQR which allows creation of a folder. If a folder has to be created from a SQR then we can use call system ...
Sample code to read a file using file layouts and to insert data into a record Shyam 9/25/2009 0 Sample code to read a file using file layouts and to insert data read into a record. Local File &MYFILE; Local Record &REC; Loca...
Tackling duplicate row issue in Position data CI Shyam 9/25/2009 1 When an app engine (AE) calls delivered Component Interface - CI_POSITION_DATA built from the POSITION_DATA component, the AE keeps abending...
Syntax for creating Oracle database link Shyam 9/25/2009 0 Syntax to create a database link to a target oracle database from another oracle database: create database link TARGETDB connect to USERID ...