Search Results rent related terms




The AP_TERMS_LINES table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Payables module, specifically designed to store detailed payment term line information. Payment terms define the conditions under which suppliers are paid, including due dates, discounts, and installment schedules. This table works in conjunction with the AP_TERMS table, which stores the header-level payment term definitions.

Table Structure and Key Columns

The AP_TERMS_LINES table contains the following key columns:
  • TERM_ID: Foreign key linking to the AP_TERMS table, identifying the parent payment term.
  • SEQUENCE_NUM: Determines the order of payment term lines for installment-based terms.
  • DUE_DAYS: Specifies the number of days from the invoice date or receipt date when payment is due.
  • DISCOUNT_DAYS: Defines the number of days within which a discount can be availed.
  • DISCOUNT_PERCENT: The percentage of discount applicable if payment is made within the discount period.
  • DUE_DAY_OF_MONTH: Used for fixed-date payment terms, indicating the specific day of the month when payment is due.
  • DUE_MONTHS_AHEAD: Specifies the number of months ahead for payment due dates in fixed-date terms.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Functional Role in Oracle EBS

The AP_TERMS_LINES table supports the following functionalities:
  1. Installment Payments: Enables multi-installment payment terms where each line represents a separate due date and discount option.
  2. Discount Management: Stores early payment discount terms, allowing suppliers to offer incentives for timely payments.
  3. Fixed Date Terms: Supports payment terms with specific due dates (e.g., "Net 15th of next month").
  4. Dynamic Due Date Calculation: The Payables engine uses this data to compute invoice due dates during invoice validation.

Integration with Other Modules

Payment term data from AP_TERMS_LINES is referenced by:
  • AP_INVOICES: Links invoices to payment terms.
  • AP_PAYMENT_SCHEDULES: Stores calculated payment schedules derived from term lines.
  • AR_PAYMENT_TERMS: Shared payment terms in Receivables (when using common terms).

Technical Considerations

For implementations and customizations:
  • The table is maintained through the "Payment Terms" form (Navigation: Payables > Setup > Payment > Terms).
  • Custom reports querying this table should join with AP_TERMS for complete term information.
  • Oracle workflows may reference term lines during invoice approval processes.
  • In 12.2.2, the table structure remains compatible with 12.1.1, but new features like Advanced Global Intercompany System (AGIS) may introduce additional validation.

Data Security

Access to AP_TERMS_LINES is controlled through:
  • Oracle Function Security for the Payment Terms form.
  • Database privileges (typically restricted to APPS schema in production).
  • VPD (Virtual Private Database) policies in multi-org environments.
