Monthly Archives: September 2021

The Store Record X Could Not Be Found

Shutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers   find . -name “*.DAT” -print find…

Read More

Life At Doyensys – Bhagavathy Ramachandran M

We at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiencies. It is those values of our employees that has kept us growing…

Read More

New Data Guard Oracle 19c Database

Data Guard Oracle 19c Database Replicate Restore Points from Primary to Standby Dynamically change Fast-Start Failover (FSFO) target standby database to another standby database in the target list without disabling…

Read More

New tables/views in Oracle 19c Database

New tables/views in Oracle 19c Database   dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS

Read More

New initialization parameters in Oracle Database 19c

New initialization parameters in Oracle Database 19c “_optimizer_gather_stats_on_conventional_dml” and “_optimizer_use_stats_on_conventional_dml” which are true by default _optimizer_stats_on_conventional_dml_sample_rate (at 100%) DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ADG_REDIRECT_DML (TRUE or FALSE) MAX_DATAPUMP_JOBS_PER_PDB aws_pdb_autoflush_enabled (TRUE or FALSE)

Read More

Auto Refresh Report and Hide Processing Spinners in Oracle Apex

Overview This document explains how to auto refresh report after a specified interval and hide processing spinners in oracle apex. Technologies and Tools Used The following technologies have been used…

Read More

“Output Post Processor” Concurrent Manager not able to start R12.1

Cause: Unable to initialize state monitor. oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “APPS.FND_CP_GSM_IPC”, line 499 ORA-06512: at line 1 at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233) at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)…

Read More

adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file.

Cause: $ adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. Solution : Check adop log using $ADOP_LOG_HOME command $ cd…

Read More

txkISGConfigurator.xml Fails with Error PatchContextFile Doesn’t Exist

Cause: BUILD FAILED /u01/app/122/fs1/EBSapps/comn/java/classes/oracle/apps/fnd/txk/util/txkISGConfigurator.xml:1756: ${patchContextFile} doesn’t exist ! The issue can be reproduced at will with the following steps: 1. “ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStop=yes” There was a missing entry…

Read More

FIND APEX USERS LOGIN DETAILS

Description: Following sql script is used to find the Application Express users , who all are logged in previous days or specific period (months , years) . Steps: 1.Login as…

Read More