My Oracle Support Banner

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:

Oracle Order Management - Version 12.2.2 and later
Information in this document applies to any platform.


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.


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.


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

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