Search Results supplier site assignment




The AP_CARD_SUPPLIERS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for storing corporate card supplier information within the Accounts Payable (AP) module. This table serves as a foundation for managing procurement card (P-Card) programs, enabling organizations to streamline expense tracking, reconciliation, and payment processing for corporate card transactions. Below is a detailed technical and functional analysis of this table.

Table Overview

AP_CARD_SUPPLIERS_ALL is a multi-organization enabled table that stores master data related to card-issuing financial institutions or payment networks (e.g., Visa, Mastercard, American Express). It is part of Oracle's P-Card functionality, which integrates corporate card transactions with AP workflows.

Key Columns and Structure

The table contains the following critical columns:
  • CARD_SUPPLIER_ID: Primary key, uniquely identifying each card supplier record.
  • VENDOR_ID: Foreign key linking to PO_VENDORS, associating the card supplier with a vendor in Oracle.
  • NAME: The name of the card supplier (e.g., "Bank of America Corporate Cards").
  • CARD_PROGRAM_CODE: Identifier for the card program (e.g., "TRAVEL" or "PURCHASING").
  • ORG_ID: Multi-org identifier, allowing supplier data segregation by operating unit.
  • ENABLED_FLAG: Indicates whether the supplier is active ('Y' or 'N').
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Functional Role

This table supports:
  • P-Card Reconciliation: Provides the master reference for matching transaction files from card issuers.
  • Expense Reporting: Enables automatic population of supplier details in AP invoices created from card transactions.
  • Multi-Org Compliance: Allows different business units to maintain distinct card programs while sharing a common vendor.

Integration Points

The table integrates with:
  • AP_CARD_PROGRAMS_ALL: Defines card program rules linked to suppliers.
  • AP_CARD_TRX_ALL: Stores individual card transactions referencing this table.
  • PO_VENDORS: Maintains vendor relationships for payment processing.
  • Financials General Ledger: Supports accounting for card-related liabilities.

Technical Considerations

  • Indexes exist on CARD_SUPPLIER_ID, VENDOR_ID, and ORG_ID for performance.
  • Data is typically created/maintained via the "Card Programs" form (Navigation: AP > Setup > Payments > Card Programs).
  • Customizations often extend this table for additional attributes like custom reconciliation fields.

Version-Specific Notes

  • 12.1.1: Basic P-Card functionality with limited web services integration.
  • 12.2.2: Enhanced with REST API support for card program management and improved multi-org handling.

Best Practices

  • Maintain consistent vendor linkages to avoid duplicate payments.
  • Leverage ORG_ID filtering in custom reports for security compliance.
  • Archive inactive suppliers rather than deleting to preserve referential integrity.
This table is essential for organizations implementing corporate card programs in Oracle EBS, providing the structural foundation for automated expense management while maintaining financial controls.