Default Value Of Header Descriptive Flex Field (DFF) Not Populated in Internal Sales Order (ISO) (Doc ID 2056957.1)

Last updated on JANUARY 07, 2022

Applies to:

Goal

Sales Order header DFF is defined to be validated against a custom value set and to have a default value of type SQL Statement:
      select attribute1 from po_requisition_headers_all where requisition_header_id = :ORDER.source_document_id
However, the DFF does not gets populated upon order creation (back end table), it only takes a value when the DFF is opened from the front end.

STEPS

1. PO responsibility > Create Internal Requisition > run Create Internal Sales Order
2. Order Management (OM) responsibility > Run Order Import to create the Internal Sales Order
3. Check the back end and see that the DFF is not populated
4. But if you open the order, you can see the DFF is there - The DFF only gets populated when clicking on it.

Solution

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