Oracle E-Business Suite Sanity Check

 Oracle E-Business Suite Sanity Check

E-business suite R12 -

Sanity checks are always required whenever we take system down for maintenance .

validations are always highly recommended whenever we install or upgrade e-business suite environment.

Validation Sanity tests for E-business suite 

a) Basic Technology Stack Health Testing   

Check LocalLogin using: /OA_HTML/AppsLogin

Login via Forms Direct Login: /forms/frmservlet?

Check for any errors or exceptions, if any, in Java Console as well as during Forms launch

b) Multiple Forms Launching In Single Forms Session

After logon (SYSADMIN/sysadmin) to Apps, 

click 

->System Administrator

 -> Security: User

> Define. 

Now from the html navigator, 

open the Application

-> Currency form.

The new form should open in the existing forms session (i.e., the earlier form as well as new form should co-exist).

c) AOL/J Test  

Logon

  http://<hostname:port>/OA_HTML/jsp/fnd/aoljtest.jsp

 with DB connection details.

All the tests should pass without errors/exceptions.

d) Concurrent Request (CR)

Logon (SYSADMIN/sysadmin) to EBS. 

Choose 

System Administrator 

-> Requests

> Run

-> Single Request. 

Select the concurrent request 'Active User' and click on  Submit button. 

e) Reports Regression Test

Logon (SYSADMIN/sysadmin) to EBS. Choose 

System Administrator 

-> Requests

-> Run

-> Single Request. 

From the Name LOV, 

choose 'CP Text Report Regression Test' (with parameters Run Mode ::'FULL', Duration:: 0) and click on Submit.

 Ensure that this CR completes successfully.

f) Java Regression Test   

Logon (SYSADMIN/sysadmin) to EBS. 

Choose System Administrator

 -> Requests

-> Run

-> Single Request. 

From the Name LOV, choose 'CP Java Regression Test' (Set parameters as 'Basic') 

and click on Submit. 

Ensure that this CR completes successfully.

g) PLSQL Regression Test

Logon (SYSADMIN/sysadmin) to EBS.

 Choose

 System Administrator 

-> Requests

-> Run

-> Single Request. 

From the Name LOV, choose 'CP PLSQL Regression Test' (Set parameters as 'Basic') and click on Submit.

 Ensure that this CR completes successfully.

h) Perl Regression Test

Logon (SYSADMIN/sysadmin) to EBS. 

Choose System Administrator 

-> Requests

-> Run

-> Single Request. 

From the Name LOV,

choose 'CP Perl Regression Test' (Set Parameters as 'Basic') 

and click on Submit. 

Ensure that this CR completes successfully.

i) OAM functionality

Logon (SYSADMIN/sysadmin) to EBS.

 Choose System Administration

-> Oracle Applications Manager 

--> System Configuration

 Overview. 

System Configuration 

Overview should display current system config values; all processes should be up and running.

 Check init.ora settings.

j) Diagnostics

Logon (SYSADMIN/sysadmin) to EBS. 

Choose System Administration

-> Diagnostics.

Check AOL/J Diagnostics, 

JSP Ping, 

JSP Class Version Information, 

Servlet Ping, 

AOL/J Database Connection Pool Status, 

TCF Status.

k) iHelp Test  

Logon (SYSADMIN/sysadmin) to EBS.

 Choose System Administrator, 

Select Help link On Search Entry, type FNDFS and click Find.

 Verify that it shows the list of search hits for FNDFS.

l). License Manager   

Logon (SYSADMIN/sysadmin) to EBS.

 Bring up license manager and try to license/de-license products.

m) TCF Server test

Logon (SYSADMIN/sysadmin) to EBS.

 Choose System Administrator

-> Application

-> Menu. 

Query the menu item AK_NAVIGATE (Press F10 for editable mode), 

Click on View Tree button. Menu Viewer screen should appear with the details.

n) FNDFS (Text and Web)

Logon (SYSADMIN/sysadmin) to EBS. 

Choose 

System Administrator

 -> Profile

 -> System. Set profile option 'Viewer: Text' to <blank> (text format). 

View the log or output of any concurrent request and it should be opened by forms default viewer. 

Set profile option 'Viewer: Text' to 'browser' (web format). 

View the log or output of any concurrent request and it should be opened by web browser window.

o) Printing

Check the printing from Applications. Print the output of a Concurrent Request.