Set Default Values for Scheduled Ship Date

Set the default value for the Schedule Ship Date attribute on the fulfillment line.

You will create an example rule.

• If the source order header includes PMC, then set the default value for Scheduled Ship Date to the current date.

Note

• Use Visual Information Builder.

• Enter Source Order (Order Header) when you create the If clause.

• Enter values when you create the Then clause.

  • Override Schedule (Order Fulfill Line)

  • Scheduled Ship Date (Order Fulfill Line)

Verify You Collected Shipping Attributes

As an option, you can verify you collected shipping attributes that affect the Schedule Ship Date.

The orchestration process uses shipping attributes when it orchestrates shipment during fulfillment.

• Carrier

• Method of Transport

• Service Level

Here's an example payload that includes them.

<coresalesorder:ProcessSalesOrderFulfillment>
<coresalesorder:ModeOfTransportCode>AIR</coresalesorder:ModeOfTransportCode> <coresalesorder:ServiceLevelCode>1ST</coresalesorder:ServiceLevelCode>
<corecom:PaymentTerm>
  <corecom:Code>24</corecom:Code>
</corecom:PaymentTerm>
<corecom:CarrierPartyReference>
  <corecom:PartyIdentification>
    <corecom:ApplicationObjectKey>
      <corecom:ID>DHL</corecom:ID>
    </corecom:ApplicationObjectKey>
  </corecom:PartyIdentification>
</corecom:CarrierPartyReference>

Use SQL to confirm you collected this data.

select 
mai.instance_code
, mxm.entity_name 
, mxm.attribute_name
, mxm.Source_value
, mxm.target_value
from 
  MSC_XREF_MAPPING MXM
, MSC_APPS_INSTANCES MAI
where upper(entity_name) in ('WSH_SERVICE_LEVELS','WSH_MODE_OF_TRANSPORT','CARRIERS') AND
  (source_value = 'DHL' or Source_value = 'AIR' or Source_value = '1ST') AND
  MAI.instance_id = MXM.SR_instance_id AND
  MAI.instance_code = 'LEG'
order by 
  ENTITY_NAME
, SOURCE_VALUE;

Assume your query returns results.

INSTANCE CODE	ENTITY NAME	ATTRIBUTE NAME	SOURCE VALUE	TARGET VALUE
LEG	CARRIERS	CARRIER_ID	DHL	32512
LEG	WSH_MODE_OF_TRANSPORT	LOOKUP_CODE	AIR	39
LEG	WSH_SERVICE_LEVELS	LOOKUP_CODE	1ST	15

Next, get details about the service level and mode of transport. Query according to the lookup codes from the result of your first query.

SELECT 
 lookup_code
, lookup_type
, meaning
, enabled_flag
, start_date_Active
, end_date_Active
FROM 
 MSC_SR_LOOKUP_VALUES_vl
WHERE LOOKUP_CODE IN (15,39)
order by 
  lookup_code;

Here's the result.

LOOKUP_CODE	LOOKUP_TYPE	MEANING	ENABLED_FLAG	START_DATE_ACTIVE	END_DATE_ACTIVE
15	WSH_SERVICE_LEVELS	1st Class	Y	01-JAN-59	Not applicable
39	WSH_MODE_OF_TRANSPORT	Air	Y	01-JAN-59	Not applicable

Next, get details about the carrier. Query according to the lookup code for the carrier from the result of your first query.

SELECT 
  tp_id
  , partner_name
  , party_id
FROM FUSION.MSC_GLOBAL_TRADING_PARTNERS 
  where tp_id = 32512;

Here's the result.

TP_ID	PARTNER_NAME	PARTY_ID
32512	DHL	DHL