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

Last updated on SEPTEMBER 20, 2017

Applies to:

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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms