Search Results iby_xml_fd_prba_1_0_v




Overview
Explore in AI Chat

Overview

The IBY_XML_FD_PRBA_1_0_V view is a payments-module XML generation view owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Payments (IBY) product and forms part of the XML Publisher / extract framework that produces payment-related XML documents for outbound bank files, remittance advice, and payment instruction feeds.

The suffix convention _FD_PRBA_1_0_V indicates a "Field Definition" extract view at version 1.0 — specifically the PRBA (Payee/Payment Bank Account) record structure. The view constructs an XMLType fragment describing an internal bank account, including bank identity, branch details, account identifiers, currency, address, and federal/EFT routing attributes. Its output is a canonical, versioned XML representation of a bank account record used by payment formatting engines.

Because the view emits an XMLType rather than scalar rows, it is consumed by XML Publisher data templates, payment format programs, and the extraction generation packages rather than by ordinary transactional reports.

Underlying Base Objects

The ETRM 12.2.2 metadata records the following referenced base objects:

The view text joins IBY_EXT_FD_PRBA_1_0_V INT_BA with IBY_XML_HZ_ADDR_1_0_V XML_HZ_ADDR on BANK_BRANCH_ADDRESS_ID = LOCATION_ID(+), an outer join permitting accounts without a resolved branch address.

Key Columns

The view exposes a single XML payload plus the BANK_ACCOUNT_ID key column. Within the XML, the significant elements are:

  • BANKACCOUNTINTERNALID / BANKNAME / BANKNUMBER — internal identifier and bank identity.
  • BRANCHINTERNALID / BRANCHNAME / BRANCHNUMBER / BRANCHTYPE — branch identity, with CODE and MEANING sub-elements.
  • BANKACCOUNTNAME / BANKACCOUNTNUMBER / IBANNUMBER / SWIFTCODE / CHECKDIGITS — account-level identifiers and international routing codes.
  • BANKACCOUNTTYPE and BANKACCOUNTCURRENCY — CODE/MEANING pairs describing the account classification and currency.
  • BANKADDRESS — the formatted branch address from the HZ address view.
  • DESCRIPTIVEFLEXFIELD — conditional DFF content sourced via IBY_EXTRACTGEN_PVT.GET_DFFS from CE_BANK_ACCOUNTS.
  • FEDERALBANKACCOUNTINFO — RFC identifier, agency location code, abbreviated agency code, and federal employer ID.
  • EFTUSERNUMBER — account-level and branch-level EFT user numbers.

Common Use Cases and Queries

Typical usage includes generating payment XML for bank transmission, verifying account data before format validation, and troubleshooting missing DFF or address values. A representative query retrieving the XML payload for a specific bank account is:

  • SELECT xml_payload FROM (SELECT x.*, x.BANK_ACCOUNT_ID AS acct FROM ap_iby_xml_fd_prba_1_0_v x) WHERE acct = :bank_account_id;
  • Extracting scalar fields using EXTRACTVALUE or XMLTABLE for reconciliation reports.
  • Filtering by IBANNUMBER IS NOT NULL to validate international payment readiness.

Because output is XMLType, DBAs should apply XMLIndex or function-based indexing before large-scale extraction.