Recent Forum Posts

From categories:
page »
PrajPraj 15 Apr 2014 23:05
in discussion Forum / Help » Writing a Date expression in PS Query

You can't use a case-when-exists block in PS Query.

For an alternative see this:

by PrajPraj, 15 Apr 2014 23:05
Shailesh (guest) 15 Apr 2014 14:10
in discussion Forum / Help » Writing a Date expression in PS Query

Hi Guys,
I am trying to use below part SQL in PS Query as an expression. However I am getting Illegal Field name error when I save the Query.

Where A is PS_JOB and B is PS_JobCode_TBL.
Not Sure what is wrong with it. Any help is really appreciated.


by Shailesh (guest), 15 Apr 2014 14:10
Dave (guest) 10 Apr 2014 22:56
in discussion Forum / Help » Alternate keys removed from fields during migration.

I have a case open with Oracle. It appears that they put this limitation in with Peopletools 8.52 because their index naming standard only contains 1 digit 0-9, thus 10. We always created our own indexes; and with views this becomes irrelevant and it limits the functionality of search dialogs. It appears that the left hand of Oracle wasn't in agreement with the right hand.

by Dave (guest), 10 Apr 2014 22:56

That is interesting, perhaps it caused things to break during an upgrade? Anyway, please let us all know if you find out.

by PrajPraj, 10 Apr 2014 22:26
Dave (guest) 10 Apr 2014 22:13
in discussion Forum / Help » Alternate keys removed from fields during migration.

It appears that Peopletools 8.53 introduced the limitation; You can't go back and add them. I am still searching for an answer from Oracle as to why they put in the limitation.

by Dave (guest), 10 Apr 2014 22:13
PrajPraj 04 Apr 2014 12:30
in discussion Forum / Help » WSDL URL

Is there any further information on the application server logs or the IB errorlog.html?

by PrajPraj, 04 Apr 2014 12:30
Re: PeopleSoft Key Concepts by PrajPraj, 04 Apr 2014 12:29

I think you can setup a custom routing and set PS local node as sender and an External node as receiver.

PeopleSoft Key Concepts
Sunny (guest) 21 Mar 2014 10:28
in discussion Forum / Comments » PeopleSoft Key Concepts

Please visit the website to understand the key concepts in PeopleSoft

PeopleSoft Key Concepts by Sunny (guest), 21 Mar 2014 10:28
Muhammad Rizwan (guest) 11 Mar 2014 13:09
in discussion Forum / Help » WSDL URL

I am also receiving same exception but my scenario is different. Node is pingable, gateway configurations are fine, message, message schema, operation are fine. Service operation, handlers are active. Routing exists. Some services works fine but I get same exception at some other service operation. Can you please inform me about the reason of this Exception. Any help

by Muhammad Rizwan (guest), 11 Mar 2014 13:09

The SOAP and REST based services within PeopleSoft are built on top of the business logic (i.e. at the component level). I don't think there is a delivered way to run SQL queries directly on the database. I guess, if you wanted you could build the relevant views (as records) then expose them as custom components. It depends on the complexity of what you are trying to do. Another option is that you might be able to expose the relevant data via PeopleSoft Query. Both approaches are designed such that the PeopleSoft application maintains security over the data stored in the database (rather than exposing it directly).

Alternatively, can might be able to expose the PeopleSoft database itself via web service using a 3rd party tool (not sure if this sort of thing exists, but might be worth looking around).

susan (guest) 07 Mar 2014 15:47
in discussion Forum / Help » Issue with Webservice

I have the same request to update a field value to the 3rd party system.
you mentioned you wrote a field change event peoplecode to populate the values.
Is it possible you can provide that field change event peoplecode to me.
Thanks so much.

by susan (guest), 07 Mar 2014 15:47

Hello PeopleSoft Community,

Thanks to people like you this World is better.

I contact you Guys, because I was wondering If you could help me with Google Apps cloud computing integration. So far we were using salesforce as a CRM and now we are going to migrate to peoplesoft.

We developed in my team a little project based on javascript over Google apps that provides personalized and value added information to the final user in real time.

Technically speaking we have:

-Call the SOAP service for the login part
-Call OAuth2.0 service
-Call SQL queries to retrieve information from salesforce data base.

I got this approximation thanks to Google Developers community, but I am afraid that nobody has started any work related to peoplesoft yet, or at least I am not aware of it.

My aim is to perform SQL queries to peoplesoft database as I do with salesforce with javascript over the Google Cloud,

could you please give me any piece of advice? I don't know how to start, PeopleSoft is a new World for me

thanks in advance for your time reading this mail!


P.S: There is a lot of documentation about SOAP services into PeopleTools but I din not find a strigh foward way of doing the sql quieres from ny 3rd party app

PeopleSoft integration with Google Apps for Business by Patricia Sanabria (guest), 05 Mar 2014 10:48

Web Designing Online Training by Webdesigningonlintraining We are providing excellent Web Designing Training by
real-time IT industry experts Our training methodology is very unique Our Course Content covers all the in-depth
critical scenarios. We have completed more than 100 Web Designing batches through Online Web Designing
Training program, Our Web Designing Classes covers all the real time scenarios, and its completely on Hands-on for each
and every session.

Contact Number : India :+91 (0) 8897931177,

Ecorp Trainings, One of the best institute providing quality level of training in E-learning & Corporate Services.

We offer instructor led online training. Classroom trainings are conducted in Hyderabad , India.

