Query Manager Multi-Ethnicity Expression - Local Variable as Counter

Hello. I have just started using Case When Expressions in Query Manager, and I am trying to write an expression to assign a single "Final Ethnicity" to each student. Student ethnicity data is stored in a table with 1 row for each ethnicity. A student who reported 1 ethnicity will have one row of data. A student who reported asian, pacific, and white will have 3 rows of data.


Hi I have a scenario-If there is an non-alpha numeric character in the file name that is uploaded,an error should be thrown.Is alphanumeric is not working.Help me with a solution.

Mutliple Values For Prompts in PS Query

I'm trying to build an 'In list' prompt HRS_PERSON_ID so that users can enter multiple HRS_PERSON_ID separated by a comma. is this possible in a PS query

Modal Seconday Page

I read through the peoplebooks in which it is mentioned if we select the option "Disable Display in Modal when not launched by DoModal peopleocde" the secondary page appears as a modal page over the primary page and not in a new window.

But irrespective of selecting or deselecting the option my secondary page is always shown in a new window. I am working on PeopleTools 8.53. Please suggest.

Also note that I have used DoModal Function to call secondary page.

Trace file in Application Engine

I have not defined any trace in process definition. Also at server level no default trace is ON.However when i execute my application engine a trace file (AE_AEname_processInstance.trc) is getting generated.

How to stop the generation of file as this is impacting the performance of program?

How to skip tables without update permission and continue processing in application Engine?

I am updating some records using application engine but some records does not have update permission....because of this application engine is going to "No SUCCESS"....i want to skip all these records and update other records which has update permission...what should i do??

How to pass HR payroll data to finance?

How Can I send HR Payroll data to Finance Using IB?
Please tell in details what I need to perform and How to test data that has been moved from HR to Payroll.


Hi ,
I need to display STATE field values as Pmopt table.
I tried STATE_TBL as Prompt table and in Page proerties --->Prompt table Field as DESCR,
But,whenever select (drag) drop down list of STATE,there is no value in drop down list.

Help me plzz...

PeopleSoft payables 9.1 do STOP payments on checks remain in unreconciled status

When we STOP a check a certain record "66" goes out to our bank ,
then we get a file back indicating a void or cancel ,,, it should process in app-engine delivered FSPRECON , yet my payment remains in unreconciled status ....
Should they be .... or is something missing , as they were stopped they are technically unreconciled .... but VOIDS are marked as reconciled "real time" .... Does anyone know what in their system STOP payments woudl be in regards to RECON_STATUS on the payment_tbl ? Thanks.


Can you please explain " Local %metadata:XMLPubRptMgr:RptTmpl &oInfo;" how to study this? i don't have any idea related %metadata.
it will be very helpful if you would like to share knowledge regarding this.