This table's proper configuration is essential for accurate accounts payable processing, cash flow management, and supplier relationship management in Oracle EBS implementations.

  • Lookup Type: TERMS DATE BASIS 12.1.1

    product: AP - Payables ,  meaning: Terms Date Basis ,  description: Payment schedule terms date basis options , 

  • Lookup Type: TERMS DATE BASIS 12.2.2

    product: AP - Payables ,  meaning: Terms Date Basis ,  description: Payment schedule terms date basis options , 

  • Lookup Type: REJECT CODE 12.2.2

    product: AP - Payables ,  meaning: Reject Code ,  description: Reject Codes for AP Open Interface , 

  • Lookup Type: REJECT CODE 12.1.1

    product: AP - Payables ,  meaning: Reject Code ,  description: Reject Codes for AP Open Interface , 

  • Concurrent Program: APXPTPTR 12.1.1

    execution_filename: APXPTPTR ,  product: AP - Payables ,  user_name: APXPTPTR ,  description: Payment Terms Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: APXPTPTR 12.2.2

    execution_filename: APXPTPTR ,  product: AP - Payables ,  user_name: APXPTPTR ,  description: Payment Terms Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: MODULE 12.1.1

    product: AP - Payables ,  meaning: Module ,  description: Module , 

  • Lookup Type: MODULE 12.2.2

    product: AP - Payables ,  meaning: Module ,  description: Module , 

  • Concurrent Program: APXPTPTR_XML 12.2.2

    product: AP - Payables ,  user_name: Payment Terms Listing (XML) - Not Supported: Reserved For Future Use ,  description: Payment Terms Listing ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • View: AP_TERMS_BAT_PAY_TERMS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_TERMS_BAT_PAY_TERMS_V,  object_name:AP_TERMS_BAT_PAY_TERMS_V,  status:VALID,  product: AP - Payables ,  description: (Release 10SC Only) ,  implementation_dba_data: APPS.AP_TERMS_BAT_PAY_TERMS_V , 

  • Concurrent Program: APXPTPTR_XML 12.1.1

    product: AP - Payables ,  user_name: Payment Terms Listing (XML) - Not Supported: Reserved For Future Use ,  description: Payment Terms Listing ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • View: AP_TERMS_BAT_PAY_TERMS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_TERMS_BAT_PAY_TERMS_V,  object_name:AP_TERMS_BAT_PAY_TERMS_V,  status:VALID,  product: AP - Payables ,  description: (Release 10SC Only) ,  implementation_dba_data: APPS.AP_TERMS_BAT_PAY_TERMS_V , 

  • Lookup Type: INVOICE IMPORT REJECTION 12.1.1

    product: AP - Payables ,  meaning: Invoice Import Rejection ,  description: Reason for the rejection of an imported invoice , 

  • Lookup Type: INVOICE IMPORT REJECTION 12.2.2

    product: AP - Payables ,  meaning: Invoice Import Rejection ,  description: Reason for the rejection of an imported invoice , 

  • Table: AP_TERMS_LINES 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_TERMS_LINES,  object_name:AP_TERMS_LINES,  status:VALID,  product: AP - Payables ,  description: Detail information about payment terms ,  implementation_dba_data: AP.AP_TERMS_LINES , 

  • Table: AP_TERMS_LINES 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_TERMS_LINES,  object_name:AP_TERMS_LINES,  status:VALID,  product: AP - Payables ,  description: Detail information about payment terms ,  implementation_dba_data: AP.AP_TERMS_LINES , 

  • Table: AP_OTHER_PERIODS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_OTHER_PERIODS,  object_name:AP_OTHER_PERIODS,  status:VALID,  product: AP - Payables ,  description: Recurring invoice, key indicator, payment terms, and withholding tax time period definitions ,  implementation_dba_data: AP.AP_OTHER_PERIODS , 

  • Table: AP_OTHER_PERIODS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_OTHER_PERIODS,  object_name:AP_OTHER_PERIODS,  status:VALID,  product: AP - Payables ,  description: Recurring invoice, key indicator, payment terms, and withholding tax time period definitions ,  implementation_dba_data: AP.AP_OTHER_PERIODS , 

  • Table: AP_PRODUCT_SETUP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PRODUCT_SETUP,  object_name:AP_PRODUCT_SETUP,  status:VALID,  product: AP - Payables ,  description: AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units. This table contains information such as your default payment terms and payment method. Your Orac ,  implementation_dba_data: AP.AP_PRODUCT_SETUP , 

  • Table: AP_PRODUCT_SETUP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PRODUCT_SETUP,  object_name:AP_PRODUCT_SETUP,  status:VALID,  product: AP - Payables ,  description: AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units. This table contains information such as your default payment terms and payment method. Your Orac ,  implementation_dba_data: AP.AP_PRODUCT_SETUP , 

  • Lookup Type: INVOICE MORE 12.1.1

    product: AP - Payables ,  meaning: Invoice More ,  description: More options for invoice zone of invoice entry , 

  • Lookup Type: INVOICE MORE 12.2.2

    product: AP - Payables ,  meaning: Invoice More ,  description: More options for invoice zone of invoice entry , 

  • Table: AP_WEB_VAT_SETUP_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_WEB_VAT_SETUP_ALL,  object_name:AP_WEB_VAT_SETUP_ALL,  status:VALID,  product: AP - Payables ,  description: This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant fields on the Expense Line Details page. ,  implementation_dba_data: AP.AP_WEB_VAT_SETUP_ALL , 

  • Table: AP_WEB_VAT_SETUP_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_WEB_VAT_SETUP_ALL,  object_name:AP_WEB_VAT_SETUP_ALL,  status:VALID,  product: AP - Payables ,  description: This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant fields on the Expense Line Details page. ,  implementation_dba_data: AP.AP_WEB_VAT_SETUP_ALL , 

  • Concurrent Program: APXCCUPG 12.2.2

    execution_filename: AP_WEB_CC_UPGRADE_PKG.Upgrade_Cards ,  product: AP - Payables ,  user_name: Upgrade Credit Card Details ,  description: Upgrade Expenses related credit card data to Payments central repository. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: APXCCUPGMGR 12.2.2

    execution_filename: AP_WEB_CC_UPGRADE_PKG.Upgrade_Cards_Manager ,  product: AP - Payables ,  user_name: Upgrade Credit Card Details Manager ,  description: Manager to upgrade Expenses related credit card data to Payments central repository. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • View: AP_RECURRING_PAYMENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_RECURRING_PAYMENTS_V,  object_name:AP_RECURRING_PAYMENTS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_RECURRING_PAYMENTS_V , 

  • View: AP_RECURRING_PAYMENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_RECURRING_PAYMENTS_V,  object_name:AP_RECURRING_PAYMENTS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_RECURRING_PAYMENTS_V , 

  • View: PO_VENDOR_SITES_PAY_AP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.PO_VENDOR_SITES_PAY_AP_V,  object_name:PO_VENDOR_SITES_PAY_AP_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.PO_VENDOR_SITES_PAY_AP_V , 

  • View: PO_VENDOR_SITES_PAY_AP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.PO_VENDOR_SITES_PAY_AP_V,  object_name:PO_VENDOR_SITES_PAY_AP_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.PO_VENDOR_SITES_PAY_AP_V , 

  • Table: AP_PREPAY_HISTORY_ALL 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PREPAY_HISTORY_ALL,  object_name:AP_PREPAY_HISTORY_ALL,  status:VALID,  product: AP - Payables ,  description: AP_PREPAY_HISTORY_ALL countains the history of a prepayment which includes its related prepayment applications, prepayment unapplications and prepayment application adjustments. A row is created in APPH when the Prepayment Applied, Prepay ,  implementation_dba_data: AP.AP_PREPAY_HISTORY_ALL , 

  • Table: AP_PREPAY_HISTORY_ALL 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_PREPAY_HISTORY_ALL,  object_name:AP_PREPAY_HISTORY_ALL,  status:VALID,  product: AP - Payables ,  description: AP_PREPAY_HISTORY_ALL countains the history of a prepayment which includes its related prepayment applications, prepayment unapplications and prepayment application adjustments. A row is created in APPH when the Prepayment Applied, Prepay ,  implementation_dba_data: AP.AP_PREPAY_HISTORY_ALL , 

  • View: AP_VENDOR_SITES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_VENDOR_SITES_V,  object_name:AP_VENDOR_SITES_V,  status:VALID,  product: AP - Payables ,  description: (Release 10SC Only) ,  implementation_dba_data: APPS.AP_VENDOR_SITES_V , 

  • View: AP_VENDOR_SITES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_VENDOR_SITES_V,  object_name:AP_VENDOR_SITES_V,  status:VALID,  product: AP - Payables ,  description: (Release 10SC Only) ,  implementation_dba_data: APPS.AP_VENDOR_SITES_V , 

  • View: AP_VENDORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_VENDORS_V,  object_name:AP_VENDORS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_VENDORS_V , 

  • View: AP_VENDORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_VENDORS_V,  object_name:AP_VENDORS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_VENDORS_V , 

  • View: AP_PO_CORRECTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_CORRECTIONS_V,  object_name:AP_PO_CORRECTIONS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_PO_CORRECTIONS_V , 

  • View: AP_PO_CORRECTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_CORRECTIONS_V,  object_name:AP_PO_CORRECTIONS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_PO_CORRECTIONS_V ,