We provide training for almost all IT technologies, i.e : SAP, COGNOS, JAVA, ORACLE, IBM, ADOBE products etc.

For more details please visit-

Course Contents

ABAP Dictionary Concepts
Tables, Data Elements and Domains
Transparent, Pooled and clustered tables
Buffering, Indexes etc.,
Structure, Table types and Type pools
Views, Search helps and Lock objects
ABAP Programming Basics
Data Types, Variables, Types, Operators, Expressions etc
I/O Statements, Formatting commands
Conditional statements, Loops and termination statements
String and Date operations and System fields
Fields Strings and Text Elements
Internal Tables (All Operations)
Types of Internal Tables (Standard, Sorted and Hashed)
Joins, Nested selects Sub queries and For All Entries etc
Open SQL statements and performance issues
Messages (Creating and Calling etc.,)
Modularization (Subroutines, Function Modules, Macros and Includes)
Field Symbols
Debugging programs (Break Point, Watch points etc)
Extended syntax check, Runtime Analysis, Performance Trace
Classical Report Events
Control Level Commands (AT First, AT New etc).,
Selection Screen: Parameters
Select –options and variants
Selection screen designing (Blocks, Pushbuttons, Radio buttons etc)
Interactive report events
Menu painter: Designing and calling GUI Status
Hide, Read Line, Get cursor, Modify line, Window etc., statements
System fields of reports
Logical database (Designing, Events)
SAP Query (User groups, Info Sets and Queries)
ALV reporting
Dialog Programs
ABAP Memory and SAP Memory
LUW and Update bundling technique
Screens, flow logic events and Module pool
Basic Screen elements (I/O field, Radio buttons and Check box etc.,)
Maintaining screen sequences (Set screen, Call Screen and leave to screen)
Field checks (Automatic, flow logic and module pool)
Calling Programs (Submit, Call Transaction, Leave to list processing)
Sub screens and modal Screens
Table Controls, Step loops and Tab strips
File Handling
Local Files (Upload, Download etc)
Sequential Files (Open dataset, Read Dataset, Transfer etc.)
Files Formats
Logical Files and Physical files
Data Transfer Scenarios and methods
BDC session method (Creating, Processing, Analyzing and Correction errors in Sessions)
Recording Technique
BI Session features, Status and OK codes
Call Transaction method (Options, Tracing errors and Correction)
Background Processing (Creating, Scheduling and Monitoring Jobs)
LSMW (Methods, Steps and Conversions rules etc.)
SAP Scripts
Form designing (Pages, Windows, Page windows and Paragraphs etc.)
SAP Script symbols
Control commands
Standard Text and Styles
Inserting Logos (TIFF and Bitmap images)
Modifications to Form and Print program
Debugging, copying forms etc.
Smart Forms
Smart form and Form Logic
Calling a Form from print program
Different types of nodes (Page, Table, Loop etc)
Difference between SAP Script and Smart Forms
Changing SAP Standard
User Exits and Customer exits
Implementing Function, Menu, Screen exits
Distributed Systems
ALE Services and features
ALE Inbound and Outbound process
ALE Configuration (Logical systems, RFC Dest., Model view, Port, Partner Profiles etc)
ALE Distribution Scenarios
Transferring of Master Data (PUSH, PULL and Change Pointers)
Filtering concepts (IDOC and Segment filtering, Message reduction)
Features and structure of IDOC
Idoc type and Message type
Segment definition and components
Creating Segments
Creating Idoc types (Basics Type nd Extension)
Crating Message types and Process codes
Developing Selection and Posting programs
Idoc Enhancements
Introduction of RFC
Communication mechanisms through RFC
ABAP interfaces (RFC, tRFC, ARFC)
Difference between tRFC and ARFC
SAP Business Objects
Business Object Builder and BOR
Features and applications of BAPI
Creating Business Object types
Developing BAPIs
Working with a standard BAPI


USA : +1-703-445-4802

INDIA: +91-8143111555 ; +91-40-64643304 / 06

When I view this topic I don't see comments. Is there a way to show comments by default or for you to make a note on the article so people are notified of the fix?

Try PSChrome the PeopleSoft Browser Extension

by melbanmelban, 05 Mar 2014 06:52

Nice one Melban!

by PrajPraj, 04 Mar 2014 04:30

Google Chrome mad an adjustment in the way it handles frames and security. PeopleSoft isn't setting the domain properly in certain content pages so the frames target is breaking. I have corrected this error using my PSChrome Browser Extension. If you have it installed on Google Chrome it will correct the issue.

Try PSChrome the PeopleSoft Browser Extension

Chrome Issue by melbanmelban, 03 Mar 2014 19:16
mntriguy (guest) 26 Feb 2014 23:09
in discussion Forum / New Content » How to Display a Field Only Once in Each Page in RTF Template

If you are using the BI/XML Publisher plug in for Word, go to the BI Publisher Tab, place the cursor just before your Col1 table and click Insert>Repeating Group. You will get either a "for-each" or "F" code, and an "end for-each" or "E" code around your row. Move the end for-each/E to the end of your first row in Col2. That should give you one row of Col1 and Col2 data, then Col3,4, &5 will display multiple values.

Hope that helps!

by mntriguy (guest), 26 Feb 2014 23:09
hemanth (guest) 24 Feb 2014 12:49
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

hi i want certifications on peoplesoftHR and peoplesoft FSCM & HCM…i dont want any training..just certificates that i have done course in your institute..can u provide me such with some money…please do reply

by hemanth (guest), 24 Feb 2014 12:49
page »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License