Oracle EBS Concurrent Program
文章平均质量分 81
田攀
tian.pan@qq.com
展开
-
Concurrent Request Tables
Oracle Apps Concurrent Request Table Relationshipfor pdf version,you can download from "Concurrent Request Tables.pdf"FND_CONCURRENT_PROGRAMSeTRM:FND_CONCURRENT_PROGRAMS stores informati原创 2012-06-29 12:47:03 · 5935 阅读 · 0 评论 -
Oracle E-Business Suite并发请求的优先级(Concurrent Request Priority)
不少用户抱怨自己的Oracle E-Business Suite并发请求(Concurrent Request)提交了好久,但还是一直在排队,等了好久还没有执行。用户希望对于一些重要性程度高、响应要求高的请求,希望能够优先执行。默认情况下,并发请求是按照请求提交时间的早晚顺序来执行的。对于并发请求优先级的需求,其实Oracle EBS是提供了相关配置,即Concurrent:Request Pri原创 2015-01-13 18:53:29 · 4066 阅读 · 0 评论 -
Concurrent FND scripts & Related Common SQL Decodes
Concurrent FND scripts$FND_TOP/sql 下有很多现成Concurrent Program相关脚本afimchk.sql Tells the status of the ICMafcmstat.sql Lists active manager processesafrqrun.sql Lists all the running,原创 2012-06-29 15:48:54 · 2987 阅读 · 0 评论 -
How to check others Concurrent Request Output
如何查看他人提交Concurrent Request的输出11iProfile: Concurrent:Report Access Level(Profile Internal Name:CONC_REPORT_ACCESS_LEVEL)LevelValueResultSiteUserThe user can only view the requests submitted by himRespo原创 2013-12-10 15:03:03 · 3276 阅读 · 0 评论 -
FNDWRR.exe - FND Web Report Review
FNDWRR.exe - FND Web Report Review,Oracle EBS中,查看报表的输出或者报表的日志,看到的链接的样式往往是下边的格式http://host:port/OA_CGI/FNDWRR.exe?temp_id=2640068719注意到链接中调用的一个程序-FNDWRR.exe,查了些资料:FNDWRR全称FND Web Report Review,执行程序位于$F原创 2013-09-11 12:03:56 · 6731 阅读 · 0 评论 -
Concurrent Request:Inactive phase,No Manager status
Symptom随便submit一个request,发现几乎所有的Concurrent Manager都为No Manager状态,Phase为Inactive。Solution一个Concurrent Request的生命周期包含不同的阶段(Phase):Pending, Running, and Completed,并且对于每一个Phase,又可能会有不同的状态。Pending Phase -原创 2012-07-19 23:47:48 · 5663 阅读 · 0 评论 -
Diagnostic Script for Concurrent Requests
source:REQCHECK.sql - Diagnostic Script for Concurrent Requests (Doc ID 164978.1)This Script is made available for Diagnosing Common Problems Related to Concurrent Requests.REM #######################原创 2013-03-04 17:06:59 · 2833 阅读 · 0 评论 -
The script to query all Concurrent Programs which used to Purge or Delete
Script Like:SELECT SUBSTR(B.APPLICATION_SHORT_NAME,1,11) "APPLICATION", SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,50) "CONCURRENT PROGRAM NAME", SUBSTR(A.CONCURRENT_PROGRAM_NAME,1,35) "SHO原创 2013-02-19 23:59:50 · 5965 阅读 · 0 评论 -
Number of Processes(Workers) for Concurrent Manager
一个Concurrent Manager可以调用多个进程(Worker)来同时做事务处理,如何修改Concurrent Manager所能调用的进程数(Worker数)System Admin >Concurrent > Define > Work ShiftsProcesses的数量就是将来Concurrent Manager能够调用的进程数量。更改完后,去Concurrent > Manage原创 2012-12-12 20:01:29 · 3356 阅读 · 0 评论 -
Transaction Historical Summary(Quantity,Value,Balance)
Transaction Historical Summary Report Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical balanc原创 2012-11-16 11:48:01 · 3671 阅读 · 0 评论 -
'Receiving Transaction Manager' Concurrent Program No Manager
发现Receiving Transaction Manager为No Manager状态,其他几个主要的Manager(Internal Manager,Standard Manager)都没有问题.重启Receiving Transaction Manager也没有效果。解决方法:使用下边SQL查,发现几个关键的RCV Package为InvalidSELECT * FROM d原创 2012-09-07 12:31:43 · 2841 阅读 · 0 评论 -
Oracle Apps Concurrent Manager
Concurrent ManagerInternal Concurrent Manager (ICM)ICM实际上是一个后台进程,用于管理其他Manager(start/stop).DBA要保证ICM处于运行状态,否则其他的Concurrent Manager无法Start/Stop.Standard Manager (SM)默认的concurrent mana原创 2012-07-20 11:32:17 · 5957 阅读 · 0 评论 -
How To Kill runaway processes After Terminating Concurrent Request
Every concurrent Request uses some resources for running. If we find that the concurrent request is taking long time and decided to terminate the concurrent request , the resources may not be released转载 2012-07-10 00:11:35 · 2841 阅读 · 0 评论 -
[Script]Long Running Concurrent Request in Oracle EBS
Looking on how to check long running concurrent request in Oracle Apps 11i or R12? Here’s the overview of the SQL query script to detect the session information of each program.First you need to get t转载 2012-06-29 12:37:59 · 2915 阅读 · 0 评论 -
Display status of all Concurrent Managers
rem -----------------------------------------------------------------------rem Filename: appinfo.sqlrem Purpose: Script to display status of all the Concurrent Managersrem Author: Anonymou原创 2012-04-26 12:33:44 · 2033 阅读 · 0 评论 -
关于Oracle E-Business Suite并发处理机制(Current Processing)
2012年写过一篇关于Oracle E-Business Suite并发管理器的文章,回头看之前总结的内容还是比较单薄,很多点没说到,最近再看这块的内容,索性再写一篇稍微完整的文章来。Oracle E-Business Suite并发处理机制(Current Processing)的好处区别于普通功能的处理机制,并发处理机制其实是一个异步处理机制,它把程序放到后台来运行,前台的操作还给用户,允许用原创 2015-01-21 14:05:01 · 11028 阅读 · 0 评论