An instance validation is highly recommended whenever we install or upgrade Oracle E-Business Suite (EBS) or clone an Oracle Application system to test or even while applying AD, Techstack (TXK) and family packs. The sanity checks are valid whenever we take the system down for maintenance or perform a disaster recovery. Following are some of the validation tests for an Oracle EBS R12.x and above that I perform.
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
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).
3. 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.
Logon http://<hostname:port>/OA_HTML/jsp/fnd/aoljtest.jsp with DB connection details.
All the tests should pass without errors/exceptions.
4.Concurrent Request (CR)
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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.
11. 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.
12. License Manager
Logon (SYSADMIN/sysadmin) to EBS. Bring up license manager and try to license/de-license products.
13. 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.
14. 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.
15. Printing
Check the printing from Applications. Print the output of a Concurrent Request.
The tests are all optional.
Logon (SYSADMIN/sysadmin) to EBS. Choose System Administrator -> Requests-> Run-> Single Request. Select the concurrent request 'Active User' and hit Submit. This should not throw any errors or exceptions in any phase. View Output should generate report without any errors. There should not be any errors in the report log file.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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.
11. 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.
12. License Manager
Logon (SYSADMIN/sysadmin) to EBS. Bring up license manager and try to license/de-license products.
13. 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.
14. FNDFS (Text and Web)
Logon (SYSADMIN/sysadmin) to EBS. Choose System Administrator -> Profile -> System. Set profile option 'Viewer: Text' to
15. Printing
Check the printing from Applications. Print the output of a Concurrent Request.
The tests are all optional.
No comments:
Post a Comment