《EBS_AR模块API导入总结.doc》由会员分享，可在线阅读，更多相关《EBS_AR模块API导入总结.doc（43页珍藏版）》请在金锄头文库上搜索。
1、Oracle ERP最佳技术实践E-Business SuiteOracle 技术总结之应收导入IFACE总结Author:罗正武E-Mail:zhengwu.luohand-Creation Date:2015.07.01Last Updated:2015.07.13Document Ref: Version:DRAFT 1A 、Version 2Approvals: Copy Number_Document ControlChange Record3DateAuthorVersionChange Reference2015-07-01zhengwu.luohand-Draft 1aNo P
2、revious DocumentReviewersNamePositionDistributionCopy No.NameLocation1234Note 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
3、write your name on the front cover, for document control purposes.ContentsDocument Controlii背景介绍21 应收基础简介31.1 模块简介31.2 主要功能和作用31.3 和其他模块的关系41.4 关键设置62 应收事务处理72.1 应收事务处理概述72.2 API创建应收事务处理/贷项通知单72.3 手工录入应收事务处理简介152.4 相关表/重点掌握API173 应收收款/收款注销183.1. 应收收款概述183.2. API创建应收收款/收款注销193.3. 应收收款录入/收款注销创建简介243.4
4、. 相关表/重点掌握API254 应收核销/取消核销264.1. 应收收款核销简介264.2. API创建应收收款核销/取消核销264.3. 应收收款录入创建简介304.4. 相关表/重点掌握API325 应收调整335.1. 应收调整概述335.2. API创建调整335.3. 应收调整创建简介355.4. 相关表/重点掌握API366 常用函数387 参考文档401.Open and Closed Issues for this Deliverable41Open Issues41Closed Issues41 背景介绍目前项目是中国邮政，现接触到一个应收的大接口,涉及到收款/收款注销,核
5、销/取消核销,应收事务处理发票/贷项通知单,事务处理调整导入标准的.收获颇丰,写个文档记录一下. 1 应收基础简介1.1 模块简介应收模块基本简介1.2 主要功能和作用标准应收的主要功能和作用:1.3 和其他模块的关系 标准的应收和其他模块的关系:1.4 关键设置应收的关键设置作用:我们在调用标准api导入的时候,如果出现设置错误我们可以从以下设置来检查,典型的排错方式就是在标准界面录入导入数据检测问题应收关键设置列表:2 应收事务处理2.1 应收事务处理概述2.2 API创建应收事务处理/贷项通知单注:脚本中涉及到的所有id根据当前中邮项目的设置的映射规则取值.应收事务处理-简单导入发票应收
6、事务处理测试脚本 id均为写死,项目上可以根据需求灵活运用-author bruce-date 20150701DECLARE g_pkg_name VARCHAR2(60) := cux_test_scripts; g_api_type VARCHAR2(60) := cux_test_scripts; l_api_name CONSTANT VARCHAR2(30) := transaction_prc; l_api_version CONSTANT NUMBER := 1.0; p_commit BOOLEAN := FALSE; l_batch_source_rec ar_invoic
7、e_api_pub.batch_source_rec_type; l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type; x_return_status VARCHAR2(60); x_ms
8、g_count NUMBER; x_msg_data VARCHAR2(32676); x_customer_trx_id NUMBER; l_org_id NUMBER;BEGIN - start activity to create savepoint, check compatibility fnd_msg_pub.initialize; fnd_global.apps_initialize(user_id = 1291, resp_id = 20678, resp_appl_id = 222); l_org_id := 88; mo_global.set_policy_context(
9、p_access_mode = S, p_org_id = l_org_id); l_batch_source_rec.batch_source_id := 6001; l_trx_header_tbl(1).cust_trx_type_id := 1221; l_trx_header_tbl(1).trx_header_id := 100; l_trx_header_tbl(1).trx_date := SYSDATE; l_trx_header_tbl(1).gl_date := SYSDATE; l_trx_header_tbl(1).trx_currency := CNY; l_trx
10、_header_tbl(1).bill_to_customer_id := 39211; l_trx_header_tbl(1).term_id := 5; - l_trx_header_tbl(1).org_id := l_org_id; l_trx_lines_tbl(1).trx_header_id := 100; l_trx_lines_tbl(1).trx_line_id := 100; l_trx_lines_tbl(1).line_number := 1; l_trx_lines_tbl(1).description := nvl(NULL, 摘要); l_trx_lines_t
11、bl(1).quantity_invoiced := 1; l_trx_lines_tbl(1).unit_selling_price := 100; l_trx_lines_tbl(1).line_type := LINE; l_trx_dist_tbl(1).trx_dist_id := 100; l_trx_dist_tbl(1).trx_header_id := 100; l_trx_dist_tbl(1).trx_line_id := 100; l_trx_dist_tbl(1).account_class := REV; l_trx_dist_tbl(1).amount := 10
12、0; l_trx_dist_tbl(1).acctd_amount := 100; l_trx_dist_tbl(1).percent := 100; l_trx_dist_tbl(1).code_combination_id := 3000; l_trx_dist_tbl(2).trx_dist_id := 100; l_trx_dist_tbl(2).trx_header_id := 100; -l_trx_dist_tbl(2).trx_line_id := 100; l_trx_dist_tbl(2).account_class := REC; l_trx_dist_tbl(2).am
13、ount := 100; l_trx_dist_tbl(2).acctd_amount := 100; l_trx_dist_tbl(2).percent := 100; l_trx_dist_tbl(2).code_combination_id := 3000; dbms_output.put_line(bf_x_customer_trx_id: | x_customer_trx_id); ar_invoice_api_pub.create_single_invoice(p_api_version = 1.0, p_init_msg_list = fnd_api.g_false, p_commit = fnd_api.g_false, p_batch_source_rec = l_batch_source_rec, p_trx_header_tbl = l_trx_header_tbl,
