ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [zz]Oracle EBS API: 采购请购单接口导入示例

[zz]Oracle EBS API: 采购请购单接口导入示例

原创 Linux操作系统 作者:idoo 时间:2009-11-30 16:47:19 0 删除 编辑

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


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/318394/viewspace-621031/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-13

  • 博文量
    13
  • 访问量
    35581