Search Results ap_terms_lines




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.