1. Configuring and Managing B2B Messaging
  2. Order Forecast Inbound Message

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>
Output Payload 
<?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>