Install Oracle E-Business Suite Release 12 on MS Windows

In this article i will explain how to install Oracle EBS R12 in MS Windows. I am going to explain two methods 1) EBS R12 on Windows 2003 Server
2) EBS R12 on Windows XP.
I will strongly  recommend to install R12 on Windows 2003 server. It is more reliable and will provide you maximum functionality.

Oracle E-Business Suite Release 12 on Windows 2003 Server.

My Hardware & Software Specifications:  Booting and Running speed is excellent by using following hardware.
- Intel Pentium Core 2 DUO, CPU 2.0 GHz
- 4 GB of RAM
- 250 GB Hard Drive
- Windows 2003 Server with Service Pack 2

- R12 Stage  Down load from http://edelivery.oracle.com
- MKS Tool Kit   licenced  download from http://webstore.mkssoftware.com
- Visual C++ 8.0 licenced (Included in Microsoft Visual Studio 2005)

Installation Steps:
1) Install Windows 2003 Server with SP2
Make sure you have installed Network driver successfully.
2) Set ‘Computer Name’ .



- Right click on ‘My Computer’ > Properties > ‘Computer Name’ > Change
- Set ‘Computer Name’ to r12   (you can other give any name)



3) Set the domain
- Click on More
- Set a ‘Primary DNS Suffix of this Computer’ to   oracle.com    you can choose any other name (myoreacle.com)


 

4) Add a new entry in C:\windows\system32\drivers\etc\hosts as follows:



replace localhost  with   r12.oracle.com

5) From the command prompt, make sure you can do the following:  
        C:\> ping   r12.oracle.com

6) Install Visual C++ 8.0 (Which is included in Microsoft Visual Studio 2005) in ‘C:\VS8′  Directory name should not contain spaces

7) Download ‘MKS toolkit’ and install in c:\mksnt\

8- Copy  link.exe  ,   cl.exe  from  c:\vs8\vs\bin to c:\mksnt\mksnt\

9) Copy which.exe from   c:\mksnt\mksnt\ to c:\vs8\lib\

10) Copy GNUMAKE.EXE  to c:\windows\system32   

11) Restart Computer

 12) Set Up the Stage Area:
Stage Area (c:\stage12) requires a 32 GB hard disk space.  Make sure stage12 name should not contain spaces and should have read/write permissions.
Extract the zip files which have been downloaded from (http://edelivery.oracle.com). Nothing special to do since the extracted files will create the stage area directory structure by itself. You should see the following structure under ‘C:\stage12′ once you are done with the files extraction: Make sure there should not be spaces stage directory name.
- startCD
- oraAppDB
- oraApps
- oraAS
- oraDB


13) Start the installation:
Run rapidwiz from following path
C:\stage12\startCD\Disk1\rapidwiz> RapidWiz.cmd

For ‘VC++’ and ‘mks’ I have provided the following paths:
s_MSDEVdir=C:\VS8\VC
s_MKSdir=C:\mksnt\mksnt


14) Follow the wizard and sit back and relax until installation completed.

15) After installation complete open the browser and write following URL    r12.oracle.com:8000

Sample Code and Output- Run Work Flow API

To get a notification/email that looks similar to below, all you need to do is to call a PL/SQL API
Sample Below Desired Notification from API is shown below

To generate such Notification, call the API

STEP 1
RUN BELOW SQL and DO COMMIT;
xx_dev>>SET serveroutput on;
DECLARE
  n_not_id INTEGER;
BEGIN
  xx_notifications_api_pkg.send_notification(
     x_email_address       => 'PASSIA'
    ,x_user_name           => ''
    ,x_notification_api_id => n_not_id
    ,x_message_type        => 'TEXT_AND_QUERY'
    ,x_process_short_code  => 'DEMO-'
    ,x_message_subject     => 'ANIL TESTING ANOTHER ONE Customer Run Id 100329'
    ,x_message_text        => 'ANIL Customer Customers in AR on ' ||
    to_char(SYSDATE,'DD-Mon-RRRR HH24:MI'));

  xx_notifications_api_pkg.add_query(
     x_notification_api_id => n_not_id
    ,x_query_title_text    => 'List of TCA Customers Created During Last 24Hrs'
    ,x_from_clause         => 'hz_parties'
    ,x_where_clause        => 'creation_date > sysdate - 1'
    ,x_bind_values         => NULL
    ,x_column_title_1      => 'Party Number'
    ,x_column_name_1       => 'PARTY_NUMBER'
    ,x_column_title_2      => 'Creation Date'
    ,x_column_name_2       => 'CREATION_DATE'
    ,x_column_title_3      => 'Org System Ref'
    ,x_column_name_3       => 'orig_system_reference');

  xx_notifications_api_pkg.add_query(
     x_notification_api_id => n_not_id
    ,x_query_title_text    => 'Second List of TCA Parties in Last 48Hrs'
    ,x_from_clause         => 'hz_parties'
    ,x_where_clause        => 'creation_date > sysdate -2'
    ,x_bind_values         => NULL
    ,x_column_title_1      => 'Party Number'
    ,x_column_name_1       => 'PARTY_NUMBER'
    ,x_column_title_2      => 'Party Name'
    ,x_column_name_2       => 'PARTY_NAME'
    ,x_column_title_3      => 'Org System Ref'
    ,x_column_name_3       => 'orig_system_reference');
  dbms_output.put_line('n_not_id: ' || n_not_id);
COMMIT ;
END;
/

The serveroutput displays message below
n_not_id: 1000

PL/SQL procedure successfully completed.


STEP 2
R
UN BELOW THE BACKGROUND PROCESS AS BELOW
Ideally this will be scheduled to run every 15minutes or so on Production.
Hence notifications will be sent out every 15minutes by email/worklist


Step 3.
Item Key used by this wf api internally will use value in parameter x_process_short_code concatenated with Reference Number returned.
If you wish to send notification related to PO Number 1032, then pass parameter 
x_process_short_code=>'PO-Num-1032'

Issue:- If concurrent manager is not running then start this using command below
adcmctl.sh start apps appspassword




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 ...