Miscellaneous Technology

This article is for setting up the PC for Oracle Apps development, for the readers of http://getappstraining.blogspot.com

9i/10g Oracle Client
---------------------------
This will install
    Workflow Builder
    SQL*Plus
Once installed, you must then try to connect to the apps schema of your development database.




D2K, with forms version 6i
---------------------------
This will install
    Oracle Forms
    Oracle Reports
Next, you need to upgrade the default version of installed Forms 6i by downloading and applying patch 3596539 from Metalink.
Once installed, ensure that you can connect to apps schema from Oracle Forms and Oracle Reports.




A Unix client
---------------------------
A unix shell program like ssh or putty or any others, that
  a. Lets you do ftp or sftp with your servers
  b. Lets you logon to your middle tier or the database tier to Unix Prompt
Note: I am assuming a Unix install for Oracle Applications.



Oracle jDeveloper for OAF ( Optional:- Only needed if developing extensions to OAF).
Download patch 4045639 from Metalink. Please note that this patch comes bundled with jDeveloper and all the Apps related libraries.

Oracle IDE
---------------------------
A rapid pl/sql development tool like TOAD or PL/SQL developer or Golden or SQL*navigator. Note this is optional, but I suggest you get used to one of these. My personal favorite is Pl/SQL developer from http://www.allroundautomations.com/plsqldev.html




Workflows
--------------
I suggest you create a directory similar to c:\oracle\wf
Next you need to ensure that you are able to connect to apps schema from the workflow builder. Once connected, open workflow named Standard, and save this as WFSTD.wft.

Click on File/Open in Workflows Builder

Connect to database to apps schema

Open workflow Standard and save it as WFSTD.wft. You will require this wft file for building all new Workflows.

Next we need to do the following:-
1. Ensure that you are able to connect to apps schema from all the above tools.
2. FTP any given Oracle delivered report to your PC. Next you need to ensure that you are able to open that report. This is equivalent to sanity checking your Reports install, but is optional step.
3. FTP the following files from your mid tier, to a directory named “c:\oracle\forms”
            TEMPLATE.fmb
            APP*.pll
            FND*.pll
   Note: These files are available on $AU_TOP/forms/US or from $AU_TOP/resource
Add directory “c:\oracle\foms” to your registry path named FORMS60_PATH. In order to do this, do windows run, regedit, inside registry follow path HKEY_LOCAL_MACHINE/SOFTWARE/Oracle.
You will see a variable named FORMS60_PATH.



After setting your registry path, open the forms designer, and see if you can open template.fmb without any problems. If you are prompted that any specific library is missing, then ftp that library too into your c:\oracle\forms. In case, when opening the form, you get an error like "xyz.pll is missing" and if you believe xyz.pll is already there on your pc, the you should try to open xyz.pll itself.
The error might be related to some other pll being referred indirectly by xyz.pll. In simple words you need to recursively ftp all the form files, which are needed as foundation for forms development in apps.

Similarly, you need to add c:\oracle\reports to the REPORTS60_PATH in registry.



You are now ready to roll with your Oracle Apps development tasks…..

Anil Passi

Add comment