Most of the client running "Purge Concurrent Request and/or Manager Data" program periodically for ALL concurrent program with required retention. But sometime, few less frequent programs logs/outs need to be retain for longer period. In this example, lets assume client need "Gather Schema Statistics" program logs/outs to retain 120 days. Please follow these option to change retention for only "Gather Schema Statistics" program.


1. Using concurrent program definition screen: System Administration Responsibility -> Concurrent -> Programs (search your program) -> Click "Update" to change retention setting ->  Enter Retain for (number of days) -> Apply



2. Using back-end SQL update statement: Login SQLPLUS using APPS database account -> Run following queries


SELECT fcpv.USER_CONCURRENT_PROGRAM_NAME, fcpoi.SHELF_LIFE from FND_CONC_PROG_ONSITE_INFO fcpoi, FND_CONCURRENT_PROGRAMS_VL fcpv

where fcpoi.CONCURRENT_PROGRAM_ID = fcpv.CONCURRENT_PROGRAM_ID

AND fcpv.USER_CONCURRENT_PROGRAM_NAME in ('Gather Schema Statistics');


UPDATE FND_CONC_PROG_ONSITE_INFO

SET SHELF_LIFE = 120

WHERE CONCURRENT_PROGRAM_ID IN (SELECT CONCURRENT_PROGRAM_ID from FND_CONCURRENT_PROGRAMS_VL WHERE USER_CONCURRENT_PROGRAM_NAME in ('Gather Schema Statistics'));


SELECT fcpv.USER_CONCURRENT_PROGRAM_NAME, fcpoi.SHELF_LIFE from FND_CONC_PROG_ONSITE_INFO fcpoi, FND_CONCURRENT_PROGRAMS_VL fcpv

where fcpoi.CONCURRENT_PROGRAM_ID = fcpv.CONCURRENT_PROGRAM_ID

AND fcpv.USER_CONCURRENT_PROGRAM_NAME in ('Gather Schema Statistics');


commit;



About Me

I have 20 years of thorough experience in the Information Technology industry, specializing in Oracle Database, Fusion Middleware, OBIEE, Oracle E-Business Applications, Hyperion, UPK, Oracle Cloud & Virtualization Administration using Oracle Development / Administration / Management / Training tools on different platforms across industry, including C&IP (Manufacturing, Supply Chain Planning), HCM, Financials, and TMT, with knowledge in Project Management, Application Strategy, Software Development Lifecycle (SDLC), and Application Testing (Unit, System, Integration, UAT, and Performance). I worked on number of projects, implementing custom and ERP/CRM Oracle applications and used AIM/ Macro-scope methodology Project Documentation and version control. I used IT Service Management (ITSM) guidelines and ITIL framework on projects to manage Oracle Infrastructure.


Feedback, Comments, Questions?

Please provide your valuable feedback/comments and let me know if any questions? Feel free to contact me for any ORACLE technology assistance.

Contact: +91-9930920689 | Amit.Garg@redcircle.in | Linkedin