Results for “acceptor_street_address”

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

Overview

AP_CC_ACCEPTORS is a Payables (AP) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores information about credit card acceptors who provide detail-level transaction information. Credit card acceptors act as the merchant-side counterparties in corporate card programs, supplying the transaction detail feeds that Oracle Payables consumes during credit card transaction validation and reconciliation. Each row in the table describes one acceptor — including its name, address, tax identifiers, and profile attributes — and associates that acceptor with a card program defined in AP_CARD_PROGRAMS_ALL.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. This reflects its structure: the primary key CARD_ACCEPTOR_ID acts as a surrogate identifier, while the descriptive columns (name, address, country code, taxpayer number, and similar attributes) behave like satellite attributes describing an acceptor business entity. The foreign key to AP_CARD_PROGRAMS_ALL situates each acceptor within a broader card program context, and the inbound reference from AP_CREDIT_CARD_TRXNS_ALL establishes the acceptor as the parent of detail transaction records.

Key Information Stored

The table contains 22 documented columns. The most significant are summarized below.

• CARD_ACCEPTOR_ID — the surrogate primary key (AP_CC_ACCEPTORS_PK) and the column most commonly referenced by external queries, including the user search term "card_acceptor_id". It is also the sole unique index business-key candidate (AP_CC_ACCEPTORS_U1).
• CARD_PROGRAM_ID — foreign key to AP_CARD_PROGRAMS_ALL, tying the acceptor to a specific card program.
• ACCEPTOR_NAME — the merchant or acceptor name used for identification and reporting.
• ACCEPTOR_STREET_ADDRESS, ACCEPTOR_CITY, ACCEPTOR_STATE_PROVINCE, ACCEPTOR_POSTAL_CODE, ACCEPTOR_COUNTRY_CODE — the acceptor's geographic and mailing attributes.
• ACCEPTOR_BUSINESS_CODE — industry or business classification for the acceptor.
• ACCEPTOR_TAXPAYER_NUMBER, ACCEPTOR_VAT_NUMBER, ACCEPTOR_DUNS_NUMBER — tax and commercial identifiers used for validation and compliance.
• FEED_CARD_ACCEPTOR_ID — the acceptor identifier as supplied by the external transaction feed, enabling mapping between EBS and the provider's identifier.
• DETAIL_WAITING_DURATION — the interval for which the system waits for detail-level transaction data from the acceptor.
• ACCEPTOR_TYPE, ACCEPTOR_EMAIL, ACCEPTOR_TELEPHONE — classification and contact attributes.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture standard EBS audit trails.

Common Use Cases and Queries

Typical use cases include accepting detail-level transaction feeds, validating incoming transactions against known acceptors, and reconciling credit card transactions to the acceptor that originated them. A query locating an acceptor by its surrogate key follows:

• SELECT card_acceptor_id, acceptor_name, acceptor_city, acceptor_country_code FROM ap.ap_cc_acceptors WHERE card_acceptor_id = :p_id;

Acceptors can also be retrieved by card program, joining to the parent program table:

• SELECT a.card_acceptor_id, a.acceptor_name, p.card_program_name FROM ap.ap_cc_acceptors a, ap.ap_card_programs_all p WHERE a.card_program_id = p.card_program_id;

For transaction reporting, the acceptor is joined to detail transactions through CARD_ACCEPTOR_ID. The FEED_CARD_ACCEPTOR_ID column supports reconciliation when external feeds use provider-specific identifiers. Reporting on acceptors awaiting detail data leverages DETAIL_WAITING_DURATION.

Related Objects

• AP_CARD_PROGRAMS_ALL — parent card program table; joined via AP_CC_ACCEPTORS.CARD_PROGRAM_ID = AP_CARD_PROGRAMS_ALL.CARD_PROGRAM_ID.
• AP_CREDIT_CARD_TRXNS_ALL — detail credit card transaction table; references this table via AP_CREDIT_CARD_TRXNS_ALL.CARD_ACCEPTOR_ID = AP_CC_ACCEPTORS.CARD_ACCEPTOR_ID.
• AP_CC_ACCEPTORS_PK / AP_CC_ACCEPTORS_U1 — primary key and unique index on CARD_ACCEPTOR_ID, used for lookups and integrity enforcement.
• Credit card transaction validation and reconciliation processes in Oracle Payables consume this table when matching feed-supplied acceptor data to EBS acceptor records.