Step 1. Download Instant Client
A. Instant Client Package - Basic:
(http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip)
All files required to run OCI, OCCI, and JDBC-OCI applications
B. Instant Client Package - SQL*Plus:
(http://download.oracle.com/otn/nt/instantclient/111070/instantclient-sqlplus-win32-11.1.0.7.0.zip )
Additional libraries and executable for running SQL*Plus with Instant Client
Unzip two file on same folder,like “sql_program”
Step 2. Find Alert’s ID and Applicanion’s ID
A. Use sysadmin account login Oracle ERP and change to “Alert manager” authority
B. open tool "HelpàDiagnosticsàExamine" to find Alert and Application ID
Step 3. Use FND_REQUEST to run alert and write to alert.sql
Step 4. Edit connect DB sql file,like “into.sql”
connect apps/******@1.2.3.4:1521/TEST
@C:\sql_program\alert.sql
/
exit
Step 5. Edit bat file,like “request.bat” set NLS_LANG= AMERICAN_AMERICA.ZHT16BIG5
Step 6. Run the bat file “request.bat” and check the result
call C:\sql_program\sqlplus /nolog @C:\sql_program\into.sql