E-PC: Setting Dynamic Prompt Table On Search Record (Doc ID 1942090.1)

Last updated on NOVEMBER 10, 2014

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

When trying to set a dynamic prompt table on a Search Record inside a Search Page, using Component Record PeopleCode and SetEditTable function, the following error comes up "There are no prompt values currently available for this field. (4,4) "

Steps:
---------
1. Sign in to Application Designer

2. Open the search record <Record_Name> in which you have the field you want to have a dynamic prompt
3. Set the Table Edit for the field to Prompt Table Edit and the Prompt Table to %EDITTABLE
4. In PeopleCode on SearchInit event for the search record place the following code
      Local Rowset &rs0 = GetLevel0();
      Local Record &rec = &rs0(1).GetRecord(Record.Record_Name);

      &rec.SetEditTable("%EDITTABLE", @("Record." | DERIVED.EDITTABLE));
      &rec.ExecuteEdits(%Edit_PromptTable);

Error:
--------
There are no prompt values currently available for this field. (4,4)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms