Peoplesoft

Automate mark worked

Hi,

I very new to Peoplesoft and am working on migrating 8.9 to 9.1
A new requirement which is currently holding me up is automating mark worked in the worklist. To elaborate : whenever a particular item has been succesfully performed the 'mark worked' function should kick in immediately and automatically instead of clicking on the mark worked button at the work list.

Any help would be greatly appreciated.

Thanks

Alim

lable change

Hi all

i want to change lable name dynamically....
that field has prompt table, when we click on prompt table that field name also should change to new lable name.....

please tel me the answer......

PS QUERY in to SQR

hi all,
is there any possiblity to convert ps query in to an SQR,
pls let me know,thanks

Can any body tell how to scramble the data in PeopleSoft

Hi all,
Can any body tell how to scramble the data in PeopleSoft.

Thanks in advance

SQL Question on Full Outer Join

Hi, I am writing a sql select statement. First, I need to get all courses and if they have textbooks, include the textbooks. (this is my new data extract). That's the first select and it works great. Then I need to take this file and do a full outer join with another file. (this is my previous old data extract, it does contain some extra fields, so not the exact same table layout). I should get a mixture of some records are only in the first select, others in both files and some only in the file I'm joining with.

dynamic sql

Hi,

I have created two promt tables for two fields : x_category and x_model
based on category i shud get the model types ,so for tat i have used the dynamic sql concept.
below is the code :

Local string &categ = EXO_CUST_DYANM.EXO_CATEGORY_K;

Evaluate &categ
When "TV"
EXO_CUST_DYANM.EXO_MODEL_K.SqlText = "SELECT EXO_MODEL_K ,EXO_CATEGORY_K FROM PS_EXO_MODEL_PROM WHERE EXO_CATEGORY_K='TV' ";
Break;
When "MOBILE"
EXO_CUST_DYANM.EXO_MODEL_K.SqlText = "SELECT EXO_MODEL_K ,EXO_CATEGORY_K FROM PS_EXO_MODEL_PROM WHERE EXO_CATEGORY_K='MOBILE' ";
Break;
When "LAPTOP"

PeopleCode calling java: no class def for dependent jars

I created a very simple java class with a method that takes one parameter, a unique id. It then finds the object in Documentum matching that ID, gets the content file from Documentum and stores it locally. The method returns the full path to the local content file. My class depends on a half dozen Documentum DFC jar files. We put my jar file and the dependent ones into %PS_HOME%/appserv/classes/ .

How to load bulk changes to the employee records on PeopleSoft?

Hi,

Can anyone shed some light on loading bulk changes to the employee records on PeopleSoft?

Thanks!

how to create xmlp reports using data source as xml file

Hi,

How to run the xml file in xmlp.please provide me the steps.

Thanks in advance.

how to create sub template in xmlp

Hi,

How can we create a sub template and call in main template. please give me an example on sub templates.

Thanks in advance.