Introduction This Query will help to Fetch the Item Master Extract Report Data in Oracle Apps. SQL Query: SELECT DISTINCT (SELECT organization_code FROM mtl_parameters WHERE organization_id = msi.organization_id AND ROWNUM…
Read MoreIntroduction This Query will help to Fetch the On hand Inventory by Revision Report Data in Oracle Apps. SQL Query: /* Formatted on 2021/09/06 15:26 (Formatter Plus v4.8.8) */ SELECT…
Read MoreThe below query is used to find the history of sql statement which has been executed earlier. Below query has been used for finding the yesterday data. eg: set colsep…
Read MoreBLOCK CHANGE TRACKING Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all…
Read MoreProblem: Adcfgclone got complete but at the end it failed for autoconfig with the below error. Error : WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during…
Read MoreIncrease the report server engine to run multiple reports in parallel. Take a backup of rwsever.conf file cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 cp -rp rwserver.conf rwserver.conf_bck Change the maxEngine value from 1 to…
Read MoreOracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query…
Read MoreIf you got this error in the RMAN active duplication of RAC database fails on restart operation with the following error messages: RMAN-03002: failure of Duplicate Db command at 02/17/2021 15:12:11…
Read More1. As <ROOT_USER>, log in to Node 1 and cd to the “/tmp” directory. # cd /tmp 2. Use “vi” or editor of your choice, to create the “osw_capture” script…
Read MoreManually Generating Segment Advisor Advice ========================================== Step 1 – Create a task. dbms_advisor.create_task ( advisor_name => ‘Segment Advisor’, task_id => my_task_id, task_name => test123, task_desc => my_task_desc); Step 2 – Assign an object…
Read More