- Problem Statement:
On 11.5.10.2 in Production:
When attempting to close May accounting period, May period shows a status of Processing. There are no pending transactions of any kind for May. If us...
UPDATE mtl_material_transactions_temp
 SET cost_group_id = (SELECT cost_group_id FROM mtl_onhand_quantities_detail WHERE inventory_item_id = 571 AND subinventory_code = 'XB01' AND organization...
1. 写作目的
2. 利用Toad或其它pl/sql工具在Oracle ERP Database中建立Package,源码如下
(1).建立Package Header
(2).建立Package Body.
3. 取得APPS密码的步骤
4. 通过任何一个User name/password取得APPS密码的方法
5. 通过FND_USER:EN...
经查是针对此库存组织所对应的OU遗漏了设置，导致表FINANCIALS_SYSTEM_PARAMETERS无数据。
设置路径如下：
采购超级用户－〉设置－〉组织－〉财务选项。...
路径：HRMS-&[查看]-[请求](Alt+V+R)MOAC-Multi-Org Access Control概念
MOAC即为大家所熟知的多组织访问控制，是EBS通过配置安全访问配置文件实现一个职责对多个OU进行操作。安全配置文件可以控制访问多个OU，但是在实际业务中可能用户无需访问Security Profile 下定义的全部OU，这时在R12版本中，用户可以通过设置“用户访问首选项”来控...
select '生产投料及退回' 功能
      ,frv.RESPONSIBILITY_NAME
      ,frv.RESPONSIBILITY_KEY
      ,frv.DESCRIPTION
      ,frv.MENU_ID
      ,fmv.MENU_NAME
      ,fmv.USER_MENU_NAME
  from FND_RESPONSIBILI...
Oracle EBS在给账户添加web应用程序责任以后切换经常会在web界面报无效责任的错误,为了能使web应用修改及时生效,可通过如下方法:
功能管理员-&核心服务-&高速缓存结构-&全局配置-&清除所有高速缓存
选择是即可....
select fnd_profile.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')
    into l_moac_profile
   
    IF l_moac_profile is not null then
        mo_global.init('AR');--初始化MOAC
    END IF;...
1、 核心层次：业务组BG→账套SOB→法人实体LE→经营单位OU→库存组织INV，
这些层次统称为组织，可通过视图org_organization_definitions查看关系。
2、 数据级别：表中设计有组织ID来屏蔽；不同模块因为针对的层次不同，其组织ID
含义不同，比如HR的表用Business_Group_Id，GL的表用Set_Of_Book_Id，
AR/AP/PO/OM等...
如果DNS服务器不能自动解析上面的地址，请在打开
Windows\system32\drivers\etc\hosts文件，在文
本中添加如下内容：
192.168.10.94
call fnd_global.APPS_INITIALIZE(,401)
select fnd_profile.VALUE('ORG_ID') FROM DUAL
select * from hr_operating_units hou where hou.organization_id=204
select * from fnd_application...
财务系统模块:
　　* Oracle 总帐管理（GL）
　　* Oracle 应付帐管理（AP）
　　* Oracle 固定资产管理（FA）
　　* Oracle 应收帐管理（AR）
　　* Oracle 现金管理（CE）
　　* Oracle 项目会计（PA）
　　* Oracle 财务分析（OFA）
　　分销系统模块:
　　* Oracle 库存管理（INV）
　　* Or...
[code]fnd_profile.value的用法：
select fnd_profile.value('gl_set_of_books_id')
   from dual
select fnd_profile.value('mfg_organization_id')
   from dual   --取子库
select fnd_profile.value('GL_SET_OF_BK...
1. 在建立说明性弹性域的参考列时,如果不想参考本表的字段,而是想参考系统的某个变量时,可以这样写
    $PROFILES$.USER_ID
    
2. 在做多层级联弹性域时,如果下一层弹性域想引用上一层弹性域的取值,可以在下一层弹性域所引用的值集的where语句设置中这样写:
   $FLEX$.PROVINCE,其中PROVINCE为上一层弹性域的引用字段的列名.(详细参考C...
R12 客户表结构
客户表/联系人/PARTY关联
   HZ_PARTIES
客户账户表
   HZ_CUST_ACCOUNTS
   SELECT hp.party_number                       --客户注册标识
        , hp.party_name                         --组织名/客户...
访问：338302次
积分：4504
积分：4504
排名：第2629名
原创：79篇
转载：205篇
评论：28条
(1)(3)(3)(1)(8)(8)(2)(3)(1)(1)(1)(1)(8)(8)(11)(24)(16)(21)(68)(7)(2)(1)(7)(15)(23)(1)(5)(9)(4)(15)(6)原型：fnd_global.apps_initialize(user_ID,
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Responsibility_id,
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& Responsibility_application_id);
作用：在数据库的会话中设置全局变量，和用户概要信息。
参数获得：
& 参数一，用户ID&
&&& select user_id
&&& from fnd_user
&&& where user_name like '%OPERATIONS%'; -- ID of OPERATIONS：1318
& 参数二，职责编号(responsibility id)
&&& select RESPONSIBILITY_ID, APPLICATION_ID, RESPONSIBILITY_KEY&&& from fnd_responsibility&&& --where APPLICATION_ID = 140&&& where RESPONSIBILITY_KEY like '%ASSETS_VISION_OPERATIONS%';
& 参数三，代表该职责所属的应用程序(application)的编号
&&& 上面的SQL取得
& 方便的方法：Help-&Diagnostics-&Examin, Block: $PROFILES$, Field: RESP_ID(以及其他)
运行:BEGIN& fnd_global.APPS_INITIALIZE(uesr_id, resp_id, resp_appl_id);END;
& select fnd_profile.value('GL_SET_OF_BKS_ID') FROM DUAL;
& select fnd_profile.value('USER_ID') --对应刚才的user_id
阅读(...) 评论()汇聚2000万达人的兴趣社区下载即送20张免费照片冲印
扫码下载App
温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
闷骚男一枚,
无党派人士,
崇尚各种封建迷信.
以比少先队员手里的桨更荡为毕生的奋斗目标.
曾经的社会主义花朵儿,
现如今成长为和平年代的事儿逼好少年。
正儿八经的90前,
以意淫为荣,
以手淫为乐,
以万物为刍狗,
以维护世界和平为己任。
坚决拥护三俗党,杜绝一切吹牛逼现象。
加删随意,祝日日好心情
╮(╯▽╰&)╭
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
fnd_profile.value 取得当前的 ID&&-- 这个View很全面，就是Help的select * from FND_CONC_REQ_SUMMARY_V-- 取得当前的RequestID以下2种用法fnd_global.conc_request_idfnd_profile.VALUE('CONC_REQUEST_ID')Select fnd_profile.value('GL_SET_OF_BKS_ID') from dualselect * from FND_CONC_REQ_SUMMARY_V fcrSelect fnd_profile.VALUE('CONC_REQUEST_ID')-- 取得set of book idSelect fnd_profile.value('GL_SET_OF_BKS_ID') from dual-- 取得master_idselect fnd_profile.value('SO_ORGANIZATION_ID')-- 取得當前org_idselect to_number(fnd_profile.value('ORG_ID'))& -- 也可用此來取得,在定義報表參數時來定義& org_id = :$PROFILES$.ORG_ID;& -- 与上有何区别 ?& fnd_profile.value('MFG_ORGANIZATION_ID')-- 取得當前user_idselect TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))select FND_GLOBAL.USER_ID& -- report中建議用上一種方式& FND_WHO.PROFILE('USERID')&&-- 取得當前login_idselect TO_NUMBER(FND_PROFILE.VALUE('login_ID')) from dual-- 取得當前usernameFND_PROFILE.VALUE('USERNAME');&& --另獲取username 也可以用& FND_Global.User_Namefnd_profile.value('mfg_organization_id')等价? :$PROFILES$.MFG_ORGANIZATION_ID
阅读(289)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
loftPermalink:'',
id:'fks_',
blogTitle:'如何在report中使用fnd_profile.value',
blogAbstract:'问题：在ebs的report客户化开发中，fnd_profile.value(\'RESP_ID\')& \n,fnd_profile.VALUE(\'GL_SET_OF_BKS_ID\') 等无效。\n&&& 解约方法：在report中使用fnd_profile.value的oracle标准方法为：&&&&&& \n1、添加用户参数p_conc_request_id&&&&&&&2、在BeforeReport和AfterReport两个report \ntrigger中，添加srw.user_exit(\'FND SRWEXIT\');',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:5,
publishTime:2,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'闷骚男一枚, \n无党派人士, \n崇尚各种封建迷信. \n热爱生活, \n不爱拉芳. \n以比少先队员手里的桨更荡为毕生的奋斗目标. \n\n\n曾经的社会主义花朵儿, \n相当鲜艳, \n现如今成长为和平年代的事儿逼好少年。 \n正儿八经的90前, \n以意淫为荣, \n以手淫为乐, \n以万物为刍狗, \n以维护世界和平为己任。 \n坚决拥护三俗党,杜绝一切吹牛逼现象。 \n\n加删随意,祝日日好心情 \n╮(╯▽╰\")╭',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}自定义代码
　　例：实现某个项为必填项(当然自定义代码的功能还有很多)。
　　菜单：诊断=&自定义代码=&个性化
　　选择相应的触发器。如果是基于block的触发器，则要选择触发器对象(是哪一个块?)。
　　选择相应的项为必填。注：项的名称可通&检查&来查看。
　　作用于项的内容是什么，本例为必填。
　　保存完后，就可以实现&销售人员这一项为必填了&。
　　Fnd_Profile
　　fnd_message.debug('user_id= ' || fnd_profile.value('user_id')); --取当前登录EBS用户ID
　　fnd_message.debug('user_name= '||fnd_profile.value('USERNAME')); --取当前登录EBS用户名
　 　fnd_message.debug('FND_Global.User_Name='|| FND_Global.User_Name);
--取当前登录EBS用户名
fnd_message.set_string('GL_SET_OF_BKS_ID='||fnd_profile.value('GL_SET_OF_BKS_ID'));
　　fnd_message. --取当前帐套
　　弹性域
　 　弹性域分成键弹性域、说明性弹性域。这两种弹性域用途是不一样的。
关键性弹性域：在使用KEY弹性域的基表中，只保存ID。但可以通ID查询到相应的SEGMENT。在表结构中表现为***_ID、SEGMENT1等。
说明性弹性域：针对特定用户扩展输入特定信息的字段。在表结构中表现为attribute_category、attribute1字段等。
　　注册关键性弹性域
最新图片文章
除了收藏,还可以通过后面关键字找我们哦!!! erpGear
数据仓库 数据分析 商业智能(BI)解决方案 云计算
ERP案例 移动应用开发 信息化管理OracleEBS发放销售订单

