Owner: APPS DBA URL:http://appsoracle.blogspot.com Join Date: Wed, 30 Jul 2008 08:06:34 -0500 Rating:0 Site Description: It is a blog about oracle apps Site statistics:Click here
Enqueue 2008-07-30 00:34:36 The oracle server uses diffrent type of locks to prevent concurrent access to the data and to prevent destructive interference between the usesFollowing types of locks are available in Oracle Servera. Data Manipulation Locks: its protect the data.Table locks protects the entire table while the row lock protect the selected rowb.Data Doctionary locks-Its protect the schema defination of the tables
Forms in R12 2008-07-29 00:28:15 Features of Form-forms are deployed as a one One OC4J instance of 10.1.3 Oracle home-It uses the utlity from 10.1.2 Oracle home/bin-Forms
.EAR 10.1.2 is deployed to the OC4J container in Application Server 10.1.3-Run time form executabale f60webmx has been replaced by frmweb-Forms Servlet is default deployment / communication mode-FORMS_ environment variables replace FORMS60_-New environment variab
How to find R12 components Version 2008-07-28 04:09:51 Apache Version$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version$IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Versionsh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;" Jre versioncat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35 Forms Version$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version Plsql Version$ORACLE_HOME/bin/frmcmp_bat
Introduction to R12 2008-07-28 04:08:57 Technology ChangeNew Versions of Mid Tier Technology• Application Server: 1.0 -> 10.1• Servlet Container: JServ -> OC4J• Apache: 1.3.19 -> 1.3.34• Forms & Reports: 6 -> 10• R12 File System Change:• The two 11i middle tier Oracle homes are replaced withnewer versions• Instance Home vs. Source HomeComponents Version11iJava Home: 8.1.7-based iAS 1.0.2C Home: 8.0.6-based Developer 6Datab Read more:Introduction
INST_TOP decoded 2008-07-28 04:04:28 With R12 ,Oracle has introduced a new Top call INST_TOP.Features on this top-All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top- All configuration files have been moved to INST_TOPlikeDBc fileAll the http related config filesappsweb.cfgAll the start or stop scriptsall the OC4J related config files-we can now share the Apps and technology stack among multiplenodes and eve
Java Workflow Mailer 2008-07-26 10:14:32 Workflow notification mailer The Workflow Notification Mailer performs email send and response processing for the Oracle Workflow Notification System. By deploying the Workflow Notification Mailer workflow users receive their notifications by email, as well as from the Worklist web pages.Java based Workflow Notification Mailer - Features Java Based Workflow Notification Mailer is indroduced in th Read more:Workflow
Forms 2008-07-26 10:13:52 Summary of Forms
Definitions-The .fmb file is a Form source file. It’s a binary file, which contains metadata, source and compiled PLSQL.-The .fmx file is the generated version of the Form used at runtime-The .mmb file is the Menu source file. It’s a binary file.-The .mmx file is the generated version of the Menu used at runtime-The .pll file is the client side attached library source file.
MLS Installation in 11i 2008-07-26 10:13:19 Introduction to NLS/MLSNLS: National language support. Being able to run an application in 1 language. This language can be any supported language. It basically means the ability to run an Applications instance in any one of the supported languages (other than American English), including certain region/territory specific numeric and date formats. Only the customer-facing components (i.e. the us Read more:Installation
Concurrent Manager 2008-07-26 10:12:39 Internal Concurrent Manager (ICM) The Internal Concurrent Manager (ICM) can be considered the “brain” of concurrent processing. It is responsible for the following functionality: -Starts all other processes like Conflict resolution manager,standard manager -Executes “control requests” submitted by the administrator. -Activate/Deactivate/Abort Concurrent Manager -Termin
AD UTILITIES -III 2008-07-26 10:11:56 AD Controller Usage:AdctrlBy using the AD Controller utility, you can determine the status of AutoUpgrade, AutoPatch, or AD Administration workers. You can also use it to and restart failed tasks.With AD Controller you can:Review worker statusRestart a failed workerRestart a terminated workerShutdown a workerSkip the job with the help of hidden optionQuit a workerThe command to start AD Controller
AD Utililities 2008-07-26 10:10:57 ADODFCMP• ODF (OBJECT DESCRIPTION FILE) COMPARISON UTILITY: • Location of executable: $AD_TOP/bin • Usage: adodfcmp keyword=value [,keyword=value,...] Valid Keywords: odffile -- Filename of ODF file that adodfcmp should read userid -- ORACLE username/password to be compared with ODF file changedb -- Change the database to eliminate the differences? (Default No) log
AD Utilities 2008-07-26 10:10:11 ADRELINK• Adrelink utility relinks Oracle Applications executable programs with the Oracle server product libraries. • For most products, you run this utility in AD Administration by choosing the Relink Applications Programs task from the Maintain ApplicationsFiles menu. Note :- you cannot use AD Administration to relink AD executables, you must run AD Relink manually to link these pro Read more:Utilities
Tuning Tools 2008-07-24 09:19:02 Explain Plan-Shows the execution path of a SQL statement-indicates what tables it will read first and in what order-indicates what indexes it will use, or if new indexes are needed-Helps verify that Oracle will retrieve the data the way you expect it toHow to?Must have full access to a PLAN_TABLE or create PLAN_TABLE with utlxplan.sql delivered by OracleInsert the following command at the top of y Read more:Tuning
, Tools
Apps Useful script 2008-07-16 14:05:47 Script to find out patches appliedselect orig_bug_number,to_char(max(last_update_date),'DD-MON-YYYY hh24:mi:ss') updated from ad_patch_run_bugs where orig_bug_number in ( select distinct app_patch.patch_name from ( select substr(ap.patch_name,1,10) patch_name from ad_patch_runs pr, ad_patch_drivers dr, ad_applied_patches ap where pr.start_date between to_dat Read more:Useful
, script
Some Useful Scripts 2008-07-16 14:00:27 Script to find the sid of the session you are logged in asselect distinct(sid) from v$mystat;************************************************************Script to see all active sessionselect username,osuser,sid,serial#, program,sql_hash_value,module from v$session where username is not null and status ='ACTIVE' and module is not null;************************************************************** Read more:Useful
, Scripts
FNDLOAD and WFLOAD 2008-06-25 03:43:00 FNDLOADINTRODUCTIONThe loader is a general-purpose utility that moves structured data between a text file and a database. Structures supported by the loader include master-detail relationships, and foreign key reference relationships, including arbitrary chains ofsaid relationships.The loader operates in one of three modes: download, upload, or upload_partial. In the download mode, data is downl
No title 2008-06-20 05:47:55 CONCEPTS AND FUNCTIONAL OVERVIEW RAC is the ability to have two or more instances connect to the same database. These instances reside on separate servers, thereby allowing each instance to make full use of the processing ability of each server. As these instances are accessing the same database they need to be able to communicate with each other, this is done through physical interconnects tha
Autoconfig 2008-06-20 03:41:35 -AutoConfig is a tool that supports automated configuration of an Applications instance. -Autoconfig tool is a set of scripts to centralize and simplify E-Business Suite configuration management. -It does so by maintaining a central repository of E-Business Suite environment information in a context file(.xml) on each midtier. -Run adconfig command to propagate changes to all the corresponding fil
Forms facts 2008-06-19 06:11:39 1. Forms
run time trace'http://:/dev60cgi/f60cgi?play=&record=collect&log=/tmp/form1.frd'2.When-logon-Change error comes1 Complie invalids2. Compile all the pll and bounce the forms server3 Jisniter Dowload URLhttp://:/jinitiator/oajinit.exe4.User-exit ere third generation languages which you can cretae and call during formsApplication include variaous USER+EXIT5. Core librraiesAPPSTAND.fmb APPCO Read more:facts
Forms Server Architecture 2008-06-18 00:49:54 Forms Server use a three-tier architecture, consisting of the following components: • Client - A Java Applet running on the client PC that handles the UI presentation. • Middle tier - The Web Listener and the Form runtime that handles the logic.• Database tier – Data-intensive logic and data management.The Forms runtime consists of several components:• The Forms Server listener (f60srvm) Read more:Forms
, Architecture
Guest User password in 11i 2008-06-17 05:33:08 --GUest user password is very important for the functioning of Application SSWA.Self service login used this password to verify the user password.Selfservice will not come upif this password is incorrect.Direct form login will still work if the password is incorrect-It is stored in following places in 11i$FND_TOP/secure/GUEST_USER_PWD profile--It is a application user not a Db user while APPLSYSPU Read more:Guest
Apache[http] 2008-06-16 06:23:13 Important Directive in httpd.confListen:The Listen directive instructs Apache
to listen to more than one IP address or port; by default it responds to requests on all IP interfaces, but only on the port given by the Port directive.ServerRoot sets the directory in which the server lives.PidFilesets the file to which the server records the process id of the daemon. If the filename does not
Jserv Architecture: 2008-06-13 06:23:08 The servlet engine is not part of the web server, but a standalone server application. When executing a servlet request, the web server acts as a client,subrequesting servlets through the network (using the Apache JServ Protocol commonly known as the AJP protocol),converting the returned data and sending it back to the requesting client.Apache JServ can be divided in two main parts:1.Included in t Read more:Architecture
Jserv in 11i 2008-06-13 06:21:45 Important Terms used in Jserv Techonology Explanation for each term used in Jserv is given belowApache JServ - the 100% pure Java server application that acts as an independent servlet-request server. mod_jserv - the Apache module that converts HTTP requests to servlet requests, connecting to the proper servlet engine and sending back the HTTP response to the client. Apache JServ P
Troubleshooting Adpatch failed job 2008-05-30 14:06:05 Types of jobs and their resolutions.odf files :-odf files are there to create tables ,indexes and view etc.-If encountered locking, identify the session that holds the lock and kill the session. Do not skip the job because of locking.Some times odf failed to drop the index.then you can manually drop the index and restart the job..pls scripts :-If the failed pls scripts are for creating stored proc Read more:Troubleshooting
R12 includes Oracle's Containers for J2EE (OC4J) 2008-08-11 06:18:26 -Through OC4J you can execute Servlets, Java Server Pages (JSP), Enterprise Java Beans (EJB)-OC4J replaces the older JServ implementation for running servlets on the web server-Oracle
Application Server 10gR3 (10.1.3) is the latest production version-OC4J is based on J2EE standards:Specific directory structure,File requirements (content & naming conventions),XML file definition-OC4J instances run Read more:Containers
Worflow Mailer 2008-08-06 12:05:10 Java Mailer workingOutbound Notification Processing --Creation of Workflow notification raises oracle.apps.wf.notification.send event.-This event is deferred immediately and placed on the WF_DEFERRED agent.-Workflow Agent Listener on WF_DEFERRED queue process the deferred subscription.-Subscription to this event calls the Generate function (WF_XML.Generate) to generate an XML representation of th
Profiles for OA Framework 2008-08-05 10:24:41 Oracle Applications Look and Feel / APPS_LOOK_AND_FEEL Specifies the look and feel for all OA Framework based pages. This value can be set at any of the Site, Application, Responsibility or User levels. -Valid seeded values include: blaf - Oracle's corporate Browser Look-and-Feel [ OTN Version of BLAF guidelines ] minimal - Generates "minimal" content to reduce the size of HTML pages and over Read more:Profiles
OA Framework Basics 2008-08-04 15:48:03 Key JSP Application ComponentsA typical JSP application involves the following components: a browser for client access, a database for enterprise data and a web application server ("middle tier") where the application objects live.-The browser communicates with the middle tier using HTTP (Hyper Text Transfer Protocol) which involves sending a request message to which the middle tier replies with a Read more:Basics
Apps Useful part II 2008-08-01 09:36:46 To find forms sesssion in databaseset linesize 1000column username format a8 heading "User|Name"column sid format 9999column serial# format 99999column user_form_name format a25column spid format a5column unix_process format a7 heading "UNIX|Process"column user_name format a15 trunc heading "USER NAME"column Responsibility_name format a20 heading "Responsibility |Name"select s.sid, s.serial#, Read more:Useful
Recommend Site To A Friend
