Results for “ap_recurring_payments_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_RECURRING_PAYMENTS_ALL is the Oracle Payables table that stores the definition and parameters of recurring invoice templates. Each row represents a template from which Oracle Payables periodically generates actual invoices in AP_INVOICES_ALL. The table resides in the AP schema and is valid in both Oracle EBS 12.1.1 and 12.2.2. It is a core setup-and-transaction hybrid object: it bridges supplier setup, distribution sets, payment terms, accounting flexfields, currencies, and purchasing references into a single reusable template definition.

The table is populated through the Recurring Invoices window in the Payables workbench, and its rows drive the Recurring Invoice batch process, which creates invoice and distribution rows on a schedule defined by the period type and period count columns.

From a Data Vault modeling perspective, the FK topology is satellite-leaning. The table carries a substantial descriptive payload (amounts, dates, flags, and 15 descriptive flexfield columns) anchored by a surrogate primary key, with many foreign keys pointing outward to reference and master tables. It behaves primarily as a satellite attached to the supplier and operating-unit hubs rather than as a pure junction table.

Key Information Stored

• RECURRING_PAYMENT_ID — the surrogate primary key, defined by AP_RECURRING_PAYMENTS_PK and additionally by the unique index AP_RECURRING_PAYMENTS_U1. This is the value stored on AP_INVOICES_ALL.RECURRING_PAYMENT_ID for generated invoices.
• VENDOR_ID and VENDOR_SITE_ID — supplier and supplier site for the template; together with RECURRING_PAY_NUM these form the business-key candidate defined by unique index AP_RECURRING_PAYMENTS_UK1. The recurring payment number is the human-readable template identifier.
• REC_PAY_PERIOD_TYPE, NUM_OF_PERIODS, FIRST_PERIOD, FIRST_PERIOD_NUM, NEXT_PERIOD, NEXT_PAYMENT, REM_PERIODS, NUM_OF_PERIODS_REM — the scheduling engine: period frequency, total periods authorized, first and next period, and remaining period counters.
• AUTHORIZED_TOTAL, CONTROL_AMOUNT, FIRST_AMOUNT, INCREMENT_PERCENT, SPECIAL_PAYMENT_AMOUNT1/2, SPECIAL_PERIOD_NAME1/2, RELEASED_AMOUNT — monetary controls that cap or pattern the amounts generated per period.
• DISTRIBUTION_SET_ID, ACCTS_PAY_CODE_COMBINATION_ID, TERMS_ID, SET_OF_BOOKS_ID — accounting and payment-default configuration used to build each generated invoice.
• INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_DATE, PAYMENT_CROSS_RATE — currency and conversion attributes.
• HOLD_LOOKUP_CODE, APPROVED_BY, EXPIRY_DATE, PAID_FLAG1, PAID_FLAG2, DESCRIPTION — approval, hold, and lifecycle status flags.
• ORG_ID and LEGAL_ENTITY_ID — multi-org operating unit and legal entity context, the standard partitioning and security keys in 12.x.

Common Use Cases and Queries

Typical reporting and support scenarios include listing active recurring templates per supplier, reconciling generated invoices back to their template, and auditing amount controls against actuals.

SELECT r.RECURRING_PAY_NUM,
       r.DESCRIPTION,
       r.REC_PAY_PERIOD_TYPE,
       r.NUM_OF_PERIODS,
       r.AUTHORIZED_TOTAL,
       r.NEXT_PAYMENT,
       r.PAID_FLAG1
FROM   AP_RECURRING_PAYMENTS_ALL r
WHERE  r.VENDOR_ID = :vendor_id
AND    r.ORG_ID   = :org_id;

To find invoices generated from a given template, join on AP_INVOICES_ALL.RECURRING_PAYMENT_ID:

SELECT i.INVOICE_NUM, i.INVOICE_DATE, i.INVOICE_AMOUNT, i.INVOICE_CURRENCY_CODE
FROM   AP_INVOICES_ALL i
WHERE  i.RECURRING_PAYMENT_ID = :recurring_payment_id;

Amount-control auditing compares AUTHORIZED_TOTAL and CONTROL_AMOUNT with the aggregate of released invoices per template. Supplier-centric views resolve VENDOR_ID to PO_VENDORS and VENDOR_SITE_ID to PO_VENDOR_SITES_ALL.

Related Objects

• AP_INVOICES_ALL — child table; generated invoices carry RECURRING_PAYMENT_ID back to this table.
• AP_INVOICE_DISTRIBUTIONS_ALL — distribution lines of generated invoices, also keyed by RECURRING_PAYMENT_ID.
• AP_INV_DISTS_UPDATE — update tracking for distributions with the same recurring payment reference.
• PO_VENDORS and PO_VENDOR_SITES_ALL — supplier and site master data referenced by VENDOR_ID and VENDOR_SITE_ID.
• AP_DISTRIBUTION_SETS_ALL — default distribution set referenced by DISTRIBUTION_SET_ID.
• GL_SETS_OF_BOOKS_11I, GL_CODE_COMBINATIONS, GL_DAILY_CONVERSION_TYPES — ledger and accounting flexfield references.
• FND_CURRENCIES — validates invoice and payment currency codes.
• AP_AWT_GROUPS and AP_HOLD_CODES — withholding and hold configuration referenced by the template.
• PO_LINE_LOCATIONS_ALL and PO_RELEASES_ALL — purchasing references via LINE_LOCATION_ID and PO_RELEASE_ID.
• AP_BATCHES_ALL — invoice batch referenced by BATCH_ID.