Monday, November 21, 2016

Step by Step OAF Setup for development environment



In our first step we will download correct version of Jdeveloper with OA Extension. To get the correct version, we will first establish the version of E-Business Suite (EBS) we are on  then download JDeveloper from Oracle Support and install it.

  1. Log on to EBS and click on the About this Page link.
  2. Click on the Technology Components tab
  3. Version will display to you
  4. We will download to support support.oracle.com
  5. Find the note How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x [ID 416708.1]. Type 416708.1 in the search box, and click the search icon.
  6. Click on the version we require to download
  7. Click on the Download button to download the correct version to your PC
  8. Unzip the file into a local directory called C:\Jdev

Note :


You will notice that JDeveloper has created the following three directories under the C:\Jdev directory (or the directory you chose to unzip it in): jdevhome—All pages and code we develop. Also, contains the .dbc file to connect to the database instances. jdevbin—All Jars, executables for Jdev and FND classes. jdevdoc—Contains all of the Oracle OAF tutorials, the Developer Guide (HTML), and an explanation of all the classes, methods, and parameters.


Setup Environment Variable


  1.  Right-click on My Computer or Computer, and select Properties from the menu.
  2.  Click on Advanced System Settings to open the System Properties window.
  3.  Click on the Advanced tab.
  4.  Click on the Environment Variables button.
  5.  Select the New button for user variables.
  6.  In the Variable name field, enter JDEV_USER_HOME.
  7.  In the Variable value field, enter the directory of the jdevhome\jdev directory, for example, C:\oaf\jdevhome\jdev as shown in the following screenshot
  8. Press Button OK.

Transferring DBC from Application Server

In order to connect Jdeveloper to database we need DBC file, now we will transfer DBC file to our local directory for creating database connections with JDeveloper.

  1. Open WinSCP and connect to the application server.
  2. FTP the .dbc file to your local PC from the $INST_TOP/appl/fnd/12.0.0.0/secure directory on the application server to the jdevhome\jdev\dbc_files\secure directory as shown in the following screenshot


Creating Shortcut to Desktop.
  1. Navigate to the directory, C:\oaf\jdevbin\jdev\bin.
  2. Right-click on the jdevw.exe and select Send To | Desktop (create shortcut).
  3. Rename the shortcut on the desktop if desired, for example, Jdev R12.  


Creating database connections in JDeveloper

To add a database connection, perform the following steps:

  1. Start JDeveloper. 
  2. Click on the Connections tab in Applications Navigator. 
  3. Right-click on the Database node, and select New Database Connection.

The new database connection wizard will now be displayed.
4. Click on Next on the welcome page  and check Skip this Page Next Time if
desired.
5. In the Connection Name field, type VISR12 (this is just a name for the connection
and can be anything relevant), and click on Next.

6. When prompted, enter apps in the username field and the <apps password> in the
password field, that is, apps/apps and click on Next.
7. Enter the following connection details:

8. Click on the Next button.
9. Click the Test Connection button and then Finish as shown in the following
screenshot:
 



Setting up OC4J and project properties


  1. Open JDeveloper. 
  2. Check the OC4J Settings in Tools | Embedded OC4J Preferences Global Startup. 
  3. Check if the Host Name or IP Address Used to Refer to Embedded OC4J is set to Default Local IP Address, as shown in the following screenshot: 
  4. Press Button OK


Setting up OAF runtime connection


  1.  Open JDeveloper.
  2. Navigate Tools --> Project Properties --> Oracle Applications --> Runtime Connection 
  3. Set the following fields:

                 DBC File Name: C:\Jdev\jdevhome\jdev\dbc_files\secure\VISR12.dbc
                 User Name: sysadmin
                 Password: sysadmin
                 Application Short Name: ICX
                 Responsibility Key: FWK_TBX_TUTORIAL

        4. Press Button OK

Saturday, October 15, 2016

Error No: 53 File not found Bi Publisher

Navigation:
 Ms Word -->Tools -- > options --> preview tab.


Java home should be selected there, if not select it or update path



Thursday, August 11, 2016

Query to get the list of form Personalization


Select Distinct ffcr.Id, ffcr.Form_Name, ffcr.Enabled,
       fft.User_Form_Name,  fat.Application_Name, ffcr.Description,
       ffca.Action_Type, ffca.Enabled, ffca.Object_Type,
       ffca.message_type, ffca.message_text
 from FND_FORM_CUSTOM_RULES ffcr,
      FND_FORM ff,
      FND_FORM_TL fft,
      Fnd_Application_Tl fat,
      Fnd_Form_Custom_Actions ffca 
where ffcr.form_name = ff.form_name
 And ff.Form_Id = fft.Form_Id
 And ff.Application_Id = fat.Application_Id
 And fft.User_Form_Name Like 'XXCUST%'
 And ffcr.Enabled ='Y'
 and ffcr.id = ffca.rule_id;

Query to get the list of Custom objects (TABLE, VIEW, PROCEDURE, FUNCTION AND PACKAGE)


select object_name, object_type
 from all_objects
 where 1=1
 and upper(object_type) IN ('FUNCTION','PACKAGE','PROCEDURE', 'VIEW', 'TABLE')
 and status='VALID'
 and object_name like 'XXCUST%'
order by 2;

Query to get List of Custom Form List

SELECT  DISTINCT forms.form_name,
          formstl.user_form_name,
          func.function_name,
          func.user_function_name,
          fm.menu_name,
          menu.prompt menu_prompt,
          menu.description,
          restl.responsibility_name
   FROM   fnd_form FORMS,
          fnd_form_tl FORMSTL,
          fnd_form_functions_VL FUNC,
          fnd_menu_entries_VL MENU,
          FND_MENUS FM,
          fnd_responsibility RES,
          fnd_responsibility_tl RESTL
  WHERE   1=1
          and forms.form_id = formstl.form_id
          and func.form_id = forms.form_id
          and menu.function_id = func.function_id
          and menu.menu_id=fm.menu_id
          and res.menu_id = menu.menu_id
          and res.responsibility_id = restl.responsibility_id
          and UPPER(forms.form_name) like '%XXCUST%'      
          order by 1;

Query to get List of Custom Concurrent Programs


SELECT DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",
 fa.application_name,
 fcp.concurrent_program_name conc_short_name,
 decode( fef.execution_method_code, 'H','Host',
 'I', 'PLSQL Stored Procedure',
 'P', 'Report',
 'L', 'SQL Loader',
 'Q','SQL*Plus',
 'A','Spawned',
 'K','Java Concurrent Program',
 'B','Request Set Stage Function',
 'S','Immediate',
 'J','Java Stored Procedure',
 'M','Multi-Language Function',
 fef.execution_method_code) "execution method",
 fef.executable_name,
 fcp.description "Concurrent Program Description",
 fef.executable_name"Executable Name",
 fef.description "Executable Description",
 fef.execution_file_name ,
 fcp.enabled_flag
 ,fcp.creation_date
FROM fnd_executables_form_v fef,
     fnd_concurrent_programs_VL fcp,
     fnd_application_tl fa
WHERE fcp.application_id=fef.application_id
  AND fa.application_id=fcp.application_id
  AND fef.executable_id=fcp.executable_id
  AND UPPER(fcp.user_concurrent_program_name) like '%XXCUST%'
ORDER BY 4;