HTMOMSE Sales Order Diagnostic Script [ID 133464.1]
 To Bottom |
 |
Applies to:
Oracle Order Management - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Main Content
| Translated versions: - Japanese: N/A - Chinese: N/A - Korean: Document 1524392.1 Refer to: - Multi-Lingual Support (MLS) in the current MOS Environment (Document 1480131.1) [This section is not visible to customers.] |
Purpose
The purpose of this script is to
collect information related to a sales order, its pricing adjustments,
shipment lines and workflow status.
There are two versions of this script:
click here to download HTMomse11i.sql in ZIP format
click here to download HTMomse12.sql in ZIP format
Usage
1. Run the script from SQL*Plus connected as APPS user as follows:
If your environment is R11i:
sqlplus apps/apps @HTMomse11i.sql
If your environment is R12:
sqlplus apps/apps @HTMomse12.sql
2. The output file will be located on the DB Server in the 'utl_file_dir' directory.
Parameters
|
Order Number |
Required |
|
Header_Id |
Required only if more than one HEADER_ID returned. If there is only one header_id returned after inputting the order number, simply hit enter and this header_id will be assumed. |
|
Line_Id |
Entering a line_id is only required when you wish to have output for one order line. Otherwise, hit enter without entering a line_id and all lines will be output in the script. |
|
Validation |
If 'Yes' then the script would generate a report of the sales order data, and also perform some basic analysis on the data and report on any errors found. If 'No' then the script would simply generate a report of the sales order data, and perform no analysis. The default is 'Yes'. |
|
Display Options |
The script allows you to choose whether or not to print some sections of the output. The OM and WSH sections are mandatory. WF, QP, PO, REC, WIP, INV and AR are optional. The default display option is 'Yes'. |
|
Output |
The output file will be located on the DB Server in the 'utl_file_dir' directory. (The script will display the output file name and location upon completion). |
Notes:
- This script is developed and maintained by Oracle Support Services. It has been tested internally and should work as documented.
- This script is being updated periodically. Please download it from My Oracle Support every time you need to run it in order to have the latest version.
- If you experience long execution times when running the script with the Validation parameter set to 'Y' please terminate and resubmit with this parameter set to 'N' and you should see some improvement in the performance.
Please note that Diagnostic script HTMomse can also to be installed as a Concurrent Process (Doc 1401831.1)
Related Documents
For additional diagnostic tools for the Order Management Product Suite, go to:
- MyOracleSupport Home Page
- See E-Business Suite Diagnostics 11i Test Catalog.
- See E-Business Suite Diagnostics R12 Test Catalog.
References
NOTE:1401831.1 - Diagnostic script HTMomse to be installed as a Concurrent Process
