satyeshblog.blogspot.com
Satyesh's Blogs: May 2006
http://satyeshblog.blogspot.com/2006_05_01_archive.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Saturday, May 27, 2006. SQL to Find All initialization parameter (including Hidden ). This script need to be run as "sys" account. Sqlplus "/ as sysdba". Select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value". From x$ksppi a, x$ksppcv b, x$ksppsv c. Where a.indx = b.indx and a.indx = c.indx. Tested with version 9.
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APPS: How to add Remote database using CC JOB
http://satyeshblog.blogspot.com/2006/11/oracle-apps-how-to-add-remote-database.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Wednesday, November 08, 2006. ORACLE APPS: How to add Remote database using CC JOB. I need to add a remote server in Database using CC JOB. First check what are already define as Remote Server. Under Configurator Application Name. Now add your new remote Server. With following CC JOB. Define Remote Server under Configurator Application Name. Now enable the new Re...
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APPS: How To Update and Move Workflow From One Instance to Another Instance?
http://satyeshblog.blogspot.com/2006/11/oracle-apps-how-to-update-and-move.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Wednesday, November 08, 2006. ORACLE APPS: How To Update and Move Workflow From One Instance to Another Instance? How To Update and Move Workflow From One Instance to Another Instance? Let say test is Source and PROD is target instance. 1 Login to test - set the environment -. Run the following commands -. 4 Test the results. Another way is to use the workflow bu...
satyeshblog.blogspot.com
Satyesh's Blogs: June 2006
http://satyeshblog.blogspot.com/2006_06_01_archive.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Friday, June 30, 2006. ORACLE APPS : Invalid object in Database. Today I had issue where object in EB 11.5.10 are invalid even after recompiling. The following error message we see when we try to recompile the object. After looking at code for the pkg body we find the offending SQL is of sub query in column list of select statement. Rul typ number := 200;. Oracle...
satyeshint.blogspot.com
Interview: July 2006
http://satyeshint.blogspot.com/2006_07_01_archive.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Saturday, July 01, 2006. ORACLE APPS : FAQ 1. What happens if the ICM goes down? How will you speed up the patching process? How will you handle an error during patching? Provide a high-level overview of the cloning process and post-clone manual steps. Can you tell me a few tests you will do to troubleshoot self-service login problems? Look at the log of the fail...
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APPS: How to add Read only account for OAM?
http://satyeshblog.blogspot.com/2006/07/oracle-apps-how-to-add-read-only.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Thursday, July 06, 2006. ORACLE APPS: How to add Read only account for OAM? How to add Read only account for OAM? Verify you have OAM Patch 2.1.1 or higher. Select * from ad bugs where bug number in ('2600516'). These Oracle Applications responsibilities for OAM are:. System Administrator - this responsibility has access to all functionality in OAM. ORACLE APPS: ...
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APPS: ORA 01031 during clone build.
http://satyeshblog.blogspot.com/2006/11/oracle-apps-ora-01031-during-clone.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Wednesday, November 08, 2006. ORACLE APPS: ORA 01031 during clone build. Today I was working on building new clone . System admin give me the system which was not build as per deployment Doc and having loose ends all over the places. Some example. DNS was not push out. Unix account created but no group added. Var/opt/oracle was not created. Here is what I had.
satyeshblog.blogspot.com
Satyesh's Blogs: ORA-24026: operation failed, queue APPLSYS.WF_CONTROL error in WF Notification Mailer (+ solution)
http://satyeshblog.blogspot.com/2007/03/ora-24026-operation-failed-queue.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Thursday, March 22, 2007. ORA-24026: operation failed, queue APPLSYS.WF CONTROL error in WF Notification Mailer ( solution). The orkflow mailer does not run because of errors in the log file. ORA-20002: 3825: Error '-24026 - ORA-24026: operation failed, queue APPLSYS.WF CONTROL has. Errors' encountered during execution of 'WF RULE.ERROR RULE' for event. ORACLE AP...
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APP : IMP of Operation Unit System profile
http://satyeshblog.blogspot.com/2006/11/oracle-app-imp-of-operation-unit.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Friday, November 10, 2006. ORACLE APP : IMP of Operation Unit System profile. On typical Friday I got a Multiple request that one of our critical environment is down. 1 Login into Oracle Applications. 2 Select the System Administrator Responsibility. 3 Navigate to Profile - System. 4 Query up "MO: Operating Unit" profile. From fnd profile options where PROFILE OP...
satyeshblog.blogspot.com
Satyesh's Blogs: ORACLE APPS: Why doesn't the "Launch Diagnostic" button work in 11.5.10 (OAM 2.3.1)?
http://satyeshblog.blogspot.com/2006/07/oracle-apps-why-doesnt-launch.html
As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference. Thursday, July 06, 2006. ORACLE APPS: Why doesn't the "Launch Diagnostic" button work in 11.5.10 (OAM 2.3.1)? Why doesn't the "Launch Diagnostic" button (on the Diagnostics page of the Applications Dashboard of Applications Manager) work in 11.5.10 (OAM 2.3.1)? Posted by Yesh Jaiswal at 7/06/2006 05:46:00 PM. View my complete profile. ORACLE APPS : FAQ 1.