OracleEBS常用接口开发案例参考手册

信息技术最佳实践 ORACLE核心应用技术 E-BUSINESS SUITE 常用接口开发参考

Author: Creation Date: Last Updated: Document Ref: Version:

Approvals:

黄建华

November 1, 2005 February 5, 2015

DRAFT 1A

Copy Number _____

信息技术最佳实践 Doc Ref:

May 3, 2013

Document Control

Change Record

6

Date Author Version Change Reference 29-Oct-05 Jianhua.Huang Draft 1a No Previous Document

Reviewers

Name Position

Distribution

Copy No. Name Location 1 2 3 4 Library Master Project Library Project Manager

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

常用接口开发参考

File Ref: 251060720.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Document Control ii

信息技术最佳实践 常用接口开发参考

File Ref: 251060720.doc (v. DRAFT 1A )

Doc Ref:

May 3, 2013

Contents

Document Control .................................................................................................................. ii 1.

总体说明 ..................................................................................................................... 2

1.1.

本文档目的 .......................................................................................................... 2 1.2. 业务需求 .............................................................................................................. 2 1.3. 接口模式.Open Interface模式 ........................................................................... 2 1.4. 接口模式.Open API模式.................................................................................... 4 1.5. 参考资料 .............................................................................................................. 6 1.6. 问题解决方法 ...................................................................................................... 6 2.

AP Invoices应付发票【Open Interface】 .............................................................. 7

2.1. 快速参考 .............................................................................................................. 7 2.2. 开发参考 .............................................................................................................. 7 2.3. 关键字段（参数）+最简单例子 ........................................................................ 8 2.4. 已知问题 .............................................................................................................. 9 3.

AP Suppliers供应商【Open Interface、Unopen API】 .................................... 10

3.1. 快速参考 ............................................................................................................ 10 3.2. 开发参考 ............................................................................................................ 10 3.3. 关键字段（参数）+最简单例子 ...................................................................... 10 3.4. 已知问题 ............................................................................................................ 12 4.

AR Customers客户【Open Interface】 ............................................................... 13

4.1. 快速参考 ............................................................................................................ 13 4.2. 开发参考 ............................................................................................................ 13 4.3. 关键字段（参数）+最简单例子 ...................................................................... 14 4.4. 已知问题 ............................................................................................................ 20 5.

AR Transactions应收发票【Open Interface、Open API】 ............................... 23

5.1. 快速参考 ............................................................................................................ 23

5.2. 开发参考 ............................................................................................................ 23 5.3. 关键字段（参数）+最简单例子 ...................................................................... 24 5.4. 已知问题 ............................................................................................................ 24 6.

BOM Bills物料清单【Open Interface、Open API】 .......................................... 25

6.1. 快速参考 ............................................................................................................ 25 6.2. 开发参考 ............................................................................................................ 25 6.3. 关键字段（参数）+最简单例子 ...................................................................... 27 6.4. 已知问题 ............................................................................................................ 32 7.

BOM Routings工艺路线【Open Interface、Open API】 .................................. 33

7.1.

快速参考 ............................................................................................................ 33

Document Control iii

Company Confidential - For internal use only

信息技术最佳实践 常用接口开发参考

File Ref: 251060720.doc (v. DRAFT 1A )

Doc Ref:

May 3, 2013

7.2. 开发参考 ............................................................................................................ 33 7.3. 关键字段（参数）+最简单例子 ...................................................................... 35 7.4. 已知问题 ............................................................................................................ 42 8.

CE Bank Statement银行对账单【Open Interface】 ........................................... 43

8.1. 快速参考 ............................................................................................................ 43 8.2. 开发参考 ............................................................................................................ 43 8.3. 关键字段（参数）+最简单例子 ...................................................................... 44 8.4. 已知问题 ............................................................................................................ 46 9.

CST Costs物料成本、资源费率、费用费率【Open Interface】 ........................ 48

9.1. 快速参考 ............................................................................................................ 48

9.2. 开发参考 ............................................................................................................ 48 9.3. 关键字段（参数）+最简单例子 ...................................................................... 49 9.4. 已知问题 ............................................................................................................ 49 10.

FA Mass Addtions成批添加【Open Interface】 .............................................. 50

10.1. 快速参考 ............................................................................................................ 50 10.2. 开发参考 ............................................................................................................ 51 10.3. 关键字段（参数）+最简单例子 ...................................................................... 52 10.4. 已知问题 ............................................................................................................ 54

11.

GL Journal日记账【Open Interface】 .................................................................. 55 11.1. 快速参考 ............................................................................................................ 55 11.2. 开发参考 ............................................................................................................ 55 11.3. 关键字段（参数）+最简单例子 ...................................................................... 56 11.4.

