This chapter covers the following topics:
Creates order header and lines in booked status by populating the order import interface tables.
This flow uses single data in the creation of order lines.
Open Interface
Order_Import_OI
The following are the prerequisites for executing the flows:
Customers and Contacts.
Defaulting rules should be set up that will populate other required fields during Order Import, such as Order Type, Price List, Salesrep, etc, which are not passed to the interface table in this script.
Not Applicable
The following predefined data must be used:
| Entity | Field Name | Field Value |
|---|---|---|
| User | User Id | 1318 |
| Responsibility | Resp Id | 21623 |
The following data must be set up:
| Interface | Field Name | Field Value |
|---|---|---|
| OE_HEADERS_IFACE_ALL | ORDER_SOURCE_ID | 1227 |
| ORIG_SYS_DOCUMENT_REF | 12345 | |
| SOLD_TO_ORG_ID | 1005 | |
| CREATED_BY | -1 | |
| CREATION_DATE | sysdate | |
| LAST_UPDATED_BY | -1 | |
| LAST_UPDATE_DATE | sysdate | |
| OPERATION_CODE | INSERT | |
| BOOKED_FLAG | Y | |
| OE_LINES_IFACE_ALL | ORDER_SOURCE_ID | 1227 |
| ORIG_SYS_DOCUMENT_REF | 12345 | |
| ORIG_SYS_LINE_REF | 1 | |
| INVENTORY_ITEM_ID | 249 | |
| ORDERED_QUANTITY | 10 | |
| OPERATION_CODE | INSERT | |
| CREATED_BY | -1 | |
| CREATION_DATE | sysdate | |
| LAST_UPDATED_BY | -1 | |
| LAST_UPDATE_DATE | sysdate |
Following are the details of the scenarios in the flow:
| Scenario | Objective | Artifact Method | Component Set | Main Component |
|---|---|---|---|---|
| Order_Import | This scenario populates OM interface tables to create a Sales Order header with order line in booked status | Order_Import_OEOIMP | Order_Import_OEOIMP | Order_Import_OEOIMP |
| Verification | - | VERIFICATION_COMPONENT | ||
| Display_Order_Number | - | SELECT |