All posts by Atul Kumar
Collection of Queries/Scripts
1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’; 2)How to Correct Session Cookie Name. a)select session_cookie_name from icx_parameters; b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’; c)select session_cookie_name from icx_parameters; 3) How to find database SID from a Concurrent request. column process heading “FNDLIBR PID” […]
Read MoreTables Used by Purge Concurrent Request Concurrent Program
Source: Oracle Documentations Log and Output files retention policy can be controlled by you at o/s level. Once you decide the retention policy for these logs and output files, the Purge Concurrent Request Concurrent Program or the Manager Data Concurrent Program will act, based on the information located in the database tables to determine which […]
Read MoreCollection of Workflow Administration Scripts and/or Concurrent Program
Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data” to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in […]
Read MoreKill Oracle Sessions
One day My manager fired one sql statement, it got stuck and not moving further. He called up me and asked to kill Oracle Session. I immediately killed his oracle session using SQL*PLUS approach. I would like to share what I did . Here I am giving the procedurehow to kill Oracle Sessions using […]
Read MoreLog files in $APPLCSF/$APPLLOG directory
I would like to share some important things here. You all might know these, but Oracle Apps newbie will get benefited. As we know that, when ever any Concurrent Request is submitted, log and output files are stored in $APPLCSF/$APPLOG and $APPLCSF/$APPLOUT directories respectively. Apart from *.req files, some other files are also getting stored […]
Read MoreLinux/Unix Basics
‘ROOT‘ on linux is the centre of all power. This account/user is the system administrator who has the access to all files & folders & can add or delete users or change their passwords. Some of the basic commands used on linux useful for Oracle Apps DBA’s are: 1. useradd The general syntax for the useradd command […]
Read MoreOracle E-Business Suite (R12) Apps DBA certification exam released
The Oracle University have just now launched the beta track of the Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238] This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified Professional certification By participating in this beta exam, you have the opportunity to provide the Oracle […]
Read MoreVertex Quantum
Welcome to the Vertex Quantum for Sales and Use Tax application. I will describes the installation and configuration steps involved in interfacing the Quantum Sales and Use tax software with Oracle Applications 11.0.3 and 11i for Business OnLine as well as the maintenance and support information. Also will include information on upgrading from Oracle Applications 11.0.3 […]
Read More11i(Old) and R12(New) Mount Points
The table below shows the default file system mount points between the 11i and R12 for Applmgr and Oracle user. The most important thing to note about the R12 file system is that there is (SID) or (TWO_TASK) in the directory structures . Click on above Image to enlarge it
Read MoreR12 Instance Home Overview
Oracle Applications/E-Business Suite Release 12 introduces a new concept of a top-level directory for an Applications Instance which is known as Instance Home and is denoted the environment variable $INST_TOP. Instance Home contains all the config files, log files, SSL certificates etc. Advantages of new INSTANCE HOME The additional Instance Home makes the middle tier […]
Read More