Hey hi I am just working with Dynamic prompt my requirement is
> When I select country name from ddl i.e India, In the next state field I want to get prompt table regarding indian states
> When I select country name from ddl i.e usa, In the next state field I want to get prompt table regarding usa states
For this I have created two views on PS_STATE_TBL , to use for prompting
india
SELECT DESCR FROM PS_STATE_TBL WHERE COUNTRY ='IND';
usa
SELECT DESCR FROM PS_STATE_TBL WHERE COUNTRY ='USA' AND DESCR NOT LIKE '%tax';
>>Next I have written the following code in FieldChange event
Evaluate DYNAMIC_TBL1.COUNTRY1
When "I"
DERIVED.EDITTABLE = "RECORD.INDIA_PROMPT_VW";
Break;
When "U"
DERIVED.EDITTABLE = "RECORD.USA_PROMPT_VW";
Break;
When-Other
End-Evaluate;
But from the front end I am getting the following error message
Prompt table in the DERIVED.EDITTABLE is not available. (4,3)
the prompt table for the field for the field is controlled by the contents of another field. this controlling field is not included in the component.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Do U really require Dynamic prompt here.. doesn't tools already support this by Keys where country is the Key in state table???
Thanks
Nitin