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 |