信息技术最佳实践 ORACLE核心应用技术 E-BUSINESS SUITE 常用接口开发参考
Author: Creation Date: Last Updated: Document Ref: Version:
Approvals:
黄建华
November 1, 2005 February 5, 2015
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