Search Results card_expired_flag




Overview
Explore in AI Chat

Overview

APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V is a seeded Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as IBY.IBY_FNDCPT_PAYER_ALL_INSTRS_V. It belongs to the Oracle Payments (IBY) module and consolidates the payment instruments — credit cards and bank accounts — associated with a payer party. Because it is a view rather than a table, it exposes a unified, read-only projection across several underlying Payments entities, allowing reporting and integration queries to retrieve instrument details without navigating the separate credit card and external bank account structures.

The view carries the standard Oracle internal warning: it is intended for use by standard Oracle Applications programs, and Oracle Corporation does not support direct application-data access through it. In practice, however, it is widely referenced in custom reporting and diagnostics. Status is VALID, and the object type is listed as an Internal view. In Oracle EBS 12.1.1 and 12.2.2 the view is present with identical column layout, making queries portable across both releases.

Underlying Base Objects

The documented dependencies for this view are:

  • FND_GLOBAL (package) — supplies session context such as ORG_ID and user identity used in the view's security and lookup logic.
  • FND_LOOKUPS (view) — resolves lookup codes and meanings, for example payment instrument types and card subtypes.
  • IBY_ACCOUNT_OWNERS (synonym) — links instruments to the owning party and defines the payer relationship.
  • IBY_CREDITCARD (synonym) — the credit card instrument records, including card number, expiry, and holder details.
  • IBY_CREDITCARD_ISSUERS_VL (view) — the issuers (card brands/issuing banks) associated with credit cards.
  • IBY_EXT_BANKACCOUNTS_V/IBY_EXT_BANK_ACCOUNTS_V (view) — external bank account instruments, contributing account, bank, branch, and BIC information.

The view joins these so that a single row represents one instrument — either a card or a bank account — for a given party.

Key Columns

Common Use Cases and Queries

A frequent reporting need is to list all instruments for a payer, including masked card expiry. Note that because CARD_EXPIRYDATE was obsoleted for PA-DSS, MASKED_CARD_EXPIRYDATE should be used for display:

SELECT party_id
     , instrument_id
     , instrument_type
     , card_number
     , masked_card_expirydate
     , card_expired_flag
  FROM apps.iby_fndcpt_payer_all_instrs_v
 WHERE party_id = :p_party_id;

To identify expired cards for a party, filter on the expired flag rather than the obsoleted date column:

SELECT instrument_id, card_number, masked_card_expirydate
  FROM apps.iby_fndcpt_payer_all_instrs_v
 WHERE instrument_type = 'CREDITCARD'
   AND card_expired_flag = 'Y';

Bank-only extracts use INSTRUMENT_TYPE to isolate account records and report bank and branch details. For integrations, join on INSTRUMENT_ID and PARTY_ID to reconcile instruments back to payment transactions. Because the view is unsupported for direct access, custom code should treat it as a diagnostic aid and prefer supported APIs where functional processing is required.