Additional Column For Requisition Header Flexfields LOV Not Showing In iProcurement (Doc ID 3029885.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

When setting Requisition Header DFF(Descriptive Flexfield) with Table value set with additional column,
additional column is not shown in iProcurement.
 In core Requisition form, Requisition Header DFF shows additional column fine.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create and setup Requisition header DFF with table value set with additional column
     ex) Supplier / Site

 N) System Administrator responsibility: Application -> Flexfield -> Descriptive -> Segments
    - Go to Value set for the target Segments

- Value Set
Format Type = Character
List Type = List of Values
Validation Type = table
Security Type = No Security

- Validation Table Information
Table Name: AP_SUPPLIERS S1,ap_supplier_sites_all S2
Table Columns = S1.VENDOR_NAME
ID: VENDOR_SITE_ID
Where / Order by:  S1.VENDOR_ID = S2.VENDOR_ID
Additional Columns: S2.VENDOR_SITE_CODE Site

 - Save, compile flexfield

2. In core Requisition forms, the DFF LOV search shows two columns
      Supplier  / Site

3. In iProcurement, in the Edit and Submit requisition, the DFF LOV searh
    shows only the Supplier, not Site column

Changes

Cause

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