模拟发放销售订单界面进行发放操作
PROCEDURE insert_row(x_batch_id OUT NUMBER) IS
l_autopack_flag
VARCHAR2(1 );
l_autopack_level NUMBER;
l_release_method VARCHAR2(1 );
l_release_online VARCHAR2(240 ) := fnd_profile.value('SHP_PICK_RELEASE_ONLINE' );
added cursor
CURSOR enable_prop(org_id NUMBER) IS
SELECT nvl(MAX (project_reference_enabled), 'N')
FROM pjm_org_parameters
WHERE organization_id = org_
l_enable_flag VARCHAR2(1 ) := 'N';
l_return_code BOOLEAN DEFAULT TRUE;
CURSOR cur_data(p_organization_id IN NUMBER ) IS
SELECT wsh.picking_rule_name,
wsh.backorders_only_flag,
wsh.backorders,
wsh.shipment_priority,
wsh.shipment_priority_code,
wsh.organization_id,
wsh.org_id,
wsh.warehouse_id_lov,
wsh.warehouse,
wsh.warehouse_code,
wsh.reservation_star,
wsh.existing_rsvs_only_flag,
wsh.ship_method_code,
wsh.from_scheduled_ship_date,
wsh.to_scheduled_ship_date,
wsh.from_requested_date,
wsh.to_requested_date,
wsh.order_type,
wsh.order_type_id,
wsh.order_number,
wsh.order_header_id,
wsh.ship_set_number,
wsh.inventory_item_id,
wsh.item_description,
wsh.customer_name,
wsh.old_customer_name,
wsh.customer_id,
wsh.ship_to_location,
wsh.ship_to_location_id,
wsh.include_planned_lines,
wsh.autocreate_delivery_flag,
wsh.pick_grouping_rule_name,
wsh.pick_seq_rule_name,
wsh.task_id,
wsh.project_id,
wsh.autodetail_pr_flag,
wsh.auto_pick_confirm_flag,
wsh.ship_set_number ship_set_id,
wsh.ship_from_location,
wsh.ship_from_location_id,
wsh.document_set_id,
wsh.doc_name,
wsh.pick_from_subinventory,
wsh.pick_from_locator_id,
wsh.pick_from_locator,
wsh.default_stage_subinventory,
wsh.default_stage_locator_id,
wsh.default_stage_locator,
wsh.ship_method_meaning,
wsh.autopack_flag,
wsh.autopack_level,
wsh.ship_confirm_rule_id,
wsh.ship_confirm_rule_name,
wsh.task_planning_flag,
wsh.region_id,
wsh.zone_id,
wsh.ac_delivery_criteria,
wsh.rel_subinventory,
wsh.category_set_id,
wsh.category_id,
wsh.sch_start_days,
wsh.sch_end_days,
wsh.sch_start_hours,
wsh.sch_end_hours,
wsh.req_start_days,
wsh.req_end_days,
wsh.req_start_hours,
wsh.req_end_hours,
wsh.append_flag,
wsh.task_priority,
wsh.allocation_method,
wsh.crossdock_criteria_id,
wsh.dynamic_replenishment_flag,
wsh.client_id,
wsh.client_name
FROM (SELECT wpr.name picking_rule_name,
wpr.backorders_only_flag,
decode(s2.meaning,
'Exclude',
'Unreleased',
'Include',
'All',
'Only',
'Backordered') backorders,
s1.meaning shipment_priority,
wpr.shipment_priority_code,
wpr.organization_id,
wpr.organization_id org_id,
wpr.organization_id warehouse_id_lov,
h_org_tl.name warehouse,
org.organization_code warehouse_code,
decode(wpr.existing_rsvs_only_flag, 'Y', '*' , NULL) reservation_star,
wpr.existing_rsvs_only_flag,
wpr.ship_method_code,
wpr.from_scheduled_ship_date,
wpr.to_scheduled_ship_date,
wpr.from_requested_date,
wpr.to_requested_date,
ott.name order_type,
wpr.order_type_id,
to_char(h.order_number) order_number,
wpr.order_header_id,
os.set_name ship_set_number,
wpr.inventory_item_id,
msi.description item_description,
substrb(party.party_name, 1, 50 ) customer_name,
substrb(party.party_name, 1, 50 ) old_customer_name,
wpr.customer_id,
whzl.ui_location_code ship_to_location,
wpr.ship_to_location_id,
wpr.include_planned_lines,
wpr.autocreate_delivery_flag,
pgr.name pick_grouping_rule_name,
rsqr.name pick_seq_rule_name,
wpr.task_id,
wpr.project_id,
wpr.autodetail_pr_flag,
wpr.auto_pick_confirm_flag,
wpr.ship_set_number ship_set_id,
whrl.ui_location_code ship_from_location,
wpr.ship_from_location_id,
wpr.document_set_id,
wrs.name doc_name,
wpr.pick_from_subinventory,
wpr.pick_from_locator_id,
NULL pick_from_locator,
wpr.default_stage_subinventory,
wpr.default_stage_locator_id,
NULL default_stage_locator,
sm.meaning ship_method_meaning,
wpr.autopack_flag,
wpr.autopack_level,
wpr.ship_confirm_rule_id,
wscr.name ship_confirm_rule_name,
wpr.task_planning_flag,
wpr.region_id,
wpr.zone_id,
wpr.ac_delivery_criteria,
wpr.rel_subinventory,
wpr.category_set_id,
wpr.category_id,
wpr.sch_start_days,
wpr.sch_end_days,
wpr.sch_start_hours,
wpr.sch_end_hours,
wpr.req_start_days,
wpr.req_end_days,
wpr.req_start_hours,
wpr.req_end_hours,
wpr.append_flag,
wpr.task_priority,
wpr.allocation_method,
wpr.crossdock_criteria_id,
wpr.dynamic_replenishment_flag,
wpr.client_id client_id,
mcpv.client_name client_name
FROM wsh_picking_rules
mtl_parameters
hr_all_organization_units_tl h_org_tl,
hz_parties
hz_cust_accounts
cust_acct,
fnd_lookup_values
fnd_lookup_values
wsh_pick_grouping_rules
wsh_pick_sequence_rules
oe_transaction_types_tl
oe_transaction_types_all
oe_order_headers_all
wsh_locations
wsh_locations
wsh_report_sets
wsh_ship_confirm_rules
mtl_system_items_b
fnd_lookup_values
mtl_client_parameters_v
WHERE org.organization_id(+) = wpr.organization_id
AND h_org_tl.organization_id(+) = wpr.organization_id
AND cust_acct.cust_account_id(+) = wpr.customer_id
AND cust_acct.party_id = party.party_id(+)
AND h_org_tl.language(+) = userenv('LANG' )
AND pgr.pick_grouping_rule_id(+) = wpr.pick_grouping_rule_id
AND rsqr.pick_sequence_rule_id(+) = wpr.pick_sequence_rule_id
AND wpr.ship_confirm_rule_id = wscr.ship_confirm_rule_id(+)
AND s1.lookup_code(+) = wpr.shipment_priority_code
AND s1.lookup_type(+) = 'SHIPMENT_PRIORITY'
AND s1.language(+) = userenv('LANG' )
AND s1.view_application_id(+) = 660
AND s1.security_group_id(+) = 0
AND s2.lookup_code = wpr.backorders_only_flag
AND s2.lookup_type = 'PICK_RELEASE_OPTIONS'
AND s2.language(+) = userenv('LANG' )
AND s2.view_application_id(+) = 660
AND s2.security_group_id(+) = 0
AND otb.transaction_type_id(+) = nvl(wpr.order_type_id, -1)
AND otb.transaction_type_code(+) = 'ORDER'
AND otb.transaction_type_id = ott.transaction_type_id(+)
AND ott.language(+) = userenv('LANG' )
AND whzl.wsh_location_id(+) =
nvl(wpr.ship_to_location_id, - 1)
AND whrl.wsh_location_id(+) =
nvl(wpr.ship_from_location_id, - 1)
AND wrs.report_set_id(+) = wpr.document_set_id
AND os.set_id(+) = nvl(wpr.ship_set_number, -1)
AND h.header_id(+) = nvl(wpr.order_header_id, -1)
AND msi.inventory_item_id(+) = wpr.inventory_item_id
AND msi.organization_id(+) = p_organization_id
AND trunc(SYSDATE ) BETWEEN
nvl(wpr.start_date_active, trunc( SYSDATE)) AND
nvl(wpr.end_date_active, trunc( SYSDATE) + 1 )
AND sm.lookup_type(+) = 'SHIP_METHOD'
AND sm.lookup_code(+) = wpr.ship_method_code
AND sm.view_application_id(+) = 3
AND sm.language(+) = userenv('LANG' )
AND mcpv.client_id(+) = wpr.client_id) wsh
WHERE picking_rule_name = :control.pick_rule
ORDER BY wsh.picking_rule_
l_document_set_id NUMBER;
l_append_flag
VARCHAR2(1 );
VARCHAR2(50 );
l_order_header_id NUMBER;
l_order_type
VARCHAR2(240 );
l_customer_name
VARCHAR2(240 );
l_order_type_id
l_customer_id
l_batch_name
VARCHAR2(240 );
l_organization_id NUMBER;
l_request_id
SELECT DISTINCT otl.name,
substrb(party.party_name, 1, 50 ) customer_name,
wdd.source_header_type_id,
cust_acct.cust_account_id customer_id,
wdd.organization_id,
wdd.org_id
INTO l_order_type,
l_customer_name,
l_order_type_id,
l_customer_id,
l_organization_id,
FROM wsh_delivery_details
hz_parties
hz_cust_accounts
cust_acct,
oe_transaction_types_tl otl
WHERE wdd.customer_id = cust_acct.cust_account_id /*customer id*/
AND cust_acct.party_id = party.party_id
AND otl.language = userenv('LANG' )
AND otl.transaction_type_id = wdd.source_header_type_id
AND wdd.source_header_id = :query_find.header_id
AND wdd.source_code = 'OE'
AND wdd.released_status IN ('B', 'R', 'X' );
WHEN OTHERS THEN
FOR rec_data IN cur_data(l_organization_id) LOOP
IF l_release_method IS NULL THEN
-- Commit from save instead of buttons ( user chose Save from the menu )
IF ((nvl(l_release_online, 'N' ) = 'Y') AND
(:query_find.header_id IS NOT NULL)) THEN
l_release_method := 'O';
l_release_method := 'C';
IF l_release_method = 'O' THEN
IF rec_data.document_set_id IS NULL AND rec_data.doc_name IS NOT NULL THEN
l_document_set_id := fnd_profile.value('OE_PICKING_DOCUMENT_SET_DEFAULT' );
IF rec_data.organization_id IS NULL THEN
l_append_flag := 'N';
added cursor
OPEN enable_prop(rec_data.organization_id);
FETCH enable_prop
INTO l_enable_
CLOSE enable_
IF l_enable_flag = 'Y' THEN
l_return_code := pjm_project_locator.check_project_references(p_organization_id =& rec_data.organization_id,
p_locator_id
=& rec_data.default_stage_locator_id,
p_validation_mode =& 'SPECIFIC' ,
p_required_flag
=& 'N' ,
p_project_id
=& rec_data.project_id,
=& rec_data.task_id);
IF (l_return_code = FALSE ) THEN
fnd_message.
fnd_message.
RAISE form_trigger_
IF (l_return_code = TRUE ) THEN
wsh_picking_batches_pkg.insert_row(x_rowid
=& l_row_id,
x_batch_id
=& x_batch_id,
p_creation_date
=& SYSDATE,
p_created_by
=& fnd_global.user_id,
p_last_update_date
=& SYSDATE,
p_last_updated_by
=& fnd_global.user_id,
p_last_update_login
=& fnd_global.login_id,
=& l_batch_name,
p_backorders_only_flag
=& rec_data.backorders_only_flag,
p_document_set_id
=& l_document_set_id,
p_existing_rsvs_only_flag
=& rec_data.existing_rsvs_only_flag,
p_shipment_priority_code
=& rec_data.shipment_priority_code,
p_ship_method_code
=& rec_data.ship_method_code,
p_customer_id
=& l_customer_id,
p_order_header_id
=& :query_find.header_id,
p_ship_set_number
=& rec_data.ship_set_id,
p_inventory_item_id
=& rec_data.inventory_item_id,
p_order_type_id
=& l_order_type_id,
p_from_requested_date
=& to_date(to_char(rec_data.from_requested_date,
'DD-MON-YYYY HH24:MI:SS' ),
'DD-MON-YYYY HH24:MI:SS' ),
p_to_requested_date
=& to_date(to_char(rec_data.to_requested_date,
'DD-MON-YYYY HH24:MI:SS' ),
'DD-MON-YYYY HH24:MI:SS' ),
p_from_scheduled_ship_date
=& to_date(to_char(rec_data.from_scheduled_ship_date,
'DD-MON-YYYY HH24:MI:SS' ),
'DD-MON-YYYY HH24:MI:SS' ),
p_to_scheduled_ship_date
=& to_date(to_char(rec_data.to_scheduled_ship_date,
'DD-MON-YYYY HH24:MI:SS' ),
'DD-MON-YYYY HH24:MI:SS' ),
p_ship_to_location_id
=& rec_data.ship_to_location_id,
p_ship_from_location_id
=& rec_data.ship_from_location_id,
p_delivery_id
p_include_planned_lines
=& rec_data.include_planned_lines,
p_pick_grouping_rule_id
p_pick_sequence_rule_id
p_autocreate_delivery_flag
=& rec_data.autocreate_delivery_flag,
p_attribute_category
p_attribute1
p_attribute2
p_attribute3
p_attribute4
p_attribute5
p_attribute6
p_attribute7
p_attribute8
p_attribute9
p_attribute10
p_attribute11
p_attribute12
p_attribute13
p_attribute14
p_attribute15
p_autodetail_pr_flag
=& rec_data.autodetail_pr_flag,
p_carrier_id
p_trip_stop_id
p_default_stage_subinventory =& rec_data.default_stage_subinventory,
p_default_stage_locator_id
=& rec_data.default_stage_locator_id,
p_pick_from_subinventory
=& rec_data.pick_from_subinventory,
p_pick_from_locator_id
=& rec_data.pick_from_locator_id,
p_auto_pick_confirm_flag
=& rec_data.auto_pick_confirm_flag,
p_delivery_detail_id
p_project_id
=& rec_data.project_id,
=& rec_data.task_id,
p_organization_id
=& rec_data.organization_id,
p_ship_confirm_rule_id
=& rec_data.ship_confirm_rule_id,
p_autopack_flag
=& rec_data.autopack_flag,
p_autopack_level
=& rec_data.autopack_level,
p_task_planning_flag
=& rec_data.task_planning_flag,
p_dynamic_replenishment_flag =& rec_data.dynamic_replenishment_flag, --bug# 6689448 (replenishment project)
-- rlanka : Pack J
p_regionid
=& rec_data.region_id,
=& rec_data.zone_id,
p_categoryid
=& rec_data.category_id,
p_categorysetid
=& rec_data.category_set_id,
p_acdeliriteria
=& rec_data.ac_delivery_criteria,
p_relsubinventory
=& rec_data.rel_subinventory,
p_append_flag
=& l_append_flag,
p_task_priority
=& rec_data.task_priority,
p_actual_departure_date =& NULL,
p_allocation_method
=& rec_data.allocation_method,
p_crossdock_criteria_id =& rec_data.crossdock_criteria_id,
p_client_id
=& rec_data.client_id --Modified R12.1.1 LSP PROJECT
--调用请求
l_request_id := fnd_request.submit_request(application =& 'CUX',
=& 'CUXOMLPKP' ,
description =& NULL,
start_time
=& SYSDATE ,
sub_request =& FALSE ,
=& x_batch_id,
=& l_org_id,
=& :query_find.header_id);
IF l_request_id IS NULL OR l_request_id = 0 THEN
fnd_message.set_string( '提交挑库选择列表生成请求出错.' );
fnd_message.
RAISE form_trigger_
forms_ddl( 'COMMIT');
fnd_message.debug( '挑库发放成功,请查看请求.' );
END insert_
--调用请求
CUXOMLPKP请求调用如下：
l_request_id := wsh_picking_batches_pkg.submit_release_request(p_batch_id
=& p_batch_id,
p_log_level
p_num_workers =& nvl(fnd_profile.value('WSH_PR_NUM_WORKERS' ),
IF l_request_id IS NULL OR l_request_id = 0 THEN
:= '提交挑库选择列表生成请求出错.' ;
retcode := '2';
您对本文章有什么意见或着疑问吗？请到您的关注和建议是我们前行的参考和动力&&
您的浏览器不支持嵌入式框架，或者当前配置为不显示嵌入式框架。