Additional Column For Requisition Header Flexfields LOV Not Showing In iProcurement
(Doc ID 3029885.1)
Last updated on JUNE 24, 2024
Applies to:
Oracle iProcurement - Version 12.2.11 and laterInformation in this document applies to any platform.
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
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 |