Oracle eBS經驗分享

Version : 11.5.10

Use the SQL script Req.imp.sql to insert your Requisition information from a non-Oracle Feeder system into PO_REQUISITIONS_INTERFACE_ALL table.

The columns in PO_REQUISITIONS_INTERFACE_ALL are described below. Mandatory columns are mentioned in BOLD.

NOTE: We have to give a Unique Requisition Number.

REFERENCES: Oracle Purchasing Applications Technical Reference Manual

Rep_imp.sql

SPOOL REQ_IMP
SET SERVEROUTPUT ON SIZE 100000;

BEGIN
INSERT INTO po_requisitions_interface_all 
	(interface_source_code
	,source_type_code 
	,destination_type_code 
	,authorization_status 
	,preparer_name 
	,quantity
	,unit_price
	,item_segment1 
	,charge_account_id
	,category_id 
	,unit_of_measure
	,destination_organization_code 
	,deliver_to_location_id 
	,deliver_to_requestor_name 
	,need_by_date 
	,req_number_segment1 
	,last_update_date 
	,last_updated_by 
	,creation_date 
	,created_by 
	,last_update_login 
	,org_id 
	) 
Values 
	('ROI' 
	,'VENDOR'
	,'INVENTORY' 
	,'INCOMPLETE' 
	,'Stock, Ms. Pat' 
	,1 
	,1
	,'CM00035'
	,13401 
	,1
	,'Each'
	,'V1' 
	,204
	,'Stock, Ms. Pat' 
	,SYSDATE 
	,'66666' 
	,SYSDATE 
	,1318 
	,SYSDATE 
	,1318 
	,0 
	,204
	);
END;
/

COMMIT;

SPOOL OFF