详解EBS接口开发系列
文章平均质量分 78
caixingyun
这个作者很懒,什么都没留下…
展开
-
使用API获取(默认付款条件和到期日)
1. 目的:使用API取到应收事务处理的付款条件(实现标准功能的付款条件和到期日)2. 实现方法:调用 ARP_TRX_DEFAULTS_3.get_term_default获得付款条件3.实现代码/*======================================================= * FUNCTION / PROCEDURE * get转载 2015-03-06 15:26:12 · 1758 阅读 · 0 评论 -
Oracle Product Hub / Product Lifecycle Management / Product Information Management / Advanced Produc
In this Document Goal Solution 1. Master List showing sample code for APIs in Product Data Hub 2. FAQ a. Need API to load原创 2014-10-29 20:14:23 · 3659 阅读 · 0 评论 -
How to Simulate the Price Order or Price Line Function using API QP_PREQ_PUB.PRICE_REQUEST Includes
How to Simulate the Price Order or Price Line Function using API QP_PREQ_PUB.PRICE_REQUEST Includes Example Scripts (文档 ID 412545.1)转到底部In this Document原创 2014-11-11 17:25:38 · 4069 阅读 · 0 评论 -
PO订单审批拒绝API
DECLARE l_return_status VARCHAR2(1); l_return_code VARCHAR2(1000); l_exception_msg VARCHAR2(4000); l_online_report_id NUMBER;BEGIN --init mo_global.set_policy_context(p_access_原创 2014-10-26 10:55:26 · 2742 阅读 · 0 评论 -
Oracle Inventory Management Application Program Interface ( APIs)
In this Document Goal Solution ReferencesAPPLIES TO:Oracle Inventory Management - Version 12.0.0 and laterInformation in this document app原创 2014-10-29 20:12:49 · 3306 阅读 · 0 评论 -
更新客户配置文件
DECLARE l_rec_profile_t hz_customer_profile_v2pub.customer_profile_rec_type; l_rec_profile hz_customer_profile_v2pub.cust_profile_amt_rec_type; l_profile_amt_id NUMBER; l_profile_id原创 2014-10-30 17:39:21 · 2493 阅读 · 1 评论 -
供应商地点信息更新
例:更新供应商地点可采购flagDECLARE l_api_version CONSTANT NUMBER := 1; l_msg_data VARCHAR2(2000); l_msg VARCHAR2(4000); l_msg_count NUMBER; l_return_status VARCHAR2(1);原创 2014-11-09 12:54:34 · 2918 阅读 · 0 评论 -
销售订单行重订价
DECLARE l_sel_rec_tbl oe_globals.selected_record_tbl; l_return_status VARCHAR2(100); l_msg_count NUMBER; l_msg_data VARCHAR2(100); x_msg_data VARCHAR2(1000);BEGIN m原创 2014-11-10 17:23:36 · 2436 阅读 · 0 评论 -
Optimizing Item Import Performance in Oracle Product Hub/Inventory
APPLIES TO:Oracle Product Hub - Version 12.1.1 to 12.1.1 [Release 12.1]Oracle Inventory Management - Version 12.1.1 to 12.1.1 [Release 12.1]Oracle Item Master - Version 12.0.6 to 12.0.6 [Release原创 2014-10-08 21:37:43 · 5032 阅读 · 0 评论 -
Using Integrated SOA Gateway in Oracle EBS
FROM:Oracle EBS如何与第三方系统相集成?比如这样的需求,X系统知道物料编码,需要从EBS系统里读取具体物料信息,或者X系统想把自己的人员信息同步到EBS,这类集成问题你就可能需要用到Oracle EBS Integrated SOA Gateway。Integrated SOA Gateway是EBS里的一个职责,分配给用户后就能看到 ,进入职责(如下转载 2014-11-11 17:41:30 · 1978 阅读 · 0 评论 -
详解ebs接口之客户配置文件导入(二)
-------------------------------------- 1a. Setup the Org_id------------------------------------exec dbms_application_info.set_client_info('204'); -------------------------------------- 1原创 2014-09-17 19:55:38 · 3208 阅读 · 0 评论 -
详解ebs接口之客户配置文件导入(一)
DECLARE l_rec_profile_t hz_customer_profile_v2pub.customer_profile_rec_type; l_rec_profile hz_customer_profile_v2pub.cust_profile_amt_rec_type; l_profile_amt_id NUMBER; l_profile_id原创 2014-09-17 19:52:29 · 3019 阅读 · 0 评论 -
EBS 外部信用风险检查
DECLARE l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_return_status VARCHAR2(30); l_cc_hold_comment VARCHAR2(30); l_result_out VARCHAR2(30); i原创 2014-09-24 11:36:45 · 2010 阅读 · 0 评论 -
EBS 可拓展的外部信用风险导入
DECLARE l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_return_status VARCHAR2(30); l_cc_hold_comment VARCHAR2(30); l_result_out VARCHAR2(30); g_user_id原创 2014-09-24 11:36:53 · 2080 阅读 · 0 评论 -
采购订单关闭
DECLARE -- Local variables here i INTEGER; l_return_status VARCHAR2(10); p_retcode VARCHAR2(2000); p_errbuf VARCHAR2(2000); v_x_return_status VARCHAR2(25原创 2014-08-30 22:50:30 · 2878 阅读 · 0 评论 -
PA 项目关联项目经理
---- 项目关联项目经理DECLARE p_project_id NUMBER := 155233; l_project_role_id NUMBER := ''; p_employee_id NUMBER := 10994; p_effective_date DATE := SYSDATE - 1; l_end_date_a原创 2014-08-27 12:12:55 · 1695 阅读 · 0 评论 -
PA 项目创建任务
---- 创建任务DECLARE p_project_id NUMBER := 155233; p_task_number VARCHAR2(240) := 'CXYTEST0001'; p_task_name VARCHAR2(240) := '接口测试CXYTEST0001'; p_task_d原创 2014-08-27 12:12:56 · 2274 阅读 · 0 评论 -
PA 创建项目
---- 创建项目DECLARE l_orig_project_id NUMBER := 6; l_prj_num VARCHAR2(240) := 'CXYTEST001'; l_start_date DATE := SYSDATE; l_completion原创 2014-08-27 12:11:56 · 1892 阅读 · 0 评论 -
订单应用暂挂
You can apply hold on existing order by populating the order import interface with the following :OE_HEADERS_IFACE_ALL ORDER_SOURCE_ID ORIG_SYS_DOCUMENT_REF OPERATION_CODE => 'UPDATE' ORG_ID原创 2014-10-17 15:15:20 · 2386 阅读 · 0 评论 -
客户地点分配多OU
DECLARE l_num_user_id NUMBER; l_num_appl_id NUMBER; l_num_resp_id NUMBER; cust_account_rec_type hz_cust_account_v2pub.cust_account_rec_type; l_num_ob原创 2014-10-04 13:50:18 · 2339 阅读 · 0 评论 -
更新物料存储期限
DECLARE l_item_rec inv_item_grp.item_rec_type; x_item_rec inv_item_grp.item_rec_type; l_error_tbl inv_item_grp.error_tbl_type; l_error_msg VARCHAR2(4000); x_return_sta原创 2015-01-05 11:32:37 · 2288 阅读 · 0 评论 -
ra_interface_lines_all 接口表各字段说明
note:Description and Usage of Fields in RA_INTERFACE_LINES Table [ID 1195997.1]核心内容: Field Name and DescriptionValidation and DestinationUser should provide data when... and Reference InformationINTER原创 2015-01-01 11:36:41 · 10046 阅读 · 0 评论 -
OM模块功能&API详解
(一)销售订单概述1.1 与车间模块关系当使用ATO类型订单时,订单管理模块会直接在车间模块中产生任务1.2 与库存模块关系在销售订单中使用的物料,单位等信息均来自库存模块,在订单执行过程中,按订单保留及销售发运等功能也会对库存模块起作用1.3 与应收模块关系销售完成后,订单管理模块会在应收接口中产生INVOICE信息,影响应收模块中销售订单对应的应收INVOICE处理操作1.4原创 2015-01-27 12:08:01 · 8741 阅读 · 0 评论 -
更新物料批次到期日
DECLARE l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(100) := fnd_api.g_false; -- bug 7513308; l_commit VARCHAR2(100) := fnd_api.g_false; l_validation_level NUMBE原创 2015-01-06 17:01:17 · 2505 阅读 · 0 评论 -
增加AP INVOICE 行&分配行
-- 增加行DECLARE v_row_id VARCHAR2(1000); v_line_number number; g_user_id CONSTANT NUMBER := fnd_global.user_id; g_login_id CONSTANT NUMBER := fnd_global.conc_login_id; g_reque原创 2014-11-22 16:58:23 · 3219 阅读 · 0 评论 -
How To Transact Move Order Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API
In this DocumentGoal Solution Sample Code: Steps: FAQ ReferencesAPPLIES TO:Oracle Inventory原创 2014-11-05 12:30:46 · 6440 阅读 · 0 评论 -
UTL_HTTP Call a Web Service and Pass Parameters as Part of the URL
SET DEFINE OFFSET SERVEROUTPUT ONDECLARE req UTL_HTTP.REQ; resp UTL_HTTP.RESP; value VARCHAR2(32767); V_DATA VARCHAR2(100) := 'strDate=”31-APR-2012”&strName=”TestName”';BEGIN req := UTL_原创 2014-11-20 16:50:29 · 2220 阅读 · 0 评论 -
更新客户信息
DECLARE CURSOR cur_h IS SELECT h.* FROM ar_customers h WHERE h.customer_name /*'—XD';*/ LIKE '%—XD'; p_customer_rec cux_ar_cust_accounts_v%ROWTYPE; l_retu原创 2014-11-25 22:32:57 · 2059 阅读 · 0 评论 -
修改量更新API
/* Update a Modifier header of type 'PRO' (Promotion) */l_MODIFIER_LIST_rec.active_flag := 'N'; l_MODIFIER_LIST_rec.list_header_Id := 79722;l_MODIFIER_LIS原创 2014-11-19 21:41:18 · 1624 阅读 · 0 评论 -
Sample Code for Qp_preq_pub.Price_request Api to Simulate an Ask for Promotion Modifier
DECLARE p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE; p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE; p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE; p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE; p_LINE_DETA原创 2014-11-19 21:42:01 · 3773 阅读 · 0 评论 -
HOW to Use QP_PREQ_PUB.PRICE_REQUEST API to Price an Item
In this DocumentGoal Solution ReferencesAPPLIES TO:Oracle Advanced Pricing - Version 11.5.10 and laterInformation in this document applies原创 2014-11-19 21:45:18 · 5931 阅读 · 0 评论 -
How to Create Modifiers Using the API QP_MODIFIERS_PUB.PROCESS_MODIFIERS
In this DocumentGoal Solution Example Scripts Steps to verify the creation of modifier(s). Additional Resources原创 2014-11-19 21:48:00 · 5309 阅读 · 0 评论 -
详解EBS接口开发之物料导入API
create_item inv_item_grp.create_item(p_commit => fnd_api.g_true, -- p_item_rec => l_item_rec, x_item_rec =>原创 2014-10-04 11:47:53 · 7833 阅读 · 0 评论 -
PO订单审批通过API
DECLARE l_return_status VARCHAR2(1); l_exception_msg VARCHAR2(4000);BEGIN mo_global.set_policy_context(p_access_mode => 'S', p_org_id => 81); -- Call the原创 2014-10-26 10:54:29 · 5510 阅读 · 0 评论 -
Oracle Bills of Material and Engineering Application Program Interface (APIs)
In this DocumentGoal Solution 1. Sample Notes for BOM APIs 2. Datatypes used in these APIs 3. Limitations / ERs原创 2014-10-29 20:14:01 · 3271 阅读 · 0 评论 -
AP INVOICES IMPORT API(NOT request)
PROCEDURE process_cux_to_ap(x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2) I原创 2014-11-09 17:14:13 · 5667 阅读 · 0 评论 -
Process Order API - How To Scripts
In this Document Purpose Questions and Answers ReferencesAPPLIES TO:Oracle Order Management - Version 11.5 to 12.2.3 [Release 11.5 to 12.2]原创 2014-11-11 17:25:46 · 2935 阅读 · 0 评论 -
PA 项目任务创建资源
-- 创建资源DECLARE p_project_id NUMBER := 155233; p_task_id NUMBER := 244639; p_resource_list_member_id NUMBER := 2023; p_planned_quantity NUMBER := 10原创 2014-08-27 12:12:07 · 2017 阅读 · 0 评论 -
客户化程序完成标准成本成批更新
You have to populate CST_ITEM_CST_DTLS_INTERFACE,CST_RESOURCE_COSTS_INTERFACE,CST_RES_OVERHEADS_INTERFACE and CST_DEPT_OVERHEADS_INTERFACE accordingly.The concurrent request can be launched by nav转载 2014-08-09 23:06:49 · 3328 阅读 · 0 评论 -
API创建/更新员工联系电话
DECLARE ln_phone_id PER_PHONES.PHONE_ID%TYPE; ln_object_version_number PER_PHONES.OBJECT_VERSION_NUMBER%TYPE; BEGIN -- Create or Update Employee原创 2013-12-29 13:23:12 · 1588 阅读 · 0 评论