Hi gurus..

I am having issue in nVsion tabular layout from PIA.

Layout is based in PS query having 4 prompt fields. Report is running fine with 2-Tier. When running from PIA, it's going to error" Prompt values missing, Provide prompt values for all parameters."

we are having 9.1, so there is delivered "Prompt fields" tab on Define report request page.

Any help will be appreciated.
Thanks

HI,

Can anybody help me out with the sql to get the list of tables having specific field as key in the entire database.

ex: In HCM I want to find the list of tables having EMPLID as key field.

Thanks in advance,

Regards
Mastan.

Hi all,
My requirement is,
1. in a page PROCESS NAME is prompt table. if we select any one procee name.
2. insert pushbutton( when we click on it)
3.insert grid with 3 fields like OPRID,RUNCONTROL_ID, and one Checkbox.

Explanation is when we click on pushbutton based on processname those related data like oprid,runcontrol id values will populate into grid.

Now Q is prompt table is VW record
can i take WRK with 3 fields or 2 fields like oprid, run id.
what code i write in pushbutton.
i am new from peoplesoft..

please help me any one knows..
Regards
Guest

I am to create an AE to mass load position data component for JObcode change. Here are my issues
1. User needs a runcontrol page to load the file from their local directory and the file needs to be read by our AE.

Hi All,

Can you help me to follow the mandatory things while doing Upgradation from one version to another version.
Explain me briefly or stepwise process for the Upgradation in Peoplesoft.

Thanks in Advance,
Sara

1.i want to display the user id in page who is logging to the current application. I have written this query in the particular field in the page.

select oprid from psoprdefn where oprid=%operatorid;

but i am getting error. could u tell me is this correct or wrong.

2.how to count the number of lines in the grid for particular user id.?

Thanks and Regards,
Prabu

Hi All,
How to get the data from the permission list that will show the level of access (if any) to Application Designer.

Thanks a lot !!!

Hi All,

I am able to configure MCF_GETMAIL node with all the details. (Server,email user ID,Password,Protocol,port# etc..).

When I am testing it on to PeopleTools > MultiChannel Framework > Email > Sample Pages with all the details I am getting an error.

Error:
Cannot connect to mail server.

I have tried two options to cross verify the Server,email user ID,Password,Protocol,port# etc..). deails

1. Was able to connect to the mail server(mail server and pop server too) via telnet from the machine where PeopleSoft instance is hosted.

Hi,
I want to show logo in the report based on the business unit selected.
I want to know how this can be achieved.
Please help.

Hi,

When i ping my local node i am getting the error as "PSFT Authentication token failed for Node PSFT_HR". Can any please help in this regard.

I have also added my the local node in the navigation :- PeopleTools -> Security --> Security Objects --> Single Singon. Even then i am getting the above error.