Oracle EBS: no data found in Package OE_ORDER_WF_U

message is: orA-01403: no data found in Package OE_ORDER_WF_UTIL Procedure Create_LineWorkItem
message index is: 1
message is: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineProcess
message index is: 2

折腾了一个下午,才发现是职责ID跟用户ID搞错了的问题,唉,真是汗自己.兄弟们要注意啊.





问题来源:通过OM提供的API来创建订单,好像通过interace抛请求的时间要比直接使用API的长,所以就换成了用API




还是找个查询用户职责的sql安全一些


select U.user_id user_id,
       u.user_name,
       u.description,
       WLR.ORIG_SYSTEM_ID RESPONSIBILITY_ID,
       (select application_id
          from apps.fnd_application
         where application_short_name = /* Val between 1st and 2nd separator */
               replace(substr(WAUR.ROLE_NAME,
                              INSTR(WAUR.ROLE_NAME, '|', 1, 1) + 1,
                              (INSTR(WAUR.ROLE_NAME, '|', 1, 2) -
                              INSTR(WAUR.ROLE_NAME, '|', 1, 1) - 1)),
                       '%col',
                       ':')) RESPONSIBILITY_APPLICATION_ID,
       (select security_group_id
          from apps.fnd_security_groups
         where security_group_key = /* Val after 3rd separator */
               replace(substr(WAUR.ROLE_NAME,
                              INSTR(WAUR.ROLE_NAME, '|', 1, 3) + 1),
                       '%col',
                       ':')) SECURITY_GROUP_ID,
       WAUR.START_DATE,
       WAUR.END_DATE END_DATE,
       WAUR.CreateD_BY CreateD_BY,
       WAUR.CREATION_DATE CREATION_DATE,
       WAUR.LAST_UpdateD_BY LAST_UpdateD_BY,
       WAUR.LAST_Update_DATE LAST_Update_DATE,
       WAUR.LAST_Update_LOGIN LAST_Update_LOGIN
  from apps.fnd_user                     u,
       apps.wf_all_user_role_assignments waur,
       apps.wf_local_roles               wlr
where u.user_name = waur.user_name
   and waur.role_name = wlr.name
      --and waur.assignment_type = 'INHERITED'
      -- and wlr.orig_system = 'FND_RESP'
   and waur.END_DATE is null
   and not waur.role_name like 'FND_RESP|%|ANY';






评论: 0 | 引用: 0 | 查看次数: 7927
发表评论
昵 称:
密 码: 游客发言不需要密码.
邮 箱: 邮件地址支持Gravatar头像,邮箱地址不会公开.
网 址: 输入网址便于回访.
内 容:
验证码:
选 项:
虽然发表评论不用注册,但是为了保护您的发言权,建议您注册帐号.
字数限制 30 字 | UBB代码 关闭 | [img]标签 关闭