Table Validation

In this practice, you will use an application table to validate a descriptive flexfield segment. You will create a table-validated value set to validate employee numbers based on a Human Resources application table called PER_ALL_PEOPLE_F. Then you will add an additional segment to the descriptive flexfield structure you defined in the Define a Descriptive Flexfield practice to track the salesperson’s employee number.
Define your Value Set
Responsibility: System Administrator
1- (N) Application > Validation > Set. Enter the information for the value set in the following fields:
• Value Set Name: INAM_EMP_NUM
• Description: INAM Employee Number Value Set
• Security Type: Non-Hierarchical
• List Type: Long List of Values
• Format Type: Char
• Maximum Size: 30
• Validation Type: Table

2-  Click (B) Edit Information to navigate to the Validation Table Information window.Use the lists of values in the Table Application to select Human Resources as the table application type PER_ALL_PEOPLE_F as the table name.
In the Table Columns region, use the lists of values in the following fields:
                    Name                                Type          Size
Value        EMPLOYEE_NUMBER     VarChar2    30
Meaning    FULL_NAME                     VarChar2    240

3- In the Where/Order By field, enter
WHERE CURRENT_EMPLOYEE_FLAG = ‘Y’

Save your work.
Define your Structure
1- (N) Application > Flexfield > Descriptive > Segments. Query your descriptive flexfield (eg; Journal Categories)  in the Descriptive Flexfield Segments window.

2- Clear the Freeze Flexfield Definition check box.
3- In the Context Field Values region, select the Global Data Elements context and click (B) Segments to navigate to the Segments Summary window.
4- Keep the two segments you defined previously. Enter the information for the third segment in the following fields (pic below):

If you don't have any segment then you can delete any existing one as I did this for this practice.

 Save your work.
5- Navigate back to the Descriptive Flexfield Segments window. Select the Freeze Flexfield Definition check box. Click (B) Compile to compile the flexfield definition. Click (B) OK to each note about submitting your request to generate the flexfield view.
Test your Descriptive Flexfield
After defining your value set and segment, navigate to your descriptive flexfield using the General Ledger Super User responsibility and test the results of your work. When you are finished, exit without saving