Search Results ap_payment_templates




Overview
Explore in AI Chat

Overview

The AP_PAYMENT_TEMPLATES table is a core data object within the Oracle E-Business Suite Payables module (AP). It serves as the master repository for user-defined Payment Process Request Templates. These templates are critical for automating and standardizing the creation of payment batches. They allow payables administrators to predefine and save complex sets of parameters—such as payment method, bank account, payment currency, and selection criteria for invoices—for repeated use when submitting the Payables Payment Process. This functionality streamlines the payment cycle, ensures consistency, and reduces manual configuration errors.

Key Information Stored

The table stores the defining attributes of each saved template. Its primary key is the TEMPLATE_ID, a unique system-generated identifier. While the full column list is not detailed in the provided metadata, based on its purpose and foreign key relationships, the table typically stores the template's name (TEMPLATE_NAME), description, associated payment method, and the ID of the party (supplier or internal organization) for whom the template is defined via the PARTY_ID column. The foreign key to HZ_PARTIES confirms this link to the Trading Community Architecture. The table also likely contains control columns such as CREATION_DATE, CREATED_BY, and LAST_UPDATE_DATE to track template maintenance.

Common Use Cases and Queries

The primary use case is the execution of the Payment Process request form, where users select a saved template to populate the request parameters instantly. From a reporting and administration perspective, common queries involve listing all available templates or auditing template usage. A basic query to retrieve template details would be:

  • SELECT template_id, template_name, description, party_id, creation_date FROM ap_payment_templates WHERE enabled_flag = 'Y' ORDER BY template_name;

Technical consultants may query this table to troubleshoot template-related issues or to validate data integrity by checking for templates referencing invalid parties (via the HZ_PARTIES foreign key). The table is also central when migrating or cloning custom payment process configurations between instances.

Related Objects

As indicated by the foreign key metadata, AP_PAYMENT_TEMPLATES has a hierarchical relationship with several key grouping tables that store the detailed criteria defined within a template. These include:

  • AP_CURRENCY_GROUP: Stores the payment currency rules linked to a TEMPLATE_ID.
  • AP_LE_GROUP: Stores the legal entity selection criteria for the template.
  • AP_OU_GROUP: Stores the operating unit selection criteria.
  • AP_PAY_GROUP: Stores the pay group criteria for payment selection.

The table is also directly linked to the HZ_PARTIES table to identify the supplier or organization associated with the template. The Payment Process concurrent program and its underlying APIs reference this table and its dependent groups to construct the payment batch according to the saved parameters.

  • Table: AP_PAYMENT_TEMPLATES 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PAYMENT_TEMPLATES,  object_name:AP_PAYMENT_TEMPLATES,  status:VALID,  product: AP - Payables ,  description: User Defined Payment Process Request Templates ,  implementation_dba_data: AP.AP_PAYMENT_TEMPLATES , 

  • Table: AP_PAYMENT_TEMPLATES 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PAYMENT_TEMPLATES,  object_name:AP_PAYMENT_TEMPLATES,  status:VALID,  product: AP - Payables ,  description: User Defined Payment Process Request Templates ,  implementation_dba_data: AP.AP_PAYMENT_TEMPLATES , 

  • Table: AP_PAY_GROUP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PAY_GROUP,  object_name:AP_PAY_GROUP,  status:VALID,  product: AP - Payables ,  description: Pay groups for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_PAY_GROUP , 

  • Table: AP_CURRENCY_GROUP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CURRENCY_GROUP,  object_name:AP_CURRENCY_GROUP,  status:VALID,  product: AP - Payables ,  description: Payment currencies for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_CURRENCY_GROUP , 

  • Table: AP_OU_GROUP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_OU_GROUP,  object_name:AP_OU_GROUP,  status:VALID,  product: AP - Payables ,  description: Operating units for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_OU_GROUP , 

  • Table: AP_PAY_GROUP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PAY_GROUP,  object_name:AP_PAY_GROUP,  status:VALID,  product: AP - Payables ,  description: Pay groups for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_PAY_GROUP , 

  • Table: AP_OU_GROUP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_OU_GROUP,  object_name:AP_OU_GROUP,  status:VALID,  product: AP - Payables ,  description: Operating units for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_OU_GROUP , 

  • Table: AP_LE_GROUP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_LE_GROUP,  object_name:AP_LE_GROUP,  status:VALID,  product: AP - Payables ,  description: Legal entities for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_LE_GROUP , 

  • Table: AP_LE_GROUP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_LE_GROUP,  object_name:AP_LE_GROUP,  status:VALID,  product: AP - Payables ,  description: Legal entities for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_LE_GROUP , 

  • Table: AP_CURRENCY_GROUP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CURRENCY_GROUP,  object_name:AP_CURRENCY_GROUP,  status:VALID,  product: AP - Payables ,  description: Payment currencies for the Payment Process Request Template or the Payment Process Request. ,  implementation_dba_data: AP.AP_CURRENCY_GROUP ,