My Oracle Support Banner

E-EC/E-FAB: Issue On Form Fields With Prompt Tables. Changing The Control Prompt Field Is Also Changing The 'Controlled' Prompt Fields (Doc ID 2562250.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

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

Symptoms

On : 8.56 version, Enterprise Components - Form and Approval Builder

Issue reported on Campus Solutions 9.2 PUM Image# 12; PT8.56.06.


On a Form, if user selects a value from a Prompt field, that controls other prompt fields, all 'controled' fields' values are set with the value selected by the user in the control field.
Moreover, the selected value is supposed to be used as a filter on the 'controled prompt fields. This is not happening.


The issue can be reproduced at will with the following steps (steps below just reflects an example of the use case):

 

1. Create two Record Views to be used as Prompt records.

/* PROMPT1_VW */

Key is:

- OPRID (Key, Required, Table Edit - OPRID_VW)

- EMPLID (Key, Search Key, List Box Item, Required, No Edit)

 

NAME is just a List Box Item. No Edit.

 

SQL:

SELECT A.OPRID

, A.EMPLID

, B.NAME

FROM %Table(PSOPRDEFN) A

, %Table(NAMES) B

WHERE B.EMPLID = A.EMPLID

AND B.NAME_TYPE = 'PRI'

AND ïfdtCheck(NAMES, B, %CurrentDateIn)

AND B.EFF_STATUS = 'A'

 

 

/* PROMPT2_VW */

Key is:

- EMPLID (Key, Search Key, List Box Item, Required, Table Edit - PEOPLE_SRCH)

- NAME (Key, Search Key, List Box Item, Required, No Edit)

 

SQL:

SELECT A.EMPLID

, A.NAME

FROM PS_PERSONAL_DATA A

 

 

2. Set the records as Prompt Record in Enterprise Components > Forms > Define Prompt Records.

3. Create a Form, with 2 prompt fields: Emplid and Name.

- Created new Homepage and added the Design Forms tile.

- Form ID: Z_TEST_001

- Label: Z Testing Forms => Note: I did not allowed spaces. Set Label to: Z_Testing_Forms

- Description: Z Testing Forms

- Status: In Design

- Effective From: 01/01/2010

- Effective Date To: <blank>

 

- Added Prompt Field Emplid - Field Properties:

- Use Type: Prompt

- Label: Emplid

- Field Status: Activated

- Field Description: <blank>

- Length: 20

- Required: No

- Prompt Record: Z_PROMPT_1_VW

- Setid: <blank>

 

- Prompt Control page

- Record Name: Z_PROMPT_2_VW

- Field Name: EMPLID

 

- Added Prompt Field Name - Field Properties:

- Use Type: Prompt

- Label: Name

- Field Status: Activated

- Field Description: <blank>

- Length: 20

- Required: No

- Prompt Record: Z_PROMPT_2_VW

- Setid: <blank>

- No instructions. No Approval.

- Set Security to Role PeopleSoft User.

- Added to My Homepage.

 

4. Fill out a new form

- In the Homepage, select the Tile Z_Testing_Forms.

- Click on Fill out a new form.

- Enter Description.

- When searching and selecting on Emplid, it sets the field with the EMPLID value.

- The ID is taken to the Name field. It should just have blanked it out.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.