Install OA Framework jDeveloper


Install OA Framework jDeveloper



1. Download JDeveloper 10.1.3.3.0.  Available Oracle patch is p8431482_R12_GENERIC.zip
       Unzip the patch p8431482_R12_GENERIC.zip i.e. in D:\

2. Specify the path of  jdev in following location
       My Computer>Properties>Advanced>Environment Variables as given below screen shot


 

3. Download dbc file of Oracle application instance from $FND_TOP/secure 
    ( it is like a tnsnames.ora file having connection detail )
       Place the file at location D:\p8431482_R12_GENERIC\jdevhome\jdev\dbc_files\secure

4. Open JDeveloper and set database connection goto Connection Navigator > Database and create a new connection


















Note: Give user name and password do not give any role and do not check Deploy Password checkbox

Note Give Host Name, JDBC port, and SID. Keep driver as thin.


Now JDeveloper is ready to use

5. Create a sample workspace and project to know setting during creation of project

1.      Goto Application Navigator right click > New > General > Workspace Configured for Oracle Applications

2.   Give workspace name


3.      Give project name and Default package

Note Default package is
 <3rd party identifier>.oracle.apps.<application_short_name>.<component>.
[<subcomponent>]
     Example: mycompany.oracle.apps.po.requisition.webui


4.      Give database connection detail



5.      Give your dbc file location, application username, application password, application short name, and responsibility key
       i.e. Application short key and responsibility key is nothing but assigned responsibility detail to the application user for example if application user has System Administrator responsibility then Application short name will be “SYSADMIN” and responsibility key will be “SYSTEM_ADMINISTRATOR”. These values are required to compile and run the page because page required context during run time so it will login the application with given username and password and it will take context from assigned responsibility


6.      Click Next. Creation of Workspace and project has finished





No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...