The following test can be used proactivly to check the setup/objects/data.. related to the issue you are suffering. The information collected in this test is vital in the reactive resolution of the issues.
Error and warning messages, followed by suggested actions,identify possible problem areas.
To execute the test, follow up the instructions given in its associated note.
1- R12 Diagnostics Released
Note 464866.1: E-Business Suite Diagnostics Test Catalog for
Data Collectors
- Note:463564.1 Encumbrance Activity Test
- Note:463566.1 Purchase Order/Release Number Activity Test
- Note:463570.1 Requisition Data Collection Test
- Note:463572.1 PO Approval Data Collection Test
Open Interface Checks
- Note:463565.1 Requisition Import Activity Diagnostic Test
- Note:463568.1 Purchasing Documents Open Interface Activity Test
Purchase Order Checks
- Note:463567.1 Dropship Order Activity Diagnostic Test
- Note:463573.1 Account Generator Activity Diagnostic Test
Requisition Checks
- Note:463561.1 Requisition Creation Activity Diagnostic Test
- Note:463562.1 Account Generator Activity Diagnostic Test
- Note:463571.1 Requisition Change Order Test
- Note:463569.1 Requisition AutoCreate Activity Test
- Note:463563.1 Internal Requisition Activity Test
Setup Checks
- Note:463556.1 Employee Setup Diagnostic Test
- Note:463557.1 User Approval Setup Test
- Note:463558.1 Accruals Setup Test
- Note:463559.1 Purchasing Setup Test
- Note:463560.1 User Notification Activity Diagnostic Test
2. 11i Diagnostics Released
2. 11i Diagnostics Released
- Note: 204502.1 Purchasing (PO) Check Setup (POCheckSetup115.sql) . This script checks whether the necessary setups are done for Oracle Purchasing. It prompts the user to perform the setups if any are missing or incorrect.
- Note: 200567.1 Oracle Purchasing Automatic Standard PO or Blanket Release Creation Diagnostic Script (supp_po_6_24_19.sql). The purpose of this diagnostic script is to validate the setup which is required to automatically create Blanket Releases or Standard POs upon requisition approval .
- Note: 224590.1 : Purchasing (PO) Check Employee Setup (POEmployeeCheckSetup115.sql)
This diagnostic test will check the setup of an employee attached to a username.
- Note 205325.1 : Oracle Purchasing User Approval Setup Diagnostic Script
For Version 11.5 (POUserApprovalCheckSetup115.sql) Note 205325.1
For Version 11.0 (supp_po_6_24_2a_110.sql) Note 167457.1
The purpose of this script is to verify that a User is setup for approving Oracle Purchasing documents for a given Operating Unit.
- Note: 224341.1 : Purchasing (PO) Internal Requisition Verification (POInternalReqCheck115.sql)
The purpose of this diagnostic script is to verify the data associated with an Internal Requisition and that it is properly setup to be created into an Internal Sales Order.
- Note: 205446.1: Purchasing (PO) Purchase Order/Release Check Setup (POTransactions115.sql)
This test collects all the relevant information for given Purchase Order (Standard, Blanket, Planned, Contract)/Release (Blanket & Scheduled) Number. This information can be used for diagnosis and resolution of Purchase Order related issues.
- Note:224391.1 : Oracle Purchasing Dropship Order Activity Test. This test can be used procatively and reactively to prevent or solve issues related to the dropship process.
- Note:221938.1 : Oracle Purchasing Requisition Import Activity Test. This test can be used in a proactive or reactive manner to validate data during the requisition import process
- Note: 224391.1 : Purchasing (PO) Dropshipment Data Verification (PODropshipCheck115.sql) This test will display data related to a Dropship Order at various stages of the Dropship process. Each section is a step in the Dropship process starting from Order Management when the Sales Order is entered and ending when the Purchase Order is received in Oracle Purchasing.
- Note: 228994.1 : Purchasing (PO) Return Material Authorization (RMA) Data Collection and Troubleshooting (PORMACheck115.sql)
This diagnostic test will check required columns and statuses that will affect the Receipt Transactions of a RMA as well as display RMA header, lines and related setup that will be spooled to a HTML file.
- Note: 207297.1 : Purchasing (PO) AutoCreate (POAutoCreate115.sql)
The Purpose of this script is to check AutoCreate Eligibility of a Requisition. This diagnostic test will help diagnose problems related to Autocreate. The test will verify whether the requisition selected for autocreate is eligible for autocreate or not. If the requisition is not eligible, the test displays the reasons and the actions to be taken by the user
- Note: 216086.1 : Purchasing (PO) Account Generator Diagnostic Test (POAccountGenerator115.sql )
The test helps to diagnose the issues related PO Account Generator for non-OPM installations. This test is meant for items of type destination type expense and inventory and not shop floor
- Note: 251052.1 : Purchasing (PO) Accruals Activity Diagnostic Test
This diagnostic test will collect setup information and transactional data related to Accruals and Accounting Reports. Validation will be performed to identify common problems and known bugs, and users will be directed to information on how to resolve these issues. Error and warning messages, followed by suggested actions, will identify missing or invalid data.
- Note: 292283.1 : Purchasing (PO) Encumbrance Data Activity Diagnostic Test
This diagnostic test will obtain the document specific information used in the troubleshooting of Encumbrance related issues. Specific Encumbrance data and useful requisition data related to an entered Purchase Order number is displayed. In the same way Purchase Order information related to an entered requisition is displayed.
- Note: 200565.1 : Verify RFQ / Quotation Diagnostic Script (supp_po_6_24_11.sql)
The purpose of this diagnostic script is to validate the data associated and needed to process a RFQ / Quotation successfully regardless of the approval status.
- Note: 217378.1 : Purchasing (PO) Receiving Document Check Setup (POReceivingCheck115.sql)
The Document Receiving Diagnostic test is a PL/SQL test that will check the receiving status of a purchasing document (standard PO or a blanket) and spool information about the PO document header, line, shipment, distribution and the receiving information for each shipment to an HTML file.
- Note: 221938.1 : Purchasing (PO) Requisition Import (POReqImport115.sql)
This test helps to diagnose the issues related PO Requisition Import.
- Note: 224887.1 : Purchasing (PO) Documents Open Interface (POPdoiCheck115.sql)
This test will verify the data in the interface tables used by Purchasing Documents Open Interface (PDOI). Each required, conditionally required and all other key fields in the PO interface tables, for a given interface_header_id, will be validated.
- Note: 227665.1 : Purchasing (PO) Requisition Creation Check Setup (POReqCreate115.sql)
This diagnostic test is to ensure a PO Requisition is valid and that all required column values have been entered regardless of the requisition status. The result will spool into an HTML file. The output can be viewed in a web browser and it can be forwarded to support to assist in resolving PO issues.
- Note:224341.1 : Oracle Purchasing Internal Requisition Activity Test. This diagnostic test verifies the data associated with an internal requisition and that it is properly setup to be created into an internal sales order.This test can be used reactivly to help resolve issues related to internal requisitions.
- Note: 207342.1 : Oracle Purchasing (PO) Check Document Approval Status Test
For Version 11.5 (PODocumentApprovalStatus115.sql) Note: 207342.1
For Version 11.0 (supp_po_6_24_2b_110.sql) Note: 172283.1
The PO Document Approval Status test is a PL/SQL test that will check the approval workflow status of a purchasing document and spool information about the workflow status to an HTML file.
- Note: 217896.1 : Purchasing(PO) Check User Notification Setup (POUserNotificationCheckSetup115.sql)
The PO User Notification Check Setup diagnostic test is a PL/SQL test that will check the notification related setup specific to a user and spool information to a HTML file.
- Note: 167459.1 : Oracle Purchasing ASL/Sourcing to Requisition Diagnostic Script (supp_po_6_24_4_110.sql and supp_po_6_24_4_115.sql)
The purpose of this diagnostic script is to validate the data which is required to automatically source Item, Supplier, and Source Document details from a Blanket PO or Quotation onto a Requisition. This script does not support sourcing functionality from Commodity based Approved Supplier Lists. This script is available for 11.0 and 11.5.
- Note: 225026.1 : Purchasing (PO) Receiving Open Interface Diagnostic Test (POROIFlow115.sql)
This diagnostic test will help to diagnose the issues related to the Receiving Open Interface. Within the Receiving Open Interface, receipt data is validated for compatibility with Purchasing. The following two Receiving Open Interface tables are validated: RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE.
iProcurement Product Testing
- Note: 200509.1 : iProcurement (POR) Check Setup (CheckSetup115.sh)
This script tests some of the basic configurations that must be performed in order to be able to log into iProcurement. It checks for key Profile options that need to be set and Apache web server options in the configuration files. The script will list ERRORS and WARNINGS in a Problem/Resolution Format, offering Step by Step Solutions to correct.
- Note: 226575.1 : iProcurement(POR) Requisition Create Setup(PORReqCreateCheckSetup115.sql)
This diagnostic test will collect Requisition Create related application setup information in iProcurement. Error and warning messages, followed by suggested actions, will identify missing or invalid data.
- Note: 227386.1 : iProcurement(POR) Troubleshoot Requisition Creation (PORReqCreateTroubleshoot115.sql)
This diagnostic test will collect and troubleshoot data for the entered Requisition number and spool the result into an HTML file.
- Note: 224583.1 : iProcurement (POR) Check Requisition Approval Status (PORReqApprovalStatus115.sql )
This test will check the approval workflow status of a requisition created in iProcurement and spool information about the workflow status to an HTML file.
- Note: 202222.1 : iProcurement (POR) External Bulkloader Check Setup (PORCheckBulkloaderSetup115.sh)
This diagnostic tests the profile options and configuration files that need to be set up in order for the external bulkloader to start and run. A connection test and a jdbc connection test is also executed. The categories and base descriptors must be also be setup in order to load catalog data.
Data Gathering / File Version/ Apps Check
Data Gathering / File Version/ Apps Check
submit the concurrent program. 'Diagnostics: Apps Check' using a Purchasing responsibility:
- Navigation: Reports/Run
- Submit a Single Request
- Name: Diagnostics: Apps Check
- Parameters: Application 1: Oracle Purchasing
- Submit the request and you may upload output to the support once requested
This is a standard report that should be available using the Purchasing Super User responsibility. If it does not appear in your list of standard reports, please have your System Administrator add it to your request group.
The purpose of this concurrent program and script is to provide the versions of all files related to Oracle Purchasing on a given instance. The output is now required when working issues occurring in Oracle Purchasing. This is available for 11.0 and 11.5. Please see Note: 186123.1 for details.
.