Posts by jayan sellappan

Autoconfig Issues seen after a Clone

After Completion of oracle clone , faced issue while running autoconfig. ERROR : ——– ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at…

Read More

Corrupt Block alert in Alert Log

Error : ======= Bad header found during buffer read Data in bad block: type: 2 format: 2 rdba: 0x21008dd0 last change scn: 0x0006.12114f8e seq: 0x37 flg: 0x04 spare1: 0x0 spare2:…

Read More

Ways To find whether the module is installed or not in Oracle Applications

We have 3 ways to find out if a module is installed in oracle apps 1 We can run the following script cd $AD_TOP/sql/adutconf.sql In this script, there is a…

Read More

12C : Unified Audit Trial was not captured during successful Login and Failures

From oracle 12.1, unified audit trail has been introduced. To enable this audit_trail parameter should be set to none. However we observed that even though ORA_LOGON_FAILURES was available in AUDIT_UNIFIED_ENABLED_POLICIES…

Read More

12C : SQL Tuning Advisor is not Running even though its enabled

Recently I faced a new issue in 12C. In automated maintenance task, sql tuning advisor was already enabled. but its still showing not running. Even I have validated dba_autotask_operation, it…

Read More

R12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request nnnnn’

E-Business Suite R12 Concurrent Processing, Output Post Processing related issues Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request…

Read More

ORA-12152 “Unable To Send Break Message” on Connection

When trying to login to the database from a client(Toad, SQL Developer) when using a Cisco GSS and a CSM (Content Switch Module) the connection fails to complete or fails…

Read More

Error: “Unable to Connect” Oracle Apex Access Issue

Recently we had install the Oracle Apex and installation done successfully and access via local system Oracle Apex running perfectly but while we access in remote then we had faced…

Read More

How to Create a Custom Concurrent Manager

Adding Concurrent Manager is a crucial decision. Lots of things needs to be examined before adding new Concurrent Manager. One of the major area is resources.If you have less number…

Read More

How To Remove Error Notifications From The Worklist (Doc ID 357904.1)

racle Workflow – Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] Oracle Order Management – Version 12.2.4 to 12.2.4 [Release 12.2] Information in this document applies to any platform. GOAL…

Read More