Order Forecast Inbound Message
You can receive an order forecast message from your customers so that they can share their forecasts and consumption information for use in your enterprise's demand planning process.
You set up an order forecast inbound message as a part business process for customer collaboration. The Order Forecast – Inbound document is available after you enable the customer collaboration business process. The predefined message definition is Oracle-1-0-B2B-Order-Forecast-In.
When a customer sends a message, the message is transformed into a zip file with the
following naming convention:
<DocumentName>-1.0-<Message_GUID>.zip
. This zip file is
placed in Oracle content repository in the scm$/sccDataLoader$/import$
account and the Collaboration Customer Demand Uploads REST service is invoked.
Data Mapping
Here’s the data mapping for the Oracle-1-0-B2B-Order-Forecast-In message. You can also access the XSD file by exporting the message transformation package for additional information.
collaborationCustomerDemandUploads |
Oracle-1-0-B2B-Order-Forecast-In Message |
---|---|
B2BOrderForecast |
|
CustomerNumber |
ProcessingConfiguration/PartnerKey2 |
CustomerSiteNumber |
B2BOrderForecastMessage/B2BOrderForecast/Customer/SiteName |
B2BOrderForecast Lines |
|
ItemLevelValue |
B2BOrderForecastMessage/B2BOrderForecast/Lines/SupplierItemNumber |
OrganizationLevelValue |
B2BOrderForecastMessage/B2BOrderForecast/Lines/InventoryOrganizationCode |
MeasureTypeCode Note: Set to ORDER_FORECAST during processing.
|
|
B2BOrderForecast Schedules |
|
Quantity |
B2BOrderForecastMessage/B2BOrderForecast/Lines/Schedules/Quantity |
Date Note: Date format is YYYY-MM-DD (The format is truncated if time is
provided).
|
B2BOrderForecastMessage/B2BOrderForecast/Lines/Schedules/Date |
Sample Payload
Here’s a sample input payload and a transformed output payload for the Oracle-1-0-B2B-Order-Forecast-In message.
Input Payload<?xml version="1.0" encoding="UTF-8"?>
<B2BOrderForecastMessage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/apps/scm/cmk/b2b">
<B2BHeader>
<MessageId/>
<MessageDateTime/>
<SenderId/>
<SenderIdType/>
<IntermediaryId/>
<IntermediaryIdType/>
<ReceiverId/>
<ReceiverIdType/>
</B2BHeader>
<B2BOrderForecast>
<Customer>
<SiteName>456</SiteName>
</Customer>
<Lines>
<SupplierItemNumber>AI-F-Pin</SupplierItemNumber>
<InventoryOrganizationCode>M1</InventoryOrganizationCode>
<Schedules>
<Quantity>0</Quantity>
<Date>2020-09-21</Date>
</Schedules>
</Lines>
<Lines>
<SupplierItemNumber>AI-F-Pin</SupplierItemNumber>
<InventoryOrganizationCode>M2</InventoryOrganizationCode>
<Schedules>
<Quantity>0</Quantity>
<Date>2020-09-21</Date>
</Schedules>
</Lines>
<Lines>
<SupplierItemNumber>AI-F-Pin</SupplierItemNumber>
<InventoryOrganizationCode>M3</InventoryOrganizationCode>
<Schedules>
<Quantity>0</Quantity>
<Date>2020-09-21</Date>
</Schedules>
</Lines>
<Lines>
<SupplierItemNumber>AI-F-Pin</SupplierItemNumber>
<InventoryOrganizationCode>MFG2</InventoryOrganizationCode>
<Schedules>
<Quantity>40</Quantity>
<Date>2022-01-04</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-07</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-11</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-13</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-15</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-18</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-20</Date>
</Schedules>
<Schedules>
<Quantity>40</Quantity>
<Date>2022-01-24</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-25</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-01-28</Date>
</Schedules>
<Schedules>
<Quantity>20</Quantity>
<Date>2022-02-05</Date>
</Schedules>
</Lines>
</B2BOrderForecast>
</B2BOrderForecastMessage>
<?xml version="1.0" encoding="UTF-8"?>
<cmk:Request xmlns:b2b="http://xmlns.oracle.com/apps/scm/cmk/b2b" xmlns:cmk="http://xmlns.oracle.com/apps/scm/cmk" xmlns:ns8="http://xmlns.oracle.com/apps/scm/supplyCollaboration/collaboration/forecastService/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns13="http://xmlns.oracle.com/apps/scm/supplyCollaboration/collaboration/forecastService/">
<cmk:InboundCollaborationDocument xsi:type="">
<cmk:DemandCollaboration>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>M1</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>0</cmk:Quantity>
<cmk:Date>2020-09-21</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>M2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>0</cmk:Quantity>
<cmk:Date>2020-09-21</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>M3</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>0</cmk:Quantity>
<cmk:Date>2020-09-21</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>40</cmk:Quantity>
<cmk:Date>2022-01-04</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-07</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-11</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-13</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-15</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-18</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-20</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>40</cmk:Quantity>
<cmk:Date>2022-01-24</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-25</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-01-28</cmk:Date>
</cmk:PlanningMeasure>
<cmk:PlanningMeasure>
<cmk:CustomerNumber/>
<cmk:CustomerSiteNumber>456</cmk:CustomerSiteNumber>
<cmk:ItemLevelValue>AI-F-Pin</cmk:ItemLevelValue>
<cmk:OrganizationLevelValue>MFG2</cmk:OrganizationLevelValue>
<cmk:MeasureTypeCode>ORDER_FORECAST</cmk:MeasureTypeCode>
<cmk:Quantity>20</cmk:Quantity>
<cmk:Date>2022-02-05</cmk:Date>
</cmk:PlanningMeasure>
</cmk:DemandCollaboration>
</cmk:InboundCollaborationDocument>
</cmk:Request>