Why Can't Users See The Pick List Selection Requests For Old Orders?

最新推荐文章于 2025-08-15 10:14:10 发布

原创最新推荐文章于 2025-08-15 10:14:10 发布 · 2.3k 阅读

CC 4.0 BY-SA版权

文章标签：

#list #manager #statistics #table #processing #performance

:
	文档 ID:	注释:434792.1	类型:	HOWTO
	上次修订日期:	04-JUN-2007	状态:	MODERATED

In this Document
  Goal
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Shipping Delivery Based - Version: 11.5.10
Information in this document applies to any platform.

Goal

Why are users unable to see the associated pick list selection concurrent request for old orders
in the Additional Line Information section on the Sales Order form? When the users attempt to
review the picking request, users recieve the following message:

APP-FND-01347: You no longer have access to the specific information requested in this screen.

Solution

The concurrent rquest jobs associated to these orders has been purged at one time. Confirm with the System Adminstrator how often the Purge Concurrent Request and/or Manager Data program is being run. This process purges all the details of current requests and makes the details no longer available for review. The reports generated, will be still be available, when linked to the sales order or delivery, but the actual concurrent request job details (all the parameters used) will be purged.

To run this program navigate to Concurrent -> Request -> Run. Query up the Purge Concurrent
Requests and/or Manager Data program.
.
The following tables will be purged:
.
FND_CONCURRENT_REQUESTS
This table contains a complete history of all concurrent requests.
.
FND_RUN_REQUESTS
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_ARGUMENTS
This table records arguments passed by the concurrent manager to each program
it starts running.
.
FND_DUAL
This table records when requests do not update database tables.
.
FND_CONCURRENT_PROCESSES
This table records information about Oracle Applications and operating system
processes.
.
FND_CONC_STAT_LIST
This table collects runtime performance statistics for concurrent requests.
.
FND_CONC_STAT_SUMMARY
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_ACTIONS
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_ACTIONS
Stores the post request processing actions(e.g., print, notify) for
submitted request set programs that are stored in FND_RUN_REQUESTS