myPeopleSoft

PeopleSoft Community Network

Wilbert Janusz's Likes

June 2013

Talent Summary

video Talent Summary 32 Likes

May 2013

understanding how much stable the system is Select year,month,count(1) as Project_count,sum(ocount) as Object_count from (SELECT distinct B.PROJECTNAME,TO_CHAR(B.LASTUPDDTTM ,'yyyy' ) as year,TO_CHAR(B.LASTUPDDTTM ,'mm' ) as month,count(1) ove… Discussion understanding how much stable the system is 8 Likes

April 2013

Data convertion for person profile I Have any one worked on the data convertion for person profile module (under profile management ) for HCM 9.0 using component Interface? If so can you please share some idea/details?We tried using t… Discussion Data convertion for person profile 6 Likes Create insert statement for tables Create insert statement for tables for data migration where ZZ84 is a new prefix for temporary tables. SELECT DECODE(COLUMN_ID ,1,'INSERT INTO '||REPLACE(table_name,'PS_','PS_ZZ84_')||' SELECT ',' ')… Discussion Create insert statement for tables 6 Likes Switching from a guest user to a authenticat… We have a Campus Solutions student application where a student can search for classes as a guest user. Based upon the information they enter we determine if a user profile account already exists for… Discussion Switching from a guest user to a authenticat… 3 Likes Searching on long edit field in oracle 10 fo… create or replace function getlong( p_tname in varchar2,p_cname in varchar2,p_rowid in rowid ) return varchar2asl_cursor integer default dbms_sql.open_cursor;l_n number;l_long_val varchar2(4000);l_lo… Discussion Searching on long edit field in oracle 10 fo… 7 Likes