Query Customer Service

This service is in the 1227 package and has the following fully-qualified service name: receivables1227.queryOA.customer:queryCustomer.

This service provides a list of the customers that match the query parameters.

You set up Customers in Oracle Applications Receivables to record customer-related information related to persons or organizations.

You can use the following parameters to query Customer data:

  • ACCOUNT_NUMBER: Unique identifier for a customer.
  • PARTY_NAME
  • ADDRESS1
  • ADDRESS2
  • ADDRESS3
  • ADDRESS4
  • CITY
  • COUNTY
  • STATE
  • COUNTRY
  • POSTAL_CODE
  • PROVINCE

Database Scripts

This service uses the same database scripts as the Send Customer service.

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

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

Supporting Transaction Definitions

This service uses the following transaction definition:

  • queryCustomerTxn1227.txp

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

Flow Control

The main flow executes as follows:

  • specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
  • queryCustomerTxn queries the Oracle Applications database for any Customer information matching the parameter values. The parameters are defined as the input to this service.

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

Business Document Structure

This service uses the same business document structure as the Send Customer service. For a detailed description of the business document structure, see Send Customer Service.