Shulou(Shulou.com)06/01 Report--

Tables related to OM APIs:

1. OE_HEADERS_IFACE_ALL

This table is a multi-organization table and is used to insert sales order headers into the open interface.

This table stores order header information from other subsystems that need to import OM modules.

The fields / conditions that must be entered when the table is imported:

ORDER_SOURCE_ID: Order source id optional

ORIG_SYS_DOCUMENT_REF: Original system document reference must

ORDER_SOURCE: Order source optional

OPERATION_CODE: Operation code must

ORDER_TYPE_ID: Order type id optional

ORDER_TYPE: Order type optional

RETURN_REASON_CODE: Return reason code is only used for order return

SALESREP_ID: Salesrep id

PRICE_LIST_ID: Price list id for orders that have already been booking

PRICE_LIST: Price list for orders that have already been booking

Example:

Insert into oe_headers_iface_all (ORDER_SOURCE_ID,orig_sys_document_ref,ORG_ID,order_type_id,PRICE_LIST_ID,TRANSACTIONAL_CURR_CODE,SOLD_TO_ORG_ID,SHIP_TO_ORG_ID,created_by,creation_date,last_updated_by,last_update_date,operation_code) select ooha.order_source_id,ooha.orig_sys_document_ref,ooha.org_id,ooha.order_type_id,ooha.price_list_id Ooha.TRANSACTIONAL_CURR_CODE,ooha.SOLD_TO_ORG_ID,ooha.SHIP_TO_ORG_ID,ooha.created_by,ooha.creation_date,fnd_global.user_id,sysdate,p_operation_codefrom oe_order_headers_all oohawhere order_number=p_order_number

2. OE_LINES_IFACE_ALL

This table is a multi-organization table used to insert sales order rows into the open interface.

This table stores order line information from other subsystems that need to import the OM module.

The fields / conditions that must be entered when the table is imported:

ORDER_SOURCE_ID: Order source id must

ORIG_SYS_DOCUMENT_REF: Original system document reference must

ORIG_SYS_LINE_REF: Original system line reference must

ORIG_SYS_SHIPMENT_REF: Original system shipment reference must

INVENTORY_ITEM: Inventory Item must

INVENTORY_ITEM_ID: Inventory Item ID optional

TOP_MODEL_LINE_REF: Top model line reference optional

LINK_TO_LINE_REF: Link to line reference optional

REQUEST_DATE: Request Date must

DELIVERY_LEAD_TIME: Delivery lead time must

DELIVERY_ID: Delivery id must

ORDERED_QUANTITY: Ordered quantity must

ORDER_QUANTITY_UOM: Order quantity uom must

SHIPPING_QUANTITY: Quantity which has been shipped by Shipping in Shipping UOM. Optional

SHIPPING_QUANTITY_UOM: The UOM for Shipping Quantity optional

SHIPPED_QUANTITY: Shipped quantity optional

CANCELLED_QUANTITY

FULFILLED_QUANTITY: The fulfilled quantity for the line optional

PRICING_QUANTITY: Pricing quantity optional

PRICING_QUANTITY_UOM: Pricing quantity uom optional

Example:

Insert into OE_LINES_IFACE_ALL (ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF,ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, org_id, line_number,line_type_id, item_type_code, INVENTORY_ITEM_ID, source_type_code, price_list_id, sold_to_org_id, sold_from_org_id, ship_to_org_id,ship_from_org_id, operation_code, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, CREATED_BY, CREATION_DATE LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) values (l_line_tbl (j). Order_source_id,l_line_tbl (j). Orig_sys_document_ref,l_line_tbl (j). Orig_sys_line_ref, l_line_tbl (j). Orig_sys_shipment_ref,l_line_tbl (j). Org_id,l_line_tbl (j). Line_number,l_line_tbl (j). Line_type_id L_line_tbl (j). Item_type_code,p_new_item,l_line_tbl (j). Source_type_code, l_line_tbl (j). Price_list_id,l_line_tbl (j). Sold_to_org_id,l_line_tbl (j). Sold_from_org_id,l_line_tbl (j). Ship_to_org_id,l_line_tbl (j). Ship_from_org_id, p_operation_code L_line_tbl (j). Ordered_quantity, l_line_tbl (j). Order_quantity_uom,l_line_tbl (j). Created_By, l_line_tbl (j). Creation_date, fnd_global.USER_ID, sysdate, fnd_global.user_id)

3. OE_PRICE_ADJS_IFACE_ALL

4. API: OE_ORDER_PUB of the import interface

Common procedures:

(1) OE_ORDER_PUB.Process_Order: provides operations to create, modify, and delete order entities. This method is also applicable to other operations on orders through recordset or external requests.

(2) OE_ORDER_PUB.Get_Order: returns all records of a single order object

(3) OE_ORDER_PUB.Lock_Order: lock the order object.

You can use get_order to get a record. You can call lock_order to lock the record.

5. Record error information

OE_PROCESSING_MSGS

OE_PROCESSING_MSGS_TL

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.