Overview

eApps Viewer let you to query Oracle e-Business Suite request details and open the output & log files by using an usefull interface.

Login:

With eApps Viewer, you have two options to login, these are; login with Oracle Application User or login with Apps Schema Password.

If GWYUID is provided for the Database you can login with apps user otherwise you can only login with apps schema password. If security id enabled in your Oracle Application instance, you need to provide server id to Login with apps user.

Database Properties:

Datase Properties form let you to define your Oracle e-Business databases.

  1. Alias for the connection
  2. DB URL: JDBC URL
    Oracle RAC Instance Thin Driver Example: (description=(address_list=(address=(host=HOST1)(protocol=tcp)(port=PORT1))(address=(host=HOST2)(protocol=tcp)(port=PORT2))(load_balance=yes)(failover=yes))(connect_data=(service_name=SID)))
    Oracle Single Host Instance Thin Driver Example: HOST:PORT:SID
  3. FNDNAM: Apps Schema Name
  4. You need GWYUID to login with eApps user
  5. If you use securty, you need to login with eApps User. You can select from FND_NODES table.
  6. FTP Server IP to get OUTPUT and LOG files
  7. FTP user to get OUTPUT and LOG files
  8. FTP password to get OUTPUT and LOG files
  9. OS Shell to open downloaded files

 Tip: You can get most of information from "About Oracle Applications" form "Database Server " section

eApps Viewer Main Form:

By using the eApps Viewer main form you can query Oracle e-Business Suite request details and open their output & log files for any Oracle e-Business Suite user.

  1. Oracle e-Business Suite Instance Name
  2. Begin - End request Id: Determinate the begin and end request id
  3. Begin - End request Date: Determinate the begin and end request date
  4. Concurrent Program Name: Select concurent program or request set name, field automatically complete the name when focus lost also you can use % to use LIKE condition
  5. Username: If you login with Application user which has System Administrator, Application Developer, Workflow Administrator or Alert Manager responsibility or Apps Schema password, you can select username otherwise your username will be displayed. Field automatically complete the username when focus lost also you can use % to use LIKE condition
  6. Concurrent Program Name Language: Select the concurrent program name language
  7. Request Phase: Select the request phase, for all phases select PHASE
  8. Request Status: Select the request status, for all status select STATUS
  9. Fetch Record Limit: Determine maximum row number
  10. Search Buttun: Do search
  11. Show Output: Open the selected request output file, if FTP and shell info are not provided, this button will be disabled
  12. Show Log: Open the selected request log file, if FTP and shell info are not provided, this button will be disabled
  13. Column Headers: Double clicking the column header to sort request list
  14. Data: Request list
  15. Cell Detail: Double clicking the cell to open the cell detail dialog
  16. Status Bar: Shows connected database, selected row count and fetch time
  1. File menu
  2. Clear Form: Clear the search criterions
  3. Clear Data: Clear the table data
  4. Copy Data to ClipBoard: Copy table headers & data to clipboard in compatible format with Excel format
  5. Connect: Change database connection
  6. Look and Feel: Select Metal or Windows look and feel
  7. Exit

  8. Help menu

    1. About: About form and Force garbage collector

 Tip: Text output and log files stored with .log extension and If you use "explorer" as open shell, explorer will open these files with Notepad. If you want to use WordPad to open these files, Change the LOGs' open with program as WordPad by using Explorer/Tools/Folder Options/File Types form
 

Version History:

0.9.54
  • Some bug fixes
0.9.53
  • Query performans improved on Status and Phase searches (query 100 times faster for some phase & status)
  • Phase column colored if status is Warning or Error
0.9.52
  • Showing wrong status for Inactive-No manager requests, problem is fixed
  • Status bar added (It shows Connectted Database, selected record count and fetch time)
  • Output and Log buttuns are get silent error if the selected rows' Log & out file fields are null, problem is fixed
0.9.51
  • Duration field shows wrong value for some terminated requests, problem is fixed
0.9.50
  • Some visual fixes for Java Environment 5.0
0.9.49
  • Duration field formatted as time
  • Requested Start Date, Process, SPID and AUDSID fields added
  • Showing wrong status for Pending-Normal requests problem is fixed
  • Clear Form and Clear Data menu item added
  • Copy Data to Clipboard menu item added
  • Sort problem on Parent column is fixed
  • Linux file path problem is fixed
0.9.48
  • Phase fields' query fixed
  • Status column is trimmed
  • Text fields' borders are changed in login form
  • After save the database properties selected database is setted as the saved database
0.9.47
  • Request lists' query fixed (Couldnt show scheduled status for some requests)
  • When opennig the LOG and OUTPUT program send the full path of to open shell program
  • Java runtime check added (if JRE version is not 1.4 or later version program warn the user and exit)
0.9.46
  • First beta release