IBY — Payments
181 documented tables · 135 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
IBY_PAYEE |
IBY_PAYEE stores a row for each payee, such as a biller, merchant, or store at this site. | hub |
IBY_BEPINFO |
IBY_BEPKEYS stores information about the payment systems. | hub |
IBY_ECAPP |
IBY_ECAPP stores information about Electronic Commerce Applications registered with iPayment. Oracle Applicati | hub-leaning |
IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_SUMMARIES_ALL contains information about each payment request. This table is used for both online | satellite-leaning |
IBY_TRANSMIT_PROTOCOLS_B |
hub | |
IBY_EXTRACTS_B |
Defines data extracts for payment file creation | hub-leaning |
IBY_SYS_PMT_PROFILES_B |
"This table stores Payment Process Profile setup for Funds Disbursement transactions. This table also stores | hub |
IBY_F_T_CRDT_APPS_ALL_B |
hub | |
IBY_SYS_SECURITY_SUBKEYS |
hub-leaning | |
IBY_SECURITY_SEGMENTS |
hub-leaning | |
IBY_PAYMENT_REASONS_B |
IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payab | hub |
IBY_FORMATS_B |
Stores payment processing format types | hub |
IBY_FNDCPT_TX_EXTENSIONS |
"The data in this table will be created by the source products through the public API IBY_FNDCPT_TRXN_PUB, Cr | hub-leaning |
IBY_PAYMENT_METHODS_B |
IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment at | hub |
IBY_F_CRDT_APP_STATUS_B |
hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
IBY_FNDCPT_COMMON_PUB |
PUB | 6 | 65 packages |
IBY_FNDCPT_TRXN_PUB |
PUB | 26 | 49 packages |
IBY_DEBUG_PUB |
PUB | 3 | 42 packages |
IBY_FNDCPT_SETUP_PUB |
PUB | 25 | 35 packages |
IBY_EXT_BANKACCT_PUB |
PUB | 33 | 34 packages |
IBY_DISBURSEMENT_SETUP_PUB |
PUB | 9 | 18 packages |
IBY_VALIDATIONSETS_PUB |
PUB | 31 | 13 packages |
IBY_DISBURSEMENT_COMP_PUB |
PUB | 12 | 10 packages |
IBY_PAYMENT_ADAPTER_PUB |
PUB | 18 | 6 packages |
IBY_PAYGROUP_PUB |
PUB | 89 | 5 packages |