Set Attribute Values After You Convert Source Orders

Set the default value for an attribute after you convert the source order.

You can use Visual Information Builder to set the default value before you convert, but you must use an order management extension to set the value after you convert the source order.

Assume that if the order type is Standard orders, then you must set the default value for the legal entity, and you must do it after you convert the source order.

Get Values for Your Attributes

1. Get the order type and the ID for the legal entity.

   • Do an SQL.

     SELECT distinct LOOKUP_TYPE, LOOKUP_CODE                   
     FROM fusion.FND_LOOKUP_VALUES_TL
     WHERE LOOKUP_TYPE = 'ORA_DOO_ORDER_TYPES'
     order by 1, 2
     
     SELECT DISTINCT NAME, LEGAL_ENTITY_ID
     FROM fusion.HR_LEGAL_ENTITIES
     WHERE upper(name) LIKE '&LEGAL_ENTITY_NAME%'
     ORDER BY name
     

     For details, see Use SQL to Query Order Management Data.

Create an Order Management Extension

Test Your Setup

1. Go to the Order Management work area and create a sales order.

   Attribute	Value
   Order Type	Standard Orders

2. Notice the value in the legal entity attribute.

3. Click Submit.

4. Verify that the legal entity now contains 300000001563073.