Query Purchase Order Service

Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Procurement Predefined Transaction Services | Query Purchase Order Service

This service is in the WmOAPRC1227 package and has the following fully-qualified service name: purchasing1227.queryOA.PO:queryPO.

This service retrieves PO data. The following parameters are used for querying PO data:

AGENT_NAME

DOCUMENT_NUM

SHIP_TO_ADDRESS_LINE_1, SHIP_TO_ADDRESS_LINE_2, SHIP_TO_ADDRESS_LINE_3

SHIP_TO_TOWN_OR_CITY.

SHIP_TO_REGION_1, SHIP_TO_REGION_2, SHIP_TO_REGION_3

SHIP_TO_COUNTRY

SHIP_TO_POSTAL_CODE

BILL_TO_ADDRESS_LINE_1, BILL_TO_ADDRESS_LINE_2, BILL_TO_ADDRESS_LINE_3

BILL_TO_TOWN_OR_CITY

BILL_TO_REGION_1, BILL_TO_REGION_2, BILL_TO_REGION_3

BILL_TO_COUNTRY

BILL_TO_POSTAL_CODE

ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3

CITY

STATE

ZIP

COUNTRY

VENDOR_NAME

ORGANIZATION_NAME

Database Scripts

This service uses the same database scripts as the Send Purchase Order service.

Note:
If you use this service but you do not use the Send Purchase Order service, you should run the wm_disable_from_po.sql script to disable the triggers installed by the Send Purchase Order service.

For a detailed description of these database scripts, see Send Purchase Order Service. For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service uses the following transaction definition:

queryPOTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

The main flow queryPO executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

queryPOTxn queries the Oracle Applications database for any purchase order information matching the parameter values. The parameters are defined as the input to this service.

For more details on query transactions, see Using Query Services.

Business Document Structure

This service uses the same business document structure as the Send Purchase Order service. For a detailed description of the business document’s structure, see Send Purchase Order Service.