OAF(APPLYING PATCH AND DB CONNECTION )

    DBC CONNECTION(DATA BASE CONNECTION) IN OAF(ORACLE APPLICATION FRAMEWORK)
    =========================================================================

    HOW TO CONFIGURE THE OAF BY USING OAF(jdev) PATCH FILE:
    *******************************************************


 1-- FRIST WE SHOULD KNOW THE OUR ORACLE APPS VERSION IN OUR SYSTEM
 2-- THE ORACLE APPLICATION VIRSION IS IN THE BELLOW PAGE THAT IS
     "ABOUT THIS PAGE"

     SOME TIMES IT IS NOT TO SHOW OUR SYSTEM, THAT TIME WE SHOULD
     SETUP THIS

     HOW TO SETUP THIS (ABOUT THIS PAGE)
     -----------------------------------
     --> TO SWITCH THE SYSTEM ADMINISTRATOR          
                        |
                         PROFILE (OPTION)
                           |
                            SYSTEM (OPTION)
         HEAR TO GIVE PROFILE NAME AS FND%DIA%
        
         AND THEN HEAR THE SITE IS TO GIVE 'YES'.
3---AND THEN GO FOR (ABOUT THIS PAGE) OPTION IN UNDER THE PAGE TO     GET THE
    OUR SYSTEM ORACLE APPS VIRSION...
    HEAR TO CLICK THE (TECHNOLOGY COMPONENTS) OPTION AND GET THE     VERSION
   
    Ex: VIRSION IS 12.1.1
    SO TO GIVE THE OAF PACH IS SAME VIRSION

NOTE: IN THIS VERSION WE HAVE TO GET IN NET TO DOWNLOAD,THE SITE       IS (WWW.EDELIVERY.COM FOR (ALL ORACLE))


4---BE FORE GOING TO GIVE THAT VIRSION FIRST TO CREATE ONE FOLDER     IN 'C' DRIVE
    Ex: OAF    
    AND THEN TO GIVE OUR(PATCH) AND EXTRCT THIS TO GET THE VIRSIN     OF OAF PATCH FILE IN THAT 'C:\OAF'        FOLDER
         
5--AND THEN IN THIS PATH AR THREE FOLDER WE GET
     Ex: 1.jdevbin
         2.jdevdoc
         3.jdevhome
 
   AND THEN WE NEED TO GET THE OUR ORACLE APPS DBC FILE AND THIS    FILE
   WE NEED TO PLACE IN OAF PATCH FILE IN ( i.e jdevhome) FOLDER

6--THE DBC FILE IS IN OUR ORACLE SERVER
  
   AND ALSO FINDOUT THIS
   TO GO TO (ABOUT THIS PAGE) OPTION IN UNDER THIS PAGE
   AND TO CLICK THE OPTION IS (PAGE CONTEXT) TO GET THE DBC


   Database  D:\oracle\VIS\inst\apps\VIS_apps\appl\fnd\12.0.0\secure\VIS.dbc
  
   
7--AND THEN THIS VIS DBC FILE TO COPY AND PAST IN OAF PATCH FILE
    Ex:- C:\OAF\jdevhome\jdev\dbc_files\secure

  IN THIS VIS TO OPEN AND COMMENT 'URL' USING THIS(#)

8--AND THEN TO TAKE TO SEND THE SHORTCUT(jdevw) TO 'DESKTOP' USE    THE OAF

9--AND THEN TO CREATE SOME ENVIRONMENT SETING'S
  
  --- RIGHT CLICK AND GO TO SELECT PROPERTIES IN 'MY COMPUTER'
  --- HEAR TO SELECT 'ADVANCED' SETTINGS AND TO SET 'ENVIRONMENT       VARIABLES'
  --- AND TO CREATE NEW VARIABL & VALUE HEAR
        HEAR TO SELECT 'NEW' OPTION AND GIVE VARIABL & VALUE
        EX:-
           VARIABLE NAME : JDEV_USER_HOME
           VARIABLE VALUE: C:\OAF\jdevhome\jdev //OAF PATH

10--FINALY THE OAF DBC CONNECTION IS COMPLETE

11-- AND IT IS READY TO USE

NOTE: AND THEN WE NEEDTO TEST THIS DBC CONNECTION IS WORK OR NOT
----
12-- FIRST TO CLICK ON (jdevw) SHORTCUT ON DESKTOP

13 AND THEN TO CREATE DATABASE AND TEST

   BEFORE GOING TO CREATE DBC CONNECTION WE NEED TO KNOW THE WIDOW'S    NAME'S

NOTE: 1.SYSTEM NAVIGATOR
         I .APPLICATION NAVIGATOR
         II.CONNECTION NAVIGATOR

      2.STRUCTURE WINDOW
      3.BUSINILOGIC
      4.PROPERTY INSPECTOR
      5.LOG (PROGRAME LOG DETAILS)

NOTE: THE DBC CONNECTION IS CREATE IN THE('CONNECTION NAVIGATOR' UNDER THE 'SYSTEM NAVIGATOR')
-----   IN THE ABOVE WINDOW'S



CONNECTION:
==========

1  --HEAR TO GIVE DATABASE CONNECTION NAME

2  --HEAR TO GIVE OUR ORACLE DB CONNECTION

        *  USERNAME:APPS
        *  PASSWORD:APPS

4 NOTE: HEAR TO GIVE OUR ORACLE HOSTNAME & SYSTEM PORT NO
  ----
5        *  HOSTNAME:apps.ora.com

  NOTE: THE ABOVE HOSTNAME LOCATION IS GIVEN BELLOW
  -----
         HOST NAME IS IN=C:\WINDOWS\system32\drivers\etc\hosts
     
6        *  PORT NO:1521

  NOTE: THE ABOVE PORT NO LOCATION IS GIVEN BELLOW
  -----
         PORT NO IS IN= D:\oracle\VIS\apps\tech_st\10.1.2\NETWORK\ADMIN\tnsnames.ora.bak

7        *  AND SID:vis // THIS IS OUR OUR ORACLE DB HOST NAME

  --HEAR TO TEST OUR DB CONNECTION IS WORK OR NOT

  --FINALY OUR DB CONNECT IS SUCCESS AND FINISH IT

NOTE: THIS CONNECTION IS NOT NECESSARY TO CREATE EVERY TIME
====
      WE CAN USE THIS DB CONNECTION ALL OUR EVERY NEW CREATION OF       PROJECTS(APPLICATIONS)


-----> AND THEN GO FOR TO CREATE OUR NEW PROJECT IN APPLICATION        NAVIGATOR