foalabs

Purge Concurrent Request and/or Manager Data Program(FNDCPPUR) effect which tables Tables that are updated when Purge Concurrent Request and/or Manager Data Program Program( FNDCPPUR ) is started: FND_CONCURRENT_REQUESTS This table contains a complete history of all concurrent requests. This table should ideally be kept at around 4 - 5k records and should be regularly purged as part of normal 'housekeeping' by running the standard FNDCPPUR program. This is a part of basic system administration and it is recommended that for the average instance, it should be run every 30 days or so. Allowing the table ( and others ) to increase in size can affect performance. 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...

Oracle EBS Release Update from 12.2.0 to R12.2.10 In this post, I am going to share how to upgrade Oracle EBS Release R12.2.0 to R12.2.10 Please note this is my part of the EBS apps upgrade series, so patches might differ if you are doing for a fresh install of R12.2.0 version, but the steps will remain the same. DB Version: 12.1.0.2 EBS version:  R12.2.0 SQL> select release_name from apps.fnd_product_groups; RELEASE_NAME -------------------------------------------------- 12.2.0 Make sure DB and Listener are running Steps: 1) Apply Required Database Patches Download the latest ETCC patch (available via Patch 17537119) of the EBS Technology Code level Checker (ETCC). Use the command checkDBpatch.sh and apply all recommended patches. Please note ETCC patch keeps getting updated, so the patches it recommends might vary from time to time Source DB environment and run the below script. [oracle@ebsupgrade R12210_RUP]$ ls -ltr total 116 -rwxrwx---. 1 root vboxsf 114857 Dec 17 20:43 p1...

Step by Step instruction on EBS R12.1.3 upgrade to R12.2.0 In this post, I am going to share step-by-step instructions on upgrading EBS R12.1.3 to R12.2. My Source Application version: R12.1.3 Database version: 12.1.0.2 Make sure the Database is up and running and Application services are down for 12.1.3. 1) Download the R12.2.0 software zip and keep on the server.( How to Download EBS 12.2.0 ) 2) Add Service ebs_patch in EBS Database [oracle@ebsupgrade 12.1.0]$ sqlplus '/as sysdba' SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 10 21:13:21 2020 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show parameter service NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string GOLD121 SQL> show parameter s...