Results for “iby_bepkeys”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IBY_BEPKEYS is a core Payments (IBY) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores information about payment system accounts. In the Oracle Payments architecture, a "BEP" (Back-End Payment system) represents a payment system or payment processor configured within the application. IBY_BEPKEYS acts as the account registry for those payment systems, holding the set of accounts that are defined against each BEP and that can subsequently be selected as the source or target account for a funds capture or disbursement transaction. Each row links an account to the payment system that services it, together with an owner reference that identifies whether the account belongs to a person, an organization, or another owning entity within the applications.
From a dimensional modeling perspective, the mined foreign key structure classifies this table as hub-leaning. That is a modeling suggestion rather than a documented fact: IBY_BEPKEYS behaves as a central hub of the payment account domain, with a stable surrogate identifier that many dependent transactional and configuration tables point back to. It is not a pure transaction link, nor a pure attribute satellite; it carries identity and a limited set of attributes, which is consistent with hub behavior.
Key Information Stored
The table is documented with 30 physical columns in the 12.2.2 ETRM schema. The most significant are:
- BEP_ACCOUNT_ID — the surrogate primary key of the table, defined by constraint IBY_BEPKEYS_PK. This is the value carried as a foreign key by nearly every dependent table.
- BEPID — the foreign key to IBY_BEPINFO that identifies the payment system (BEP) to which the account belongs.
- OWNERID and OWNERTYPE — a polymorphic owner reference. Together they identify which entity (for example, a supplier, customer, or internal organization) owns the account; OWNERTYPE distinguishes the owner category.
- KEY — a key value associated with the payment account record.
- DEFAULTS — holds defaulting information for the account.
- SECURITY_GROUP_ID — the Multi-Org/security grouping foreign key, referencing FND_SECURITY_GROUPS.
- OBJECT_VERSION_NUMBER — the optimistic locking column used by the concurrent/OLTP framework.
- ZD_EDITION_NAME — the editioning column present in the 12.2.2 schema, supporting the online patching (Editioning) model.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle Applications descriptive flexfield (DFF) columns available for customer-defined extensions.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, which support auditing and concurrent program consistency.
Two unique constraints are documented. IBY_BEPKEYS_UK covers OWNERID, OWNERTYPE, BEPID, and KEY, representing the business key that guarantees a given owner/payment-system pair cannot duplicate a KEY value. The unique index IBY_BEPKEYS_U1 covers BEP_ACCOUNT_ID and ZD_EDITION_NAME, which is the edition-aware uniqueness required by the 12.2.2 online patching architecture. In practice, BEP_ACCOUNT_ID is the operational join key, while the IBY_BEPKEYS_UK combination is the logical business identifier.
Common Use Cases and Queries
IBY_BEPKEYS is most often queried when resolving an account identifier returned by a payment profile or transaction table back to its payment system and owner. A typical lookup joins IBY_BEPKEYS to IBY_BEPINFO to obtain the payment system name for a given account:
- SELECT k.bep_account_id, k.bepid, i.bep_name, k.ownerid, k.ownertype FROM iby_bepkeys k, iby_bepinfo i WHERE k.bepid = i.bepid;
- Resolving which accounts are configured for a payment system: SELECT bep_account_id, key FROM iby_bepkeys WHERE bepid = :p_bepid;
- Identifying accounts attached to a specific owner: SELECT bep_account_id, bepid, key FROM iby_bepkeys WHERE ownerid = :p_owner_id AND ownertype = :p_owner_type;
- Finding the accounts used by credit card, debit card, or EFT payment profiles, by correlating BEP_ACCOUNT_ID from IBY_FNDCPT_USER_CC_PF_B, IBY_FNDCPT_USER_DC_PF_B, or IBY_FNDCPT_USER_EFT_PF_B against IBY_BEPKEYS.
- Locating the default account for a payment system via IBY_DEFAULT_BEP.BEP_ACCOUNT_ID.
Reporting use cases include payment account inventories per payment system, compliance reviews of which owners have which accounts configured, and reconciliation of routing configuration through IBY_ROUTINGINFO. Because the table carries a security group column, multi-org aware queries should respect SECURITY_GROUP_ID where applicable.
Related Objects
The following dependent objects are documented as referencing IBY_BEPKEYS through the BEP_ACCOUNT_ID column, and are the most significant consumers of this hub:
- IBY_BEPINFO — parent payment system definition; referenced by IBY_BEPKEYS.BEPID.
- IBY_ACCT_PMT_PROFILES_B — payment profiles that select a configured payment account.
- IBY_BEP_ACCT_OPT_VALS — option values associated with each payment account.
- IBY_DEFAULT_BEP — default payment system configuration per account.
- IBY_FNDCPT_USER_CC_PF_B — credit card payment profiles for funds capture users.
- IBY_FNDCPT_USER_DC_PF_B — debit card payment profiles.
- IBY_FNDCPT_USER_EFT_PF_B — EFT (bank transfer) payment profiles.
- IBY_ROUTINGINFO — routing information that ties payment instructions to a payment account.
- FND_SECURITY_GROUPS — referenced by IBY_BEPKEYS.SECURITY_GROUP_ID for multi-org security.
Any extension or custom reporting on payment accounts should treat IBY_BEPKEYS as the authoritative account hub and preserve referential integrity to the dependent tables listed above.
-
IBY_BEPKEYS stores information about the payment systems accounts.
-
IBY_BEPKEYS contains a list of all the keys that identifies a payee or payer with a Back End Payment System.
-
SYNONYM: APPS.IBY_BEPKEYS 12.1.1
-
SYNONYM: APPS.IBY_BEPKEYS 12.2.2
-
TABLE: IBY.IBY_BEPKEYS 12.1.1
-
TABLE: IBY.IBY_BEPKEYS 12.2.2
-
TRIGGER: APPS.IBY_BEPKEYS+ 12.2.2
-
VIEW: IBY.IBY_BEPKEYS# 12.2.2
-
TRIGGER: APPS.IBY_BEPKEYS+ 12.2.2