Search Results ap_card_programs_all




Overview
Explore in AI Chat

Overview

The AP_CARD_PROGRAMS_ALL table is a core data repository within Oracle E-Business Suite Payables (AP) module, specifically for managing corporate credit card programs. It stores the master definition for all credit card programs an organization establishes with its financial institutions or card providers. This table is central to the Procure-to-Pay (P2P) cycle for card-based transactions, enabling systematic control over card issuance, expense reporting, and reconciliation. As a multi-organization table (indicated by the "_ALL" suffix), it supports the definition of card programs across multiple operating units, allowing for both shared and unit-specific program configurations. Its integrity is maintained by the primary key AP_CARD_PROGRAMS_PK on CARD_PROGRAM_ID.

Key Information Stored

The table's columns define the operational and financial parameters of a credit card program. While the full column list is not detailed in the excerpt, the foreign key relationships reveal critical data points. These include a unique CARD_PROGRAM_ID, the associated VENDOR_ID and VENDOR_SITE_ID for the card-issuing bank, and the CARD_PROGRAM_CURRENCY_CODE. The table links to a CARD_CODE_SET_ID, which governs the mapping of transaction codes from the bank feed. It also stores mapping configuration via COUNTRY_MAP_TYPE_CODE and CARD_EXP_TYPE_MAP_TYPE_CODE for aligning external data to internal values. Financial control is managed through the EXCEPTION_CLEARING_CCID, which specifies the General Ledger code combination for posting unresolved transactions.

Common Use Cases and Queries

This table is primarily accessed for setup, administration, and reporting of corporate card programs. Common operational scenarios include generating a list of all active card programs by operating unit, identifying the default accounting setup for a given program, and troubleshooting mapping issues for expense feeds. A typical query would join to PO_VENDORS and PO_VENDOR_SITES_ALL to report program details with bank information:

  • SELECT cp.card_program_id, cp.program_name, pv.vendor_name, pvs.vendor_site_code, cp.card_program_currency_code FROM ap_card_programs_all cp, po_vendors pv, po_vendor_sites_all pvs WHERE cp.vendor_id = pv.vendor_id AND cp.vendor_site_id = pvs.vendor_site_id AND cp.org_id = :org_id;

For integration, the table is referenced when creating new card requests (AP_CARD_REQUESTS_ALL) or processing incoming transaction feeds (AP_EXPENSE_FEED_LINES_ALL).

Related Objects

AP_CARD_PROGRAMS_ALL serves as a parent table for several key transactional and setup entities in Payables, as documented by its foreign key relationships. The primary child tables include:

  • AP_CARDS_ALL: Stores individual credit cards issued under a program (join on CARD_PROGRAM_ID).
  • AP_CARD_PROFILES_ALL: Holds spending limits and controls for cards in a program (join on CARD_PROGRAM_ID).
  • AP_CARD_REQUESTS_ALL: Tracks requests for new cards within a program (join on CARD_PROGRAM_ID).
  • AP_EXPENSE_FEED_LINES_ALL: Contains imported credit card transaction lines linked to the program (join on CARD_PROGRAM_ID).
  • AP_CC_ACCEPTORS: Defines merchants or categories allowed for the program (join on CARD_PROGRAM_ID).

It also references key setup tables as a child, including PO_VENDORS (bank), PO_VENDOR_SITES_ALL (bank site), FND_CURRENCIES, GL_CODE_COMBINATIONS, AP_MAP_TYPES_B (for mapping rules), and AP_CARD_CODE_SETS_ALL (for transaction codes).