We have seen this issue very recently in our EBS instance where users were not able to open Log & Out files in browsers in…
8 CommentsCategory: Apps Troubleshoot
Inactive Connection Timeout is a feature in WebLogic that allows you to configure the amount of time a connection can be inactive before it is…
Leave a CommentWorkflow Deferred Agent Listener is a background process that is responsible for processing the deferred workflow activities. This process is automatically started when the system…
1 CommentRC-40201: Unable to connect to Database is a common error that occurs when running adclonectx in Oracle EBS R12.2. This error occurs when the connection…
Leave a CommentPurge ATP Temp Tables is a concurrent program in Oracle EBS R12.2 that is used to clean up temporary tables created by the Advanced Planning…
Leave a CommentIn our EBS system, we found that SYSADMIN login was slow. It was taking around 4-5 minutes to login and when inside the EBS application it was taking 2-3 minutes every time we were navigating in the self-service pages. This issue was not occurring for normal EBS users. We thought of applying the trace to SYSADMIN user to find the root cause of it.
2 CommentsAll Oracle Apps DBA must have referred below Note id at least once in their career. Most of us refer it during installation and upgrade of Oracle EBS
application to verify if we have right set if database parameters defined for the optimum performance of EBS application.
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
This document has all the required database parameters which are common to all the database release and which are required by EBS application. It also contains release specific database initialization parameters for different releases like 10g, 11g, 12c etc.
Leave a CommentOne of our EBS R12 instance was giving below kind of errors when users were trying to open the log and out files of Concurrent requests from EBS front end.
“The Applications File Server could not open the file /fs01/logs/appl/conc/log/l106163221.req for read”
Leave a CommentUsually in OLTP environment like EBS Applications, tables are often get fragmented due to multiple DML activities that happens.Fragmented tables cause queries on those tables to slow down. It is very important to de-fragment this table and to reclaim the fragmented space from these objects.
For EBS we have also seen that usually gathered statistics, indexing and proper SQL tuning is plenty to improve and maintain acceptable performance but sometime it is required to reorg the table.
One primary cause of fragmentation is that when you run delete command on the tables it delete the rows but doesn’t frees up the memory and also do not changes the high water mark.
7 CommentsConcurrent processing uses the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests. Post-processing actions are actions taken on concurrent request output. An example of a post-processing action is that used in publishing concurrent requests with XML Publisher.
Apps DBAs have to sometimes troubleshoot issues related to OPP. Many a times issues are related to java memory with error messages like below:
Leave a Comment