Open Inerface最简单例子(接收退回供应商)(11.5.9 GITI环境测试通过)
脚本如下:
DECLARE
l_iface_rcv_rec po.rcv_transactions_interface%ROWTYPE;
l_cur_mfg_org_id NUMBER := 82; --Current Inv Organization
l_user_id NUMBER := 0; --User ID?Sysadmin
BEGIN
l_iface_rcv_rec.last_update_date := SYSDATE;
l_iface_rcv_rec.last_updated_by := l_user_id;
l_iface_rcv_rec.creation_date := SYSDATE;
l_iface_rcv_rec.created_by := l_user_id;
l_iface_rcv_rec.last_update_login := -1;
SELECT rcv_transactions_interface_s.NEXTVAL
INTO l_iface_rcv_rec.interface_transaction_id
FROM dual;
SELECT po.rcv_interface_groups_s.NEXTVAL
INTO l_iface_rcv_rec.group_id
FROM dual;
l_iface_rcv_rec.shipment_header_id := 290773; --Shipment Header
l_iface_rcv_rec.processing_status_code := 'PENDING';
l_iface_rcv_rec.transaction_status_code := 'PENDING';
l_iface_rcv_rec.processing_mode_code := 'BATCH';
l_iface_rcv_rec.receipt_source_code := 'VENDOR';
l_iface_rcv_rec.vendor_id := 29843;
l_iface_rcv_rec.vendor_site_id := 765; --Optional
l_iface_rcv_rec.source_document_code := 'PO';
l_iface_rcv_rec.po_header_id := 148552;
l_iface_rcv_rec.po_line_id := 1062557;
l_iface_rcv_rec.po_line_location_id := 731140;
l_iface_rcv_rec.po_release_id := NULL;
l_iface_rcv_rec.transaction_type := 'RETURN TO VENDOR';
l_iface_rcv_rec.auto_transact_code := NULL;
l_iface_rcv_rec.destination_type_code := 'RECEIVING';
l_iface_rcv_rec.shipment_line_id := 586489;
l_iface_rcv_rec.parent_transaction_id := 1302078;
l_iface_rcv_rec.po_distribution_id := NULL;
l_iface_rcv_rec.from_organization_id := l_cur_mfg_org_id;
l_iface_rcv_rec.category_id := 395;
l_iface_rcv_rec.item_id := 18753;
l_iface_rcv_rec.item_description := '粉笔 白色';
l_iface_rcv_rec.transaction_date := SYSDATE;
l_iface_rcv_rec.quantity := .9;
l_iface_rcv_rec.unit_of_measure := '件'; --Not Code
l_iface_rcv_rec.to_organization_id := l_cur_mfg_org_id;
l_iface_rcv_rec.ship_to_location_id := NULL;
l_iface_rcv_rec.location_id := NULL;
l_iface_rcv_rec.interface_source_code := 'Just Test';
l_iface_rcv_rec.interface_source_line_id := '987654321';
INSERT INTO po.rcv_transactions_interface VALUES l_iface_rcv_rec;
dbms_output.put_line('group_id:' || l_iface_rcv_rec.group_id);
END;
Open Inerface最简单例子(RMA接收入库)(11.5.10.2 本机测试通过)
1、 接收前需要判断订单行状态必须是Awaiting Return。
2、 如果RMA接收路线是标准接收,那么下面例子routing_header_id改为1即可。
3、 不需要调用oe_rma_receiving.push_receiving_info,接口跑完状态为Returned。
脚本如下:
DECLARE
x_rowid VARCHAR2(40);
x_shipment_header_id NUMBER;
x_receipt_num VARCHAR2(100);
l_iface_rcv_rec po.rcv_transactions_interface%ROWTYPE;
BEGIN
fnd_global.apps_initialize(user_id => 1110, resp_id => 50237, resp_appl_id => 20003);
-- Create Shipment Header Directly, you can use rcv_headers_interface also
rcv_shipment_headers_pkg.insert_row(x_rowid => x_rowid,
x_shipment_header_id => x_shipment_header_id,
x_last_update_date => SYSDATE,
x_last_updated_by => fnd_global.user_id,
x_creation_date => SYSDATE,
x_created_by => fnd_global.user_id,
x_last_update_login => fnd_global.login_id,
x_receipt_source_code => 'CUSTOMER',
x_organization_id => 104,
x_ship_to_org_id => 104,
x_receipt_num => x_receipt_num,
x_employee_id => 61,
x_customer_id => 1040,
x_vendor_id => NULL,
x_vendor_site_id => NULL,
x_shipment_num => NULL,
x_ship_to_location_id => NULL,
x_bill_of_lading => NULL,
x_packing_slip => NULL,
x_shipped_date => NULL,
x_freight_carrier_code => NULL,
x_expected_receipt_date => NULL,
x_num_of_containers => NULL,
x_waybill_airbill_num => NULL,
x_comments => NULL,
x_attribute_category => NULL,
x_attribute1 => NULL,
x_attribute2 => NULL,
x_attribute3 => NULL,
x_attribute4 => NULL,
x_attribute5 => NULL,
x_attribute6 => NULL,
x_attribute7 => NULL,
x_attribute8 => NULL,
x_attribute9 => NULL,
x_attribute10 => NULL,
x_attribute11 => NULL,
x_attribute12 => NULL,
x_attribute13 => NULL,
x_attribute14 => NULL,
x_attribute15 => NULL,
x_ussgl_transaction_code => NULL,
x_government_context => NULL,
x_request_id => NULL,
x_program_application_id => NULL,
x_program_id => NULL,
x_program_update_date => NULL,
x_customer_site_id => NULL);
-- Create Line
SELECT po.rcv_transactions_interface_s.NEXTVAL
INTO l_iface_rcv_rec.interface_transaction_id
FROM dual;
SELECT po.rcv_interface_groups_s.NEXTVAL INTO l_iface_rcv_rec.group_id FROM dual;
l_iface_rcv_rec.last_update_date := SYSDATE;
l_iface_rcv_rec.last_updated_by := fnd_global.user_id;
l_iface_rcv_rec.creation_date := SYSDATE;
l_iface_rcv_rec.created_by := fnd_global.user_id;
l_iface_rcv_rec.last_update_login := fnd_global.login_id;
l_iface_rcv_rec.transaction_type := 'RECEIVE';
l_iface_rcv_rec.transaction_date := SYSDATE;
l_iface_rcv_rec.processing_status_code := 'PENDING';
l_iface_rcv_rec.processing_mode_code := 'BATCH';
l_iface_rcv_rec.transaction_status_code := 'PENDING';
l_iface_rcv_rec.category_id := 153;
l_iface_rcv_rec.quantity := 1;
l_iface_rcv_rec.unit_of_measure := 'PCS';
l_iface_rcv_rec.primary_quantity := 1;
l_iface_rcv_rec.primary_unit_of_measure := 'PCS';
l_iface_rcv_rec.interface_source_code := 'RCV';
l_iface_rcv_rec.item_id := 5;
l_iface_rcv_rec.item_description := 'Finished Good 1';
l_iface_rcv_rec.uom_code := 'PCS';
l_iface_rcv_rec.employee_id := 61;
l_iface_rcv_rec.auto_transact_code := 'DELIVER';
l_iface_rcv_rec.shipment_header_id := x_shipment_header_id;
l_iface_rcv_rec.receipt_source_code := 'CUSTOMER';
l_iface_rcv_rec.to_organization_id := 104;
l_iface_rcv_rec.routing_header_id := 3;
l_iface_rcv_rec.routing_step_id := 1;
l_iface_rcv_rec.source_document_code := 'RMA';
l_iface_rcv_rec.destination_type_code := 'INVENTORY';
l_iface_rcv_rec.location_id := 143;
l_iface_rcv_rec.deliver_to_location_id := 143;
l_iface_rcv_rec.subinventory := 'FSG1';
l_iface_rcv_rec.expected_receipt_date := SYSDATE;
l_iface_rcv_rec.destination_context := 'INVENTORY';
l_iface_rcv_rec.oe_order_header_id := 1131;
l_iface_rcv_rec.oe_order_line_id := 1241;
l_iface_rcv_rec.customer_id := 1040;
l_iface_rcv_rec.interface_source_code := 'Just Test';
l_iface_rcv_rec.interface_source_line_id := '987654321';
INSERT INTO po.rcv_transactions_interface VALUES l_iface_rcv_rec;
dbms_output.put_line('Receipt Num: ' || x_receipt_num);
dbms_output.put_line('Group Id: ' || l_iface_rcv_rec.group_id);
END;
这个接口能做的事情其实是非常多的,并不像115mfgapi.pdf说的那样,不支持Separate receive and deliver transactions、Corrections、Returns、Receiving against Drop Ship Orders;实际上这些都可以通过接口完成。文档宣称的其他一些“不支持”,还有待进一步测试。