EBSAR模块API导入总结.docx
- 文档编号:4910710
- 上传时间:2023-05-07
- 格式:DOCX
- 页数:44
- 大小:2.86MB
EBSAR模块API导入总结.docx
《EBSAR模块API导入总结.docx》由会员分享,可在线阅读,更多相关《EBSAR模块API导入总结.docx(44页珍藏版)》请在冰点文库上搜索。
EBSAR模块API导入总结
OracleERP最佳技术实践
E-BusinessSuite
Oracle技术总结之应收导入IFACE总结
Author:
罗正武
E-Mail:
zhengwu.luo@hand-
CreationDate:
2015.07.01
LastUpdated:
2015.07.13
DocumentRef:
Version:
DRAFT1A、Version2
Approvals:
CopyNumber_____
DocumentControl
ChangeRecord
Date
Author
Version
ChangeReference
2015-07-01
zhengwu.luo@hand-
Draft1a
NoPreviousDocument
Reviewers
Name
Position
Distribution
CopyNo.
Name
Location
1
2
3
4
NoteToHolders:
Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.
Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.
Contents
背景介绍
目前项目是中国邮政,现接触到一个应收的大接口,涉及到收款/收款注销,核销/取消核销,应收事务处理发票/贷项通知单,事务处理调整导入标准的.收获颇丰,写个文档记录一下.
1应收基础简介
1.1模块简介
应收模块基本简介
1.2主要功能和作用
标准应收的主要功能和作用:
1.3和其他模块的关系
标准的应收和其他模块的关系:
1.4关键设置
应收的关键设置作用:
我们在调用标准api导入的时候,如果出现设置错误我们可以从以下设置来检查,典型的排错方式就是在标准界面录入导入数据检测问题
应收关键设置列表:
2应收事务处理
2.1应收事务处理概述
2.2API创建应收事务处理/贷项通知单
注:
脚本中涉及到的所有id根据当前中邮项目的设置的映射规则取值.
应收事务处理
--简单导入发票应收事务处理测试脚本id均为写死,项目上可以根据需求灵活运用
--authorbruce
--date20150701
DECLARE
g_pkg_nameVARCHAR2(60):
='cux_test_scripts';
g_api_typeVARCHAR2(60):
='cux_test_scripts';
l_api_nameCONSTANTVARCHAR2(30):
='transaction_prc';
l_api_versionCONSTANTNUMBER:
=1.0;
p_commitBOOLEAN:
=FALSE;
l_batch_source_recar_invoice_api_pub.batch_source_rec_type;
l_trx_header_tblar_invoice_api_pub.trx_header_tbl_type;
l_trx_lines_tblar_invoice_api_pub.trx_line_tbl_type;
l_trx_dist_tblar_invoice_api_pub.trx_dist_tbl_type;
l_trx_salescredits_tblar_invoice_api_pub.trx_salescredits_tbl_type;
x_return_statusVARCHAR2(60);
x_msg_countNUMBER;
x_msg_dataVARCHAR2(32676);
x_customer_trx_idNUMBER;
l_org_idNUMBER;
BEGIN
--startactivitytocreatesavepoint,checkcompatibility
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(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_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_tbl
(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:
=100;
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).amount:
=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,
p_trx_lines_tbl=>l_trx_lines_tbl,
p_trx_dist_tbl=>l_trx_dist_tbl,
p_trx_salescredits_tbl=>l_trx_salescredits_tbl,
x_customer_trx_id=>x_customer_trx_id,
x_return_status=>x_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data);
dbms_output.put_line('af_x_customer_trx_id:
'||x_customer_trx_id||'--x_return_status:
'||
x_return_status);
IF(x_return_status<>'S')THEN
RAISEfnd_api.g_exc_error;
ENDIF;
dbms_output.put_line('x_customer_trx_id:
'||x_customer_trx_id);
IFx_customer_trx_idISNULLTHEN
x_return_status:
=fnd_api.g_ret_sts_error;
cux_api.set_message(p_app_name=>'CUX',
p_msg_name=>'CUX_COMMON_MSG',
p_token1=>'TOKEN',
p_token1_value=>'出现未知错误,没有正确生成发票,请联系系统管理员');
RAISEfnd_api.g_exc_error;
ENDIF;
EXCEPTION
WHENfnd_api.g_exc_errorTHEN
dbms_output.put_line('g_exc_errorx:
');
dbms_output.put_line('FND_MSG_BUG:
'||fnd_msg_pub.get_detail(1,'F'));
WHENOTHERSTHEN
dbms_output.put_line('others_exception:
');
dbms_output.put_line('FND_MSG_BUG:
'||fnd_msg_pub.get_detail(1,'F'));
END;
贷项通知单
--简单导入贷项通知单核销应收事务处理发票测试脚本id均为写死,项目上可以根据需求灵活运用
--authorbruce
--date20150701
DECLARE
g_pkg_nameVARCHAR2(60):
='cux_test_scripts';
g_api_typeVARCHAR2(60):
='cux_test_scripts';
l_api_nameCONSTANTVARCHAR2(30):
='transaction_prc';
l_api_versionCONSTANTNUMBER:
=1.0;
p_commitBOOLEAN:
=FALSE;
l_batch_source_recar_invoice_api_pub.batch_source_rec_type;
l_trx_header_tblar_invoice_api_pub.trx_header_tbl_type;
l_trx_lines_tblar_invoice_api_pub.trx_line_tbl_type;
l_trx_dist_tblar_invoice_api_pub.trx_dist_tbl_type;
l_trx_salescredits_tblar_invoice_api_pub.trx_salescredits_tbl_type;
x_return_statusVARCHAR2(60);
x_msg_countNUMBER;
x_msg_dataVARCHAR2(32676);
x_customer_trx_idNUMBER;
l_org_idNUMBER;
l_cm_app_recar_cm_api_pub.cm_app_rec_type;
l_out_rec_application_idNUMBER;
l_acctd_amount_applied_fromNUMBER;
l_acctd_amount_applied_toNUMBER;
BEGIN
--startactivitytocreatesavepoint,checkcompatibility
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(p_access_mode=>'S',p_org_id=>l_org_id);
l_batch_source_rec.batch_source_id:
=1004;
l_trx_header_tbl
(1).cust_trx_type_id:
=1031;
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_header_tbl
(1).bill_to_customer_id:
=39211;
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_tbl
(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:
=-100;
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).amount:
=-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,
p_trx_lines_tbl=>l_trx_lines_tbl,
p_trx_dist_tbl=>l_trx_dist_tbl,
p_trx_salescredits_tbl=>l_trx_salescredits_tbl,
x_customer_trx_id=>x_customer_trx_id,
x_return_status=>x_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data);
dbms_output.put_line('af_x_customer_trx_id:
'||x_customer_trx_id||'--x_return_status:
'||
x_return_status);
COMMIT;
IF(x_return_status<>'S')THEN
RAISEfnd_api.g_exc_error;
ELSE
dbms_output.put_line('af_commit:
'||x_customer_trx_id);
l_cm_app_rec.cm_customer_trx_id:
=x_customer_trx_id;
l_cm_app_rec.inv_customer_trx_id:
=67994;--红字发票10元针对刚刚创建的发票
l_cm_app_rec.amount_applied:
=100;
ar_cm_api_pub.apply_on_account(p_api_version=>1,
p_init_msg_list=>fnd_api.g_true,
p_commit=>fnd_api.g_false,
p_cm_app_rec=>l_cm_app_rec,
x_return_status=>x_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
x_out_rec_application_id=>l_out_rec_application_id,
x_acctd_amount_applied_from=>l_acctd_amount_applied_from,
x_acctd_amount_applied_to=>l_acctd_amount_applied_to,
p_org_id=>l_org_id);
dbms_output.put_line('apply_on_account_x_return_status:
'||x_return_status);
dbms_output.put_line('l_out_rec_application_id:
'||l_out_rec_application_id);
IF(x_return_status<>'S')THEN
RAISEfnd_api.g_exc_error;
ENDIF;
ENDIF;
EXCEPTION
WHENfnd_api.g_exc_errorTHEN
dbms_output.put_line('g_exc_errorx:
');
dbms_output.put_line('FND_MSG_BUG:
'||fnd_msg_pub.get_detail(1,'F'));
WHENOTHERSTHEN
dbms_output.put_line('others_exception:
');
dbms_output.put_line('FND_MSG_BUG:
'||fnd_msg_pub.get_detail(1,'F'));
END;
2.3手工录入应收事务处理简介
头信息:
行信息:
分配信息:
2.4相关表/重点掌握API
应收事务处理表:
ra_customer_trx_all
重点掌握API:
ar_invoice_api_pub.create_single_invoice/ar_cm_api_pub.apply_on_account
3应收收款/收款注销
3.1.应收收款概述
收款简介:
收款业务流程:
3.2.API创建应收收款/收款注销
API创建收款:
--简单导入收款测试脚本id均为写死,项目上可以根据需求灵活运用
--authorbruce
--date20150701
DECLARE
l_api_nameCONSTANTVARCHA
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- EBSAR 模块 API 导入 总结