oracle ebs采购申请接口表,[zz]Oracle EBS API: 采购请购单接口导入示例

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