OM-HTMOMSE Sales Order Diagnostic Script (文档 ID 133464.1)

HTMOMSE Sales Order Diagnostic Script (文档 ID 133464.1)

转到底部

---

APPLIES TO: Oracle Order Management - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Inventory Management - Version 11.5.10.2 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Shipping Execution - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Release Management - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Advanced Pricing - Version 11.5.10 to 12.2.6 [Release 11.5 to 12.2] Information in this document applies to any platform. MAIN CONTENT Purpose The purpose of this script is to collect information related to a Sales Order, its Pricing Adjustments, Shipment lines, Workflow status, Inventory transactions and Receivables transactions. A new version has been created that is non Release dependent, please use this version for both releases 11.5 and 12: click here to download HTMomse.sql in ZIP format  -- Last update 31-Oct-2016   Usage 1. Run the script from SQL*Plus connected as APPS user as follows:      sqlplus apps/<password_for_apps> @HTMomse.sql     Then follow the prompts on the screen.     Most entries has default value 'Yes' (when left blank). 2. The script shows the Server Name, file name and location of the output file. 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 Note 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. For a Whitepaper on how to read the output of the HTMOMSE script, please refer to document Understanding the HTMomse12 Output for Order Management Note 1427369.1   Old Versions These old versions will remain in this Note for consistency (references from other Notes) but will not be maintained, it is recommended to use the new version. click here to download HTMomse11i.sql in ZIP format  -- Last update 11-Jun-2016 click here to download HTMomse12.sql in ZIP format  -- Last update 24-Mar-2016   Still have questions? To discuss this script and its' output further with Oracle experts and industry peers, we encourage you to review, join the HTMOMSE Sales Order Diagnostic Script Note 133464.1 - Feedback and General questionsdiscussion. REFERENCES NOTE:1427369.1 - Understanding the HTMomse12 Output for Order Management NOTE:1401831.1 - Diagnostic script HTMomse to be installed as a Concurrent Process

HTMOMSE Sales Order Diagnostic Script (文档 ID 133464.1)

转到底部

---

APPLIES TO: Oracle Order Management - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Inventory Management - Version 11.5.10.2 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Shipping Execution - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Release Management - Version 11.5.10.0 to 12.2.6 [Release 11.5.10 to 12.2] Oracle Advanced Pricing - Version 11.5.10 to 12.2.6 [Release 11.5 to 12.2] Information in this document applies to any platform. MAIN CONTENT Purpose The purpose of this script is to collect information related to a Sales Order, its Pricing Adjustments, Shipment lines, Workflow status, Inventory transactions and Receivables transactions. A new version has been created that is non Release dependent, please use this version for both releases 11.5 and 12: click here to download HTMomse.sql in ZIP format  -- Last update 31-Oct-2016   Usage 1. Run the script from SQL*Plus connected as APPS user as follows:      sqlplus apps/<password_for_apps> @HTMomse.sql     Then follow the prompts on the screen.     Most entries has default value 'Yes' (when left blank). 2. The script shows the Server Name, file name and location of the output file. 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 Note 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. For a Whitepaper on how to read the output of the HTMOMSE script, please refer to document Understanding the HTMomse12 Output for Order Management Note 1427369.1   Old Versions These old versions will remain in this Note for consistency (references from other Notes) but will not be maintained, it is recommended to use the new version. click here to download HTMomse11i.sql in ZIP format  -- Last update 11-Jun-2016 click here to download HTMomse12.sql in ZIP format  -- Last update 24-Mar-2016   Still have questions? To discuss this script and its' output further with Oracle experts and industry peers, we encourage you to review, join the HTMOMSE Sales Order Diagnostic Script Note 133464.1 - Feedback and General questionsdiscussion. REFERENCES NOTE:1427369.1 - Understanding the HTMomse12 Output for Order Management NOTE:1401831.1 - Diagnostic script HTMomse to be installed as a Concurrent Process