Results for “digit_check_flag”

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

Overview

IBY_CREDITCARD_ISSUERS_B is the base table in the Oracle Payments (IBY) schema that stores the master list of credit card brands or issuers accepted by an Oracle E-Business Suite installation. Each row represents a single card issuer — for example, Visa, MasterCard, American Express, or a locally defined private-label brand — together with the processing rules that Oracle Payments applies when that brand is transacted. The table resides in the IBY schema and is present and valid in both EBS 12.1.1 and 12.2.2 (where it is edition-enabled through the ZD_EDITION_NAME column).

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning: CARD_ISSUER_CODE behaves as a durable business key that is referenced by multiple dependent tables (transaction history, ranges, and translations), which is characteristic of a hub entity in a raw vault model. It is not a pure satellite, since satellites would carry only descriptive context around this key rather than defining it.

Key Information Stored

The table contains 13 documented columns. The most consequential are:

• CARD_ISSUER_CODE — the business identifier for the card brand. It is the sole column of the primary key IBY_CREDITCARD_ISSUERS_B_PK, and it is the column that every dependent table uses for referential integrity.
• CARD_ISSUER_ACCEPTED_FLAG — indicates whether the brand is currently enabled for processing. Disabling a brand suppresses it from payment flows without deleting history.
• AUTHORIZATION_VALIDITY_PERIOD — the number of days an authorization remains valid before settlement must occur; used to time out stale holds.
• DIGIT_CHECK_FLAG — controls whether the system validates the card number against the issuer's Luhn-style check digit during capture.
• AUTH_REVERSAL_FLAG — governs whether Oracle Payments automatically issues an authorization reversal when an order is cancelled or a payment fails.
• ALLOW_CAPTURE_EX_AUTH_FLAG — determines whether capturing an amount greater than the original authorization is permitted for this brand.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns tracking row provenance and audit.
• OBJECT_VERSION_NUMBER — optimistic locking token used by the IBY APIs and concurrent programs.
• ZD_EDITION_NAME — the editioning column introduced in 12.2.x; the business-key unique index IBY_CREDITCARD_ISSUERS_B_U1 is defined on (CARD_ISSUER_CODE, ZD_EDITION_NAME), reflecting the edition-aware uniqueness model.

Common Use Cases and Queries

Operational and reporting scenarios typically involve confirming which brands are active, verifying the authorization behavior configured for a brand, and joining issuer attributes into card transaction reporting. Representative SQL patterns include:

• Listing currently accepted brands: SELECT CARD_ISSUER_CODE, AUTHORIZATION_VALIDITY_PERIOD, DIGIT_CHECK_FLAG FROM IBY.IBY_CREDITCARD_ISSUERS_B WHERE CARD_ISSUER_ACCEPTED_FLAG = 'Y';
• Auditing which transactions used a given brand: join IBY_CREDITCARD on CARD_ISSUER_CODE to retrieve card-level records linked to a specific issuer.
• Reconciling payment behavior by dumping the flag columns (auth reversal, capture ex-auth) into a configuration report for finance/treasury review.
• Locating localized brand names by joining to IBY_CREDITCARD_ISSUERS_TL on CARD_ISSUER_CODE for multi-language reporting.
• Identifying BIN ranges associated with a brand through IBY_CC_ISSUER_RANGES for card-detection and routing rules.

Related Objects

The table is referenced by several dependent objects through CARD_ISSUER_CODE:

• IBY_CREDITCARD (CARD_ISSUER_CODE) — the credit card transaction record; the primary operational consumer of this hub.
• IBY_CREDITCARD_H (CARD_ISSUER_CODE) — the corresponding history table for card transactions.
• IBY_CREDITCARD_ISSUERS_TL (CARD_ISSUER_CODE) — translatable name and description for each issuer, driving multi-language display.
• IBY_CC_ISSUER_RANGES (CARD_ISSUER_CODE) — the BIN/card-number ranges that identify each brand.

Together these objects form the issuer reference hierarchy that underlies the IBY credit card payment processing flow, from brand detection through authorization, settlement, and reversal.