ebs清除并法管理器所清除的表

zycchen

　　In this Document

Goal

Solution

References

　　
Applies to:
　　Oracle Concurrent Processing - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23-Apr-2013***
Goal
　　
　　
　　
　　
　　
　　
　　How to run the Purge Concurrent Request and/or Manager Data program and which tables does it purge?
Solution
　　运行清除并发请求和并发管理器数据程序

• Log in to Application as System Administrator responsibility.
  
• Navigate to Request> Run> Single Request
  
• Query up Purge Concurrent Requests.
  
• For values to be entered in the parameter screen refer to the Oracle
  Administration System Administration Guide
  

　　

The following tables will be purged depending on the value used for the Entity parameter:


Table nameDescriptionDescription FND_CONCURRENT_REQUESTSThis table contains a complete history of all concurrent requests.This table contains a complete history of all concurrent requests.FND_RUN_REQUESTSWhen a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.FND_CONC_REQUEST_ARGUMENTSThis table records arguments passed by the concurrent manager to each program it starts running.通过此表记录并发管理开始运行的每个程序的参数。FND_DUALThis table records when requests do not update database tables.此表中的记录不更新数据库表的请求FND_CONCURRENT_PROCESSESThis table records information about Oracle Applications and operating system processes.This table records information about Oracle Applications and operating system processes.FND_CONC_STAT_LISTThis table collects runtime performance statistics for concurrent requests.This table collects runtime performance statistics for concurrent requests.FND_CONC_STAT_SUMMARYThis table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program. The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.This table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program. The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.FND_CONC_PP_ACTIONSStores the post request processing actions(e.g., print, notify) for each submitted request. There's a concurrent_request_id here for each request_id
in the FND_CONCURRENT_REQUESTS.Stores the post request processing actions(e.g., print, notify) for each submitted request. There's a concurrent_request_id here for each request_id
in the FND_CONCURRENT_REQUESTS.FND_RUN_REQ_PP_ACTIONSStores the post request processing actions(e.g., print, notify) for submitted request set programs that are stored in FND_RUN_REQUESTSStores the post request processing actions(e.g., print, notify) for submitted request set programs that are stored in FND_RUN_REQUESTSFND_ENV_CONTEXTThis table stores information about environment name and value for each of the  concurrent process本表为每个并发进程存储关于环境名和变量的信息References