PRC:POZ The Supplier DFF Default Value Doesn't Set From FND_LOOKUP_VALUES (Doc ID 2975105.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Goal

If the default value of the DFF context field is set to 'YES' and this DFF value set is selected from FND_LOOKUP_VALUES_VL,
we expected that 'YES' is set by default in the supplier DFF context field while creating a new supplier.
However, the value of this context field will be NULL and will not default to YES.

Step by Steps
Setup the Flexfield Code:POZ_SUPPLIER and Standard Lookup codes as below.
Ex)
- Setup and Maintenance > Task > Manage Supplier Descriptive Flexfields
Context:sup_con01
Name:SupDFF01
Value Set:Sup_TEST_FLAG
Default Type:Constant
Default Value:YES

Value Set Definition:
Value Set Code:Sup_TEST_FLAG
Value Column Name: MEANING
FROM Clause:FND_LOOKUP_VALUES_VL
WHERE Clause: LOOKUP_TYPE = 'Sup_TEST_FLAG'

- Setup and Maintenance > Task > Manage Standard Lookups
Lookup Type:Sup_TEST_FLAG
Lookup Codes:
LookupCode Meaning
-----------------------
N               NO
Y               YES

Result:
1.Go to Procurement > Suppliers > Create supplier
2.At "Edit Supplier" screen, if you select 'Attribute Value' as "sup_con01",
  the context field "SupDFF01" will be displayed but the default value YES will not be set.

Solution

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