EBS 强制重启成本管理的方法

背景

  • 避免取消成本管理器后,发生以下情况:

    • 同时启用多个成本管理器

    • 警告信息:成本管理器已经运行

取消成本管理器

方法一:系统管理员职责 - 并发/ 请求/ 查看

  • 设置查询特定请求,名字:成本管理器

  • 日期建议选择足够长,如 999天(默认值是7天)

  • 在查找结果中,找到状态是 已计划 待定 的,然后取消

方法二:SQL修改

  • 执行以下语句

SELECT request_id              RequestId,
       request_date            RequestDt,
       concurrent_program_name,
       phase_code              Phase,
       status_code             Status
  FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
 WHERE fcp.application_id = 702
   AND fcp.concurrent_program_name in ('CMCTCM', 'CMCMCW', 'CMCACW')
   AND fcr.concurrent_program_id = fcp.concurrent_program_id
   AND fcr.program_application_id = 702
   AND fcr.phase_code <> 'C'
  • 将查到的请求编号在 系统管理员职责 - 并发/ 请求/ 查看找到,并取消掉

  • 日期建议选择足够长,如 999天(默认值是7天)

重新执行成本管理器

  • 请运行成本管理器请求

    • 路径:库存管理- 设置 - 事务处理 - 接口管理器

    • 方法:选择成本管理器,在工具栏点击 工具 - 启动管理器 即可,也可以直接在请求界面提交我们前面取消的那个请求。

下文为原文英文版本

Background

  • How to cancel cost manager, in order to avoid :

    • to launch severals cost manager at the same time

    • to have warning message in CMCTCM log saying : "A Cost Manager is already launched. 

Action

If you want to launch a new manager, cancel earlier manager first."

Cancel the Cost Manager

1 - To cancel the Cost Manager : use one of the following method:

use 'System Administrator' responsibility 

  • Navigate to Concurrent/Request/view 

    • Set : specific Request=on 

    • Name=Cost Manager.

  • Note:

    • In the lower part of the Find requests window there is a field "Select the Number of Days to view" set by default to 7 days

    • Set "Select the Number of Days to view"=9999 

    • In fact this field is a filter which limits how far back it will query requests.

  • From here Cancel the Cost Manager which is Pending Scheduled

Use the following SQL script

SELECT request_id              RequestId,
       request_date            RequestDt,
       concurrent_program_name,
       phase_code              Phase,
       status_code             Status
  FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
 WHERE fcp.application_id = 702
   AND fcp.concurrent_program_name in ('CMCTCM', 'CMCMCW', 'CMCACW')
   AND fcr.concurrent_program_id = fcp.concurrent_program_id
   AND fcr.program_application_id = 702
   AND fcr.phase_code <> 'C'
  • Cancel all the requests from the above output by navigating to, System Administrator> Concurrent> Request.  

  • Query for the RequestId returned from the select above.

  • Note:

    • In the lower part of the Find requests window there is a field "Select the Number of Days to view" set by default to 7 days 

    • -> Set "Select the Number of Days to view"=9999 

    • In fact this field is a filter which limits how far back it will query requests. 

  • Cancel the request id other than running. Let the running request get over. 

Relunch the Cost Manager

  • Please run the Concurrent Manager Recovery feature to address any Concurrent Manager / Concurrent Processing issues within the Oracle Application Manager.  NOTE: Regular use of the CP Analyzer in Note 1411723.1 can provide an Immediate Analysis and Output of a Concurrent Environment.

    • Restart the Cost ManagerInventory> Setup : Transactions> Interface Managers 

    • Select  'Cost Manager' - choose Tools > Launch Manager

参考文档

  • How to Cancel Cost Manager (CMCTCM ) and Relaunch It (Doc ID 373207.1)

  • Understanding Cost Manager (Doc ID 304313.1)


本文标题:EBS 强制重启成本管理的方法

本文链接:http://catonisland.cn/post/242.html

本文版权归作者所有,欢迎转载,转载请以文字链接的形式注明文章出处。

相关文章