35/36
Importing Null Values - Attributes Not Supported
List of Attributes Not Supported During Importing Null Values
To import a null value for certain attributes of an order and its entities, IMPORT_NULL_VALUES attribute in headers interface table (OE_HEADERS_IFACE_ALL) must be set to ‘Y’ for that order and Null Indicators that are defined as Meanings in the lookup Null Indicators for Attributes in Order Import for each data type should be passed for those attributes. However there are certain attributes in the interface tables that are not supported to be imported with Null values via Null Indicators.
Headers Iface
| SOLD_TO_ORG_CONTACT_ID |
| SOLD_TO_PARTY_ID |
| SHIP_TO_PARTY_ID |
| SHIP_TO_PARTY_SITE_ID |
| SHIP_TO_PARTY_SITE_USE_ID |
| DELIVER_TO_PARTY_ID |
| DELIVER_TO_PARTY_SITE_ID |
| DELIVER_TO_PARTY_SITE_USE_ID |
| INVOICE_TO_PARTY_ID |
| INVOICE_TO_PARTY_SITE_ID |
| INVOICE_TO_PARTY_SITE_USE_ID |
| END_CUSTOMER_PARTY_ID |
| END_CUSTOMER_ORG_CONTACT_ID |
| END_CUSTOMER_PARTY_SITE_ID |
| END_CUSTOMER_PARTY_SITE_USE_ID |
| END_CUSTOMER_PARTY_NUMBER |
| SOLD_TO_PARTY_NUMBER |
| SHIP_TO_PARTY_NUMBER |
| INVOICE_TO_PARTY_NUMBER |
| DELIVER_TO_PARTY_NUMBER |
| ORIG_SYS_CUSTOMER_REF |
| ORIG_SHIP_ADDRESS_REF |
| ORIG_BILL_ADDRESS_REF |
| ORIG_DELIVER_ADDRESS_REF |
| SOLD_TO_CONTACT_REF |
| SHIP_TO_CONTACT_REF |
| BILL_TO_CONTACT_REF |
| DELIVER_TO_CONTACT_REF |
| CANCELLED_FLAG |
| CLOSED_FLAG |
| REJECTED_FLAG |
| RESPONSE_FLAG |
| READY_FLAG |
| FORCE_APPLY_FLAG |
| BOOKED_FLAG |
| ORDER_SOURCE_ID |
| ORDER_SOURCE |
| CHANGE_SEQUENCE |
| ORG_ID |
| OPERATION_CODE |
| ERROR_FLAG |
| STATUS_FLAG |
| REQUEST_ID |
| INTERFACE_STATUS |
| INST_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| XML_MESSAGE_ID |
| XML_TRANSACTION_TYPE_CODE |
| INELIGIBLE_FOR_HVOP |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Lines Iface
| INVENTORY_ITEM_SEGMENT_1 |
| INVENTORY_ITEM_SEGMENT_2 |
| INVENTORY_ITEM_SEGMENT_3 |
| INVENTORY_ITEM_SEGMENT_4 |
| INVENTORY_ITEM_SEGMENT_5 |
| INVENTORY_ITEM_SEGMENT_6 |
| INVENTORY_ITEM_SEGMENT_7 |
| INVENTORY_ITEM_SEGMENT_8 |
| INVENTORY_ITEM_SEGMENT_9 |
| INVENTORY_ITEM_SEGMENT_10 |
| INVENTORY_ITEM_SEGMENT_11 |
| INVENTORY_ITEM_SEGMENT_12 |
| INVENTORY_ITEM_SEGMENT_13 |
| INVENTORY_ITEM_SEGMENT_14 |
| INVENTORY_ITEM_SEGMENT_15 |
| INVENTORY_ITEM_SEGMENT_16 |
| INVENTORY_ITEM_SEGMENT_17 |
| INVENTORY_ITEM_SEGMENT_18 |
| INVENTORY_ITEM_SEGMENT_19 |
| INVENTORY_ITEM_SEGMENT_20 |
| SHIP_TO_PARTY_ID |
| SHIP_TO_PARTY_SITE_ID |
| SHIP_TO_PARTY_SITE_USE_ID |
| DELIVER_TO_PARTY_ID |
| DELIVER_TO_PARTY_SITE_ID |
| DELIVER_TO_PARTY_SITE_USE_ID |
| INVOICE_TO_PARTY_ID |
| INVOICE_TO_PARTY_SITE_ID |
| INVOICE_TO_PARTY_SITE_USE_ID |
| END_CUSTOMER_PARTY_ID |
| END_CUSTOMER_ORG_CONTACT_ID |
| END_CUSTOMER_PARTY_SITE_ID |
| END_CUSTOMER_PARTY_SITE_USE_ID |
| END_CUSTOMER_PARTY_NUMBER |
| SHIP_TO_PARTY_NUMBER |
| INVOICE_TO_PARTY_NUMBER |
| DELIVER_TO_PARTY_NUMBER |
| ORIG_BILL_ADDRESS_REF |
| ORIG_DELIVER_ADDRESS_REF |
| ORIG_SHIP_ADDRESS_REF |
| SHIP_TO_CONTACT_REF |
| BILL_TO_CONTACT_REF |
| DELIVER_TO_CONTACT_REF |
| CANCELLED_FLAG |
| REJECTED_FLAG |
| ORDER_SOURCE_ID |
| CHANGE_SEQUENCE |
| ORG_ID |
| OPERATION_CODE |
| ERROR_FLAG |
| STATUS_FLAG |
| REQUEST_ID |
| INTERFACE_STATUS |
| INST_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_SHIPMENT_REF |
| SPLIT_FROM_LINE_REF |
| SPLIT_FROM_SHIPMENT_REF |
| XML_TRANSACTION_TYPE_CODE |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Price Adjustment Iface
| CHANGE_SEQUENCE |
| OPERATION_CODE |
| INTERFACE_STATUS |
| ERROR_FLAG |
| STATUS_FLAG |
| INST_ID |
| ORDER_SOURCE_ID |
| REQUEST_ID |
| ORG_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DISCOUNT_REF |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_SHIPMENT_REF |
| PROGRAM_ID |
Price Attributes Iface
| CHANGE_SEQUENCE |
| OPERATION_CODE |
| INTERFACE_STATUS |
| ERROR_FLAG |
| STATUS_FLAG |
| INST_ID |
| ORDER_SOURCE_ID |
| REQUEST_ID |
| ORG_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_ATTS_REF |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_SHIPMENT_REF |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Credits Iface
| CHANGE_SEQUENCE |
| OPERATION_CODE |
| INTERFACE_STATUS |
| ERROR_FLAG |
| STATUS_FLAG |
| INST_ID |
| ORG_ID |
| ORDER_SOURCE_ID |
| REQUEST_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_CREDIT_REF |
| ORIG_SYS_SHIPMENT_REF |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Lotserial Iface
| ERROR_FLAG |
| ORDER_SOURCE_ID |
| CHANGE_SEQUENCE |
| INTERFACE_STATUS |
| STATUS_FLAG |
| REQUEST_ID |
| INST_ID |
| ORG_ID |
| OPERATION_CODE |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_SHIPMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_LOTSERIAL_REF |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Payments Iface
| CHANGE_SEQUENCE |
| OPERATION_CODE |
| INTERFACE_STATUS |
| ERROR_FLAG |
| STATUS_FLAG |
| INST_ID |
| ORDER_SOURCE_ID |
| REQUEST_ID |
| ORG_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_PAYMENT_REF |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_SHIPMENT_REF |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |
Billing Plans Iface
| ORDER_SOURCE_ID |
| CHANGE_SEQUENCE |
| ORG_ID |
| OPERATION_CODE |
| ERROR_FLAG |
| REQUEST_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_BILL_PLAN_HDR_REF |
| ORIG_SYS_BILL_PLAN_LINE_REF |
| ORIG_SYS_BPLAN_USG_TIER_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_SHIPMENT_REF |
| OE_PAYMENTS_IFACE_ALL |
| ERROR_FLAG |
| ORDER_SOURCE_ID |
| CHANGE_SEQUENCE |
| ORG_ID |
| INTERFACE_STATUS |
| STATUS_FLAG |
| OPERATION_CODE |
| REQUEST_ID |
| INST_ID |
| SOLD_TO_ORG |
| SOLD_TO_ORG_ID |
| ORIG_SYS_DOCUMENT_REF |
| ORIG_SYS_LINE_REF |
| ORIG_SYS_PAYMENT_REF |
| ORIG_SYS_SHIPMENT_REF |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| PROGRAM_APPLICATION_ID |