Oracle EBS API: 采购请购单接口导入示例 (PR Created by interface table importing)
PR请购单导入需分两步进行:
先准备接口表数据, 通过SQLLoader或其他三方软件将数据插入接口表, 然后在系统中提交标准PR导入请求, 完成PR生成.
1, insert into PR interface table:
INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
(INTERFACE_SOURCE_CODE,
DESTINATION_TYPE_CODE,
AUTHORIZATION_STATUS,
REQUISITION_TYPE,
PREPARER_ID,
PREPARER_NAME,
QUANTITY,
CHARGE_ACCOUNT_ID,
DESTINATION_ORGANIZATION_ID,
DESTINATION_SUBINVENTORY,
SOURCE_TYPE_CODE,
UNIT_PRICE,
DELIVER_TO_LOCATION_ID,
DELIVER_TO_REQUESTOR_ID,
ITEM_ID,
UNIT_OF_MEASURE,
UOM_CODE,
NEED_BY_DATE,
CREATION_DATE,
ITEM_DESCRIPTION,
LINE_TYPE,
HEADER_DESCRIPTION,
LINE_TYPE_ID,
SUGGESTED_VENDOR_ID,
SUGGESTED_VENDOR_SITE_ID)
VALUES( ‘EXTERNAL’,
‘INVENTORY’,'INCOMPLETE’,'PURCHASE’,
25,’Stock, Ms Pat’, 10, 13401, 204,’Stores’,'VENDOR’,
23, 204, 25, 63, ‘Each’, ‘Ea’, sysdate, sysdate,
‘Sentinal Multimedia’,'GOODS’,
‘Test Requisitions’,
1, 21, 41);
2, Log in as user: operations/welcome
resp: Purchasing, Vision Operations (USA)
Submit request: Requisition Import
Parameter: source: external
本文作者:网友 来源:网络http://www.imcmethods.com/blog/
CIO之家 www.ciozj.com 微信公众号:imciow