Oracle ERP最佳技术实践 E-BUSINESS SUITE ORACLE核心应用技术 接口开发参考
Author: Creation Date: Last Updated: Document Ref: Version:
Approvals:
黄建华
November 1, 2005 June 23, 2014
Copy Number _____
Oracle ERP最佳技术实践 Doc Ref:
June 25, 2008
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: 37325617.doc (v. DRAFT 1A )
Company Confidential - For internal use only
Document Control ii
Oracle ERP最佳技术实践 Doc Ref:
接口开发参考
File Ref: 37325617.doc (v. DRAFT 1A )
June 25, 2008
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 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
7.2.
开发参考 ............................................................................................................ 33
Document Control iii
Company Confidential - For internal use only
Oracle ERP最佳技术实践 Doc Ref:
接口开发参考
File Ref: 37325617.doc (v. DRAFT 1A )
June 25, 2008
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. INV Items物料【Open Interface、Unopened API】 ......................................... 59 12.1. 快速参考 ............................................................................................................ 59 12.2. 开发参考 ............................................................................................................ 59 12.3. 关键字段（参数）+最简单例子 ...................................................................... 60 12.4.
已知问题 ............................................................................................................ 65
13. INV Item Categories物料类别【Open Interface、Unopened API】 ............... 66 13.1. 快速参考 ............................................................................................................ 66 13.2. 开发参考 ............................................................................................................ 66 13.3. 关键字段（参数）+最简单例子 ...................................................................... 67 13.4.
已知问题 ............................................................................................................ 68
14. INV Material Transactions物料事务处理【Open Interface】 ......................... 70 14.1. 快速参考 ............................................................................................................ 70 14.2. 开发参考 ............................................................................................................ 70 14.3. 关键字段（参数）+最简单例子 ...................................................................... 72 14.4.
已知问题 ............................................................................................................ 75
15. INV Move Orders挑库单【Open API】 ............................................................... 76 15.1. 快速参考 ............................................................................................................ 76 15.2. 开发参考 ............................................................................................................ 77 15.3. 关键字段（参数）+最简单例子 ...................................................................... 77 15.4.
已知问题 ............................................................................................................ 79
16. INV MO Allocate物料搬运单分配【Open Interface】 ...................................... 80 16.1. 快速参考 ............................................................................................................ 80 16.2.
开发参考 ............................................................................................................ 80
Document Control iv
Company Confidential - For internal use only
Oracle ERP最佳技术实践 Doc Ref:
接口开发参考
File Ref: 37325617.doc (v. DRAFT 1A )
June 25, 2008
16.3. 关键字段（参数）+最简单例子 ...................................................................... 81 16.4. 已知问题 ............................................................................................................ 81
17.
INV MO Transact物料搬运单处理【Open API】 .............................................. 82 17.1. 快速参考 ............................................................................................................ 82 17.2. 开发参考 ............................................................................................................ 82 17.3. 关键字段（参数）+最简单例子 ...................................................................... 83 17.4.
已知问题 ............................................................................................................ 83
18. INV/BOM Delete Groups删除组【Simulation】 .............................................. 84 18.1. 快速参考 ............................................................................................................ 84 18.2. 开发参考 ............................................................................................................ 84 18.3. 关键字段（参数）+最简单例子 ...................................................................... 85 18.4.
已知问题 ............................................................................................................ 88
19. MRP Master Demand/Production Schedules【Open Interface】 ................ 89 19.1. 快速参考 ............................................................................................................ 89 19.2. 开发参考 ............................................................................................................ 89 19.3. 关键字段（参数）+最简单例子 ...................................................................... 89 19.4.
已知问题 ............................................................................................................ 91
20. OM Sales Order销售订单【Open Interface、Open API】 ............................... 92 20.1. 快速参考 ............................................................................................................ 92 20.2. 开发参考 ............................................................................................................ 92 20.3. 关键字段（参数）+最简单例子 ...................................................................... 93 20.4.
已知问题 ............................................................................................................ 96
21. OM Pick销售挑库【Open Interface、Open API】 ............................................ 98 21.1. 快速参考 ............................................................................................................ 98 21.2. 开发参考 ............................................................................................................ 98 21.3. 关键字段（参数）+最简单例子 ...................................................................... 99 21.4.
已知问题 ............................................................................................................ 99
22. OM Ship销售发运【Open API】 ........................................................................ 100 22.1. 快速参考 .......................................................................................................... 100 22.2. 开发参考 .......................................................................................................... 100 22.3. 关键字段（参数）+最简单例子 .................................................................... 100 22.4.
已知问题 .......................................................................................................... 104
23. PO Requisitions请购单【Open Interface】 ..................................................... 105 23.1. 快速参考 .......................................................................................................... 105 23.2. 开发参考 .......................................................................................................... 105 23.3. 关键字段（参数）+最简单例子 .................................................................... 107 23.4.
已知问题 .......................................................................................................... 110
24. PO Purchase Orders采购订单【Open Interface、Open API】 ...................... 111 24.1. 快速参考 .......................................................................................................... 111 24.2. 开发参考 .......................................................................................................... 111 24.3. 关键字段（参数）+最简单例子 .................................................................... 113 24.4.
已知问题 .......................................................................................................... 123
25. PO/RMA/OSP Receiving【Open Interface、Unopen API】 ........................ 124 25.1. 快速参考 .......................................................................................................... 124 25.2.
开发参考 .......................................................................................................... 124
Document Control v
Company Confidential - For internal use only