Defining Prompts



  1. Begin by navigating to the Criteria page.


    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. In this example, you will search for the PT_SEC_ACCESSLOG_DAY query.


    Enter the desired information into the begins with field. Enter

     a valid value

    Step 3
  4. Click the Search button.

    Step 4
  5. Select the PT_SEC_ACCESSLOG_DAY query.


    Click an entry in the Edit column.

    Step 5
  6. Click the Criteria tab.

    Step 6
  7. Use the Add Criteria button to access the Edit Criteria Properties page.


    Click the Add Criteria button.

    Step 7
  8. Use the Edit Criteria Properties page to determine how this field is used as a criterion for the current query.

    Step 8
  9. Click the Select Record and Field button.

    Step 9
  10. Click the User ID link.

    Step 10
  11. Click the Prompt option.

    Step 11
  12. Click the New Prompt link.

    Step 12
  13. Use the Edit Prompt Properties page to add or edit runtime prompts.

    Step 13
  14. Use the Field Name field to select the field for the prompt.

    Step 14
  15. Use the Heading Type field to define a heading type for the prompt:

    •  RFT Long: The long name from the field definition.

    •  RFT Short: The short name from the field definition.

    •  Text: Any label that you enter.

    Step 15
  16. Use the Type, Format, and Length fields to view the field attributes that default from the field definition that developers create in Oracle PeopleSoft Application Designer.

    Step 16
  17. Use the Edit Type field to define the type of field edit  for the specified field.

    Step 17
  18. Click the Edit Type list.

    Step 18
  19. The No Table Edit option enables you to enter any value. No validation exists on this edit type.

    Step 19
  20. The Prompt Table option enables you to search and select only values that exist in a prompt table.

    Step 20
  21. The Translate Table option enables you to select from a list of values specific to this field that exist in the Translate table.

    Step 21
  22. The Yes/No Table option enables you to select or clear check boxes.

    Step 22
  23. Click the Prompt Table list item.

    Step 23
  24. If the edit type is Prompt Table, you can select a prompt table to use.


    Click the Prompt Table look up button.

    Step 24
  25. Click the Search button.

    Step 25
  26. Click the Classid/Menu Items link.

    Step 26
  27. The selected prompt appears in the Prompt Table field.

    Step 27
  28. Click the OK button.

    Step 28
  29. Click the OK button.

    Step 29
  30. Click the Save button.

    Step 30

You have successfully defined prompts.

Table of Contents  Start Topic