PeopleSoft Technical Queries (31)

Discussions Replies Latest Activity

PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud-2

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of a reports conversion solution for customers who…

Started by Jasmine

0 Sep 18

Baseline indexes for PeopleSoft db on SQL Server

Hi, I've started to manage/support a PeopleSoft database on SQL Server. A previous DBA looks to have run the tuning advisor and created a n…

Started by Darryl Daley

3 Jul 9
Reply by kristen

Useful queries in peoplesoft

"RenameQueries.sql"UPDATE PSQRYDEFN set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem whe…

Started by Dale Kittel

1 Jul 9
Reply by kristen

AFS structure within App. Configuration

Hello PeopleSoft experts. This one is a bit tricky, and hence seeking your suggestions/ideasScenarioUser1, User2User1 has his sqrs located…

Started by Allie Alderson

1 Jul 9
Reply by kristen

How to make PS cookies secure?

In PT 8.44.07 I want to set the secure parameter on all cookies generated by Peoplesoft application. currently I see PS_TOKEN is the only c…

Started by Allie Alderson

1 Jul 9
Reply by kristen

PeopleSoft with .NET

Hello I have a Webbase application in .NET and I'm trying to run a COM API from peoplesoft. Has anyone donde this? First I have to define t…

Started by Dale Kittel

3 Jul 9
Reply by kristen

Project Object Finder SQL !!

SELECT PROJECTNAME,CASE OBJECTTYPEWHEN 0 THEN CASE NVL((SELECT RECTYPE FROM PSRECDEFN WHERE RECNAME =I.OBJECTVALUE1), 99)WHEN 0 THEN 'SQL T…

Started by Mitchell Mahi

1 Jul 9
Reply by kristen

Peoplesoft translate value mapped to a page SQL.

Select p.*,xlat.descr_string from (SELECT FIELDNAME ,rtrim(MAX(SYS_CONNECT_BY_PATH(descr,'~~')),'~~') as descr_stringFROM(SELECT FIELDNAME,…

Started by Man Musser

2 Jul 9
Reply by kristen

Keys on component interface

/*LevelNo|Iskey|RecordName|FieldName|ParentRecName*/ SELECT A.BCSCROLL || '|' || DECODE(B.FIELDNAME , NULL , 'FALSE' , 'TRUE') || '|' || A.…

Started by Allie Alderson

1 Jul 9
Reply by kristen

PeopleSoft Single Sign-on -- Capture Network ID or IP address for Batch ID

We have Single Sing-on enable and configured with LDAP server.  We have common PeopleSoft User ID that is primarily used for batch processi…

Started by InfoStar

1 Jul 9
Reply by kristen

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2017   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service