Who's new

PeopleSoft - Prompt table

Hi,
I have two prompts, Business Unit (BU) and Location.
The location prompt is mapped to Location table and list all the location under the selected BU in the first prompt.

The requirement is the user should be able to see only those Locations which they have access within the selected BU. I created the view but the Location Prompt is not fetching any value (the query I written is fetching the value at the back end).

My doubt is how the BU prompt drives the Location prompt. What is the table key structure requirement.
Please suggest.

I have a page having fields namely Institution,Academic Year,Stream ,Term begin dt,Term End Dt fields respectively.
Requirement is that based upon the values of Institution,Academic Year,Stream field values the fields Term begin dt,Term End Dt should be dynamically prompted.

I created a dynamic view which selects the Institution,Academic Year,Stream ,Term begin dt,Term End Dt
fields from PS_TERM_TBL.

I wrote the peoplecode in the field change of
Stream field Field Change. But im not able to get the dynamic data from the prompt table. My Peoplecode goes like this

My component X does not have a search page. It has a field which has a prompt attached.
Once I click on the prompt, a search page opens on which 3 keys ans 3 alternate search keys open.
I want to default the value of one of these search keys to "abc" (existing value for this field).

Approaches:
1) Default the value on the record field properties of this record. Tries this bus does not work. Even after setting this, the prompt table field does not get defaulted on the search page.

2) Somehow access the prompt field in Peoplecode and enforce the default value over it.

I have three fields on my page which are using prompt:
Field1,Field2,Field3
The views behind these pompts pickup value from the same base table and there is no where clause involved.It is a simple select statement for three of them:
Field1 - Prompt table SQL - select Field1 from Table 1
Field2 - Prompt table SQL - select Field2 from Table 1
Field3 - Prompt table SQL - select Field3 from Table 1
I want to use the same view for all the three prompts if possible