已知问题 ............................................................................................................ 58

12. HR People人员&信息【Open API】 .................................................................... 59 12.1. 快速参考 ............................................................................................................ 59 12.2. 开发参考 ............................................................................................................ 59 12.3. 关键字段（参数）+最简单例子 ...................................................................... 60 12.4.

已知问题 ............................................................................................................ 62

13. INV Items物料【Open Interface、Unopened API】 ......................................... 63 13.1. 快速参考 ............................................................................................................ 63 13.2. 开发参考 ............................................................................................................ 63 13.3. 关键字段（参数）+最简单例子 ...................................................................... 64 13.4.

已知问题 ............................................................................................................ 69

14. INV Item Categories物料类别【Open Interface、Unopened API】 ............... 70 14.1. 快速参考 ............................................................................................................ 70 14.2. 开发参考 ............................................................................................................ 70 14.3. 关键字段（参数）+最简单例子 ...................................................................... 71 14.4.

已知问题 ............................................................................................................ 72

15. INV Material Transactions物料事务处理【Open Interface】 ......................... 74 15.1. 快速参考 ............................................................................................................ 74 15.2. 开发参考 ............................................................................................................ 74 15.3. 关键字段（参数）+最简单例子 ...................................................................... 76 15.4.

已知问题 ............................................................................................................ 80

16. INV Move Orders挑库单【Open API】 ............................................................... 81 16.1.

快速参考 ............................................................................................................ 81

Document Control iv

Company Confidential - For internal use only

信息技术最佳实践 常用接口开发参考

File Ref: 251060720.doc (v. DRAFT 1A )

Doc Ref:

May 3, 2013

16.2. 开发参考 ............................................................................................................ 82 16.3. 关键字段（参数）+最简单例子 ...................................................................... 82 16.4. 已知问题 ............................................................................................................ 84

17.

INV MO Allocate物料搬运单分配【Open Interface】 ...................................... 85 17.1. 快速参考 ............................................................................................................ 85 17.2. 开发参考 ............................................................................................................ 85 17.3. 关键字段（参数）+最简单例子 ...................................................................... 86 17.4.

已知问题 ............................................................................................................ 86

18. INV MO Transact物料搬运单处理【Open API】 .............................................. 87 18.1. 快速参考 ............................................................................................................ 87 18.2. 开发参考 ............................................................................................................ 87 18.3. 关键字段（参数）+最简单例子 ...................................................................... 88 18.4.

已知问题 ............................................................................................................ 88

19. INV/BOM Delete Groups删除组【Simulation】 .............................................. 89 19.1. 快速参考 ............................................................................................................ 89 19.2. 开发参考 ............................................................................................................ 89 19.3. 关键字段（参数）+最简单例子 ...................................................................... 90 19.4.

已知问题 ............................................................................................................ 93

20. MRP Master Demand/Production Schedules【Open Interface】 ................ 94 20.1. 快速参考 ............................................................................................................ 94 20.2. 开发参考 ............................................................................................................ 94 20.3. 关键字段（参数）+最简单例子 ...................................................................... 94 20.4.

已知问题 ............................................................................................................ 96

21. OM Sales Order销售订单【Open Interface、Open API】 ............................... 97 21.1. 快速参考 ............................................................................................................ 97 21.2. 开发参考 ............................................................................................................ 97 21.3. 关键字段（参数）+最简单例子 ...................................................................... 98 21.4.

已知问题 .......................................................................................................... 103

22. OM Pick销售挑库【Open Interface、Open API】 .......................................... 105 22.1. 快速参考 .......................................................................................................... 105 22.2. 开发参考 .......................................................................................................... 105 22.3. 关键字段（参数）+最简单例子 .................................................................... 106 22.4.

已知问题 .......................................................................................................... 106

23. OM Ship销售发运【Open API】 ........................................................................ 107 23.1. 快速参考 .......................................................................................................... 107 23.2. 开发参考 .......................................................................................................... 107 23.3. 关键字段（参数）+最简单例子 .................................................................... 107 23.4.

已知问题 .......................................................................................................... 111

24. PO Requisitions请购单【Open Interface】 ..................................................... 112 24.1. 快速参考 .......................................................................................................... 112 24.2. 开发参考 .......................................................................................................... 112 24.3. 关键字段（参数）+最简单例子 .................................................................... 114 24.4.

已知问题 .......................................................................................................... 117

25. PO Purchase Orders采购订单【Open Interface、Open API】 ...................... 118 25.1.

快速参考 .......................................................................................................... 118

Document Control v

Company Confidential - For internal use only

本文来源：https://www.bwwdw.com/article/nkmg.html