Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Oracle Concepts For You - R12 Supplier Bank Accounts

    Uploaded by

    kartheekbeeramjula
    In Release 12, supplier bank account information is stored in new tables rather than the PO_VENDORS table used in Release 11i. The bank, branch, and account details are stored across several tables that are linked together through relationships. Supplier bank accounts are created in Payables by navigating to the supplier entry form and adding banking details. Queries are provided to retrieve supplier bank account information by joining records across the relevant tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle Concepts For You - R12 Supplier Bank Accounts

    Uploaded by

    kartheekbeeramjula
    2K views11 pages
    In Release 12, supplier bank account information is stored in new tables rather than the PO_VENDORS table used in Release 11i. The bank, branch, and account details are stored across several tables that are linked together through relationships. Supplier bank accounts are created in Payables by navigating to the supplier entry form and adding banking details. Queries are provided to retrieve supplier bank account information by joining records across the relevant tables.

    Original Description:

    Oracle Concepts for You_ R12 Supplier Bank Accounts

    Original Title

    Oracle Concepts for You_ R12 Supplier Bank Accounts

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    In Release 12, supplier bank account information is stored in new tables rather than the PO_VENDORS table used in Release 11i. The bank, branch, and account details are stored across several tables that are linked together through relationships. Supplier bank accounts are created in Payables by navigating to the supplier entry form and adding banking details. Queries are provided to retrieve supplier bank account information by joining records across the relevant tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2K views11 pages

    Oracle Concepts For You - R12 Supplier Bank Accounts

    Uploaded by

    kartheekbeeramjula
    In Release 12, supplier bank account information is stored in new tables rather than the PO_VENDORS table used in Release 11i. The bank, branch, and account details are stored across several tables that are linked together through relationships. Supplier bank accounts are created in Payables by navigating to the supplier entry form and adding banking details. Queries are provided to retrieve supplier bank account information by joining records across the relevant tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 11
    At a glance
    Powered by AI
    The key tables for storing supplier bank account information in R12 are IBY_EXT_BANK_ACCOUNTS, HZ_PARTIES and HZ_RELATIONSHIPS. Bank, branch and location details are also stored in other tables. Payment related details of suppliers are also stored in other tables.

    The main tables involved are IBY_EXT_BANK_ACCOUNTS, HZ_PARTIES, HZ_RELATIONSHIPS, HZ_ORGANIZATION_PROFILES, IBY_EXTERNAL_PAYEES_ALL.

    Some ways to query supplier bank account details mentioned are using tables IBY_EXT_BANK_ACCOUNTS, HZ_PARTIES, HZ_ORGANIZATION_PROFILES, IBY_EXTERNAL_PAYEES_ALL and their relationships. Queries provided join some of these tables.

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts


    0

    More

    Next Blog

    Create Blog

    Sign In

    oracle concepts for you


    FRIDAY, 6 JUNE 2014

    ABOUT ME

    R12 Supplier Bank Accounts


    In Release 12, Payables Supplier Bank Information is stored somewhere else instead of
    PO_VENDORS table as in 11i. The supplier (or External) bank account information are
    stored in the table called IBY_EXT_BANK_ACCOUNTS. The bank and bank branches
    information are stored in the table HZ_PARTIES. They are linked together through
    Relationships (in HZ_RELATIONSHIP).
    There is a separate link for both Bank to Branch and also from Branch to Bank. Bank sites
    and Location information are stored in tables: HZ_PARTY_SITES and HZ_LOCATIONS.
    The bank_id and branch_id fields of IBY_EXT_BANK_ACCOUNTS table link the Bank
    Account to the relevant Bank and Branch Parties in the HZ_PARTIES table
    (IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id).

    ElangovanRagavan


    ,

    ;


    !
    View my complete profile

    Supplier (or External) bank accounts are created in Payables, in the Supplier Entry forms.
    Navigate to Suppliers -> Entry. Query or create your supplier. Click on Banking Details and
    then choose Create. After you have created the bank account, you can assign the bank
    account to the supplier site.
    When the Bank is assigned to Vendors then it will be updated in a table called
    HZ_CODE_ASSIGNMENTS. Payment related details of supplier are also inserted in
    iby_external_payees_all as well as iby_ext_party_pmt_mthds.
    The bank branch number can be found in the table: HZ_ORGANIZATION_PROFILES .The
    HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This
    table gets populated when a party of the Organization type is created.
    IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds
    disbursement payment process for external party payees.
    Queries:

    FOLLOWERS
    Join this site
    with Google Friend Connect

    Members (54) More

    Already a member? Sign in

    LIVE VIEWERS

    SELECT aps.vendor_name "VERDOR NAME",


    apss.vendor_site_code "VENDOR SITE CODE",
    ieb.bank_name "BANK NAME",
    iebb.bank_branch_name "BANK BRANCH NAME",
    iebb.branch_number "BRANCH NUMBER",
    ieba.BANK_ACCOUNT_NUM "BANK ACCOUNT NUMBER",
    ieba.BANK_ACCOUNT_NAME "BANK ACCOUNT NAME"
    FROM ap.ap_suppliers aps,
    ap.ap_supplier_sites_all apss,
    apps.iby_ext_bank_accounts ieba,
    apps.iby_account_owners iao,
    apps.iby_ext_banks_v ieb,
    apps.iby_ext_bank_branches_v iebb
    WHERE aps.vendor_id = apss.vendor_id
    and iao.account_owner_party_id = aps.party_id
    and ieba.ext_bank_account_id = iao.ext_bank_account_id
    and ieb.bank_party_id = iebb.bank_party_id
    and ieba.branch_id = iebb.branch_party_id
    and ieba.bank_id = ieb.bank_party_id;

    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    1/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    Live Traffic Feed

    Oracle PL/SQL

    SELECT party_supp.party_name supplier_name


    ,
    aps.segment1
    supplier_number
    ,
    ass.vendor_site_code supplier_site
    ,
    ieb.bank_account_num
    ,
    ieb.bank_account_name
    ,
    party_bank.party_name bank_name
    ,
    branch_prof.bank_or_branch_number bank_number
    ,
    party_branch.party_name branch_name
    ,
    branch_prof.bank_or_branch_number branch_number
    FROM hz_parties party_supp
    ,
    ap_suppliers aps
    ,
    hz_party_sites site_supp
    ,
    ap_supplier_sites_all ass
    ,
    iby_external_payees_all iep
    ,
    iby_pmt_instr_uses_all ipi
    ,
    iby_ext_bank_accounts ieb
    ,
    hz_parties party_bank
    ,
    hz_parties party_branch
    ,
    hz_organization_profiles bank_prof
    ,
    hz_organization_profiles branch_prof
    WHERE party_supp.party_id = aps.party_id
    AND party_supp.party_id = site_supp.party_id
    AND site_supp.party_site_id = ass.party_site_id
    AND ass.vendor_id = aps.vendor_id
    AND iep.payee_party_id = party_supp.party_id
    AND iep.party_site_id = site_supp.party_site_id
    AND iep.supplier_site_id = ass.vendor_site_id
    AND iep.ext_payee_id = ipi.ext_pmt_party_id
    AND ipi.instrument_id = ieb.ext_bank_account_id
    AND ieb.bank_id = party_bank.party_id
    AND ieb.bank_id = party_branch.party_id
    AND party_branch.party_id = branch_prof.party_id
    AND party_bank.party_id = bank_prof.party_id
    ORDER BY party_supp.party_name
    ,
    ass.vendor_site_code;

    A visitor from Bangalore,


    Karnataka viewed "oracle
    concepts for you: R12 Supplier
    Bank
    Accounts"
    47 secs ago
    A visitor
    from Bangalore,
    Karnataka viewed "oracle
    concepts for you: Oracle Apps
    Technical Interview Questions" 7
    mins
    A
    visitor
    ago from Chennai, Tamil
    Nadu viewed "oracle concepts for
    you: To add Responsibility in
    Back
    endfrom
    Process"
    9 mins ago
    A visitor
    Mechelen,
    Antwerpen viewed "oracle
    concepts for you: Contract
    Purchase Agreements in Purchase
    Order"
    A
    visitor
    12from
    minsIndia
    ago viewed
    "oracle concepts for you:
    CUSTOMER API" 17 mins ago
    A visitor from Chicago, Illinois
    viewed "oracle concepts for you:
    Different type of xml tags in bi
    publisher"
    18 mins
    ago
    A visitor from
    Cuauhtmoc,
    Chihuahua viewed "oracle
    concepts for you: DBA" 21 mins
    ago
    A visitor from San Francisco,
    California left "oracle concepts
    for you: December 2013" via
    irep.oracle.com
    24 mins ago
    A visitor from Cambridge,
    Massachusetts viewed "oracle
    concepts for you: Inventory
    Consists in Oracle Apps" 24 mins
    A visitor from San Francisco,
    ago
    California viewed "oracle
    concepts for you: December
    2013"
    24 mins
    Real-time
    viewago
    Menu

    Posted by ElangovanRagavan at 16:16


    Recommend this on Google

    Labels: Bank Query, Supplier

    No comments:
    Post a Comment

    Enter your comment...


    TOTAL PAGEVIEWS

    3 0 8 7 2 6
    Comment as:

    Google Account
    LABELS

    Publish

    ADF (2)

    Preview

    Advanced PL/SQL (16)


    AIGS (10)
    AIM Document (1)
    Alert (7)
    AME (17)

    Newer Post

    Home

    Older Post

    AOL (5)
    AP Functional Accounting (9)

    Subscribe to: Post Comments (Atom)

    AP_Module (76)
    APEX (70)
    API'S / INTREFACES (62)
    Application Short Name (1)
    approved supplier list (1)

    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    2/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    APPS (11)
    AR_Query (54)
    Back-to-Back Order Cycle (1)
    Bank Query (28)
    BOM (1)
    Cash Management (6)
    concurrent program (40)
    Contorl file ctl (7)
    Contorl file SQL *Loader (4)
    Current Login Users (1)
    custom.pll (6)
    Customer (8)
    Data Extraction (57)
    Data Model (2)
    Date Format (6)
    DBA (90)
    DELETE_QUERY (1)
    DFF (3)
    Documents (1)
    EAM (14)
    elango (5)
    ERROR (23)
    Executable (21)
    FA (12)
    FlexFields (4)
    FND_LOAD (9)
    form personalization (45)
    Forms (20)
    FUNCTIONAL (71)
    gl (69)
    GL Accounting (6)
    GRC (21)
    GRC Tech (12)
    HRMS (80)
    Hyperion (7)
    ICX - Oracle Self-Service Web
    Applications (2)
    iExpenses (8)
    IF (1)
    Inventory_Details (30)
    iprocurement (3)
    ITEM_TEMPLATE (1)
    java (7)
    Lexical & Bind (2)
    LINKS IN ALL TABLES (5)
    Materialized View (1)
    Multi-Org (13)
    My Favorited Links (1)
    MY FAVOURITES (2)
    O2C CYCLE (19)
    OBIEE (73)
    ODI (1)
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    3/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    OM (10)
    Oracle (1)
    ORACLE -Orbital Relational
    Analytical Computing Logical
    Equation (5)
    Oracle Certification (1)
    Oracle Discoverer (4)
    Oracle Interview Questions (42)
    Oracle Pricing (6)
    Oracle Standard Reports (25)
    org (4)
    Outlook (1)
    Output type in Oracle (1)
    P2P Cycle (14)
    Password in EBS (3)
    Payroll (2)
    Personalize OAF Pages (16)
    PL/SQL (52)
    PO (67)
    profile (7)
    Projects (37)
    QUERY (3)
    R12 (3)
    RDF report (4)
    Receipt (1)
    Reconciled Payments (2)
    REPORT (13)
    REPORT NAMES (1)
    REPORT_QUERY (9)
    request group (1)
    Request Set (2)
    Reset the po (2)
    Responsibility (16)
    Shell Script (6)
    SLA (13)
    SQL (62)
    SRW.user_exit (2)
    SUB_QUERY (1)
    Supplier (13)
    sysadmin (15)
    Tables (60)
    TAX (15)
    TCA R12 (6)
    technical (4)
    Time Formets (2)
    TOAD (2)
    Trace (3)
    UPDATE QUERY (20)
    User Hooks (1)
    USER_RES_MENU (11)
    Valueset (17)
    Videos (6)
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    4/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    VPD in Oracle (1)


    Web ADI in Oracle (4)
    Windows XP (1)
    Workflow (4)
    XLA_SUB_LEDGER (20)
    xml (78)

    BLOG ARCHIVE

    2014 (696)
    November (15)
    October (12)
    September (36)
    August (4)
    July (178)
    June (177)
    ODBC Vs OCI
    Setting up the ODBC
    Connection for OBIEE
    OBIEE Development Life
    cycle- Administration
    Scheduler in OBIEE11g
    OBIEE 11g log files path
    OBIEE 11g Security : RowLevel Security
    Parent Child Hierarchy in
    OBIEE 11G
    OBIEE 10g to 11g Upgrade
    CREATING REPORTS
    USING RTF TEMPLATE
    IN BI PUBLISHE...
    Creating Analyses and
    Building Dashboards in
    11g
    How To Reset User
    Password in 8.6.5 and
    above:Concept behind Subledger
    Accounting
    PO to GL link in R12
    ATO Configuration Cycle In
    Order Management
    PTO Configuration Cycle In
    Order Management
    API Script to add the
    responsibilities to a user
    API script to Disable the
    enabled Responsibilities...
    API script to Enable the
    Disabled
    Responsibilities...
    Script to generate the FND
    Load Script
    Submit Concurrent Program
    through DB Trigger
    Oracle DBA Querys
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    5/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    1. Query To get list of


    responsibilities. ========
    ...
    Which User is Locking the
    table
    Query to get the
    Menu,Submenu and
    function details...
    Script to Calculate the Price
    and Tax details of t...
    Script to Calculate the Tax
    details of the Product...
    Script to Calculate the Price
    details of the Produ...
    TCA Api to Update the Party
    Information
    (HZ_PARTY_...
    P2P Technical
    Flow(Complete Query)
    Customer & Supplier
    Banks(External Banks)
    Technica...
    Sub Ledger Accounting SLA
    (Complete Functional Inf...
    R12 Subledger Accounting
    AR to GL link in R12
    TCA Create Party Package
    Query to find attachments of
    a contract
    AP Invoice not getting
    added to Assets
    Important TCA APIs
    Adding list of values to a
    field in OAF
    Create a simple update
    page
    Create a Simple Search
    Page
    Subledger-Ledger Linkage
    (Accounts Receivable)
    Subledger-Ledger Linkage
    (Accounts Payables)
    Subledger-Ledger Linkage
    (Purchasing)
    Connect By Level
    Special/French Characters
    Conversion Sometimes
    you...
    Dates in Hours/Minutes/Secs
    Script to get profile option
    values at different l...
    Script to set profile value at
    different levels
    View Other Users Request
    Output
    Script to Give Grant (Read
    Only) for all Objects t...
    Script to create Synonym for
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    6/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    all Objects for a par...


    XML Publisher Report with
    PLSQL as Data Source
    and...
    Let's Play with SQL
    How to Delete a Service
    Contract
    Information to get the current
    session SQL stateme...
    API to delete purchase
    Orders
    User Hooks in Oracle
    API To Create/Update Party
    Oracle WebLogic Server
    12c: Installing WebLogic
    Se...
    Oracle WebLogic Server
    (WLS) 12c Release 1
    (12.1.1...
    Connecting Remotely to
    Weblogic Management
    Port - ...
    Useful GRC Note Id's
    Oracle GRC Suite
    Configuration Controls
    Governor - CCG
    Installation...
    Oracle Weblogic 12c Install
    Configuring SSL R12 Oracle Applications
    Configuring DMZ server R12
    - Oracle Application
    Personalize / Customize EBusiness Suite Login
    Pag...
    Personalize Customize
    Oracle R12 Login Page
    Marathon Upgrade R12.1.1
    to R12.1.3
    Direct Login to forms
    SOA 11g J-Rockit 28 class
    allocation footprint in ...
    Integration of WebLogic
    Deployed Application with
    ...
    RMAN Backup Scripts
    DBA Querys
    Displaying Workflow
    Notification on home page
    Applying HR Global Patches
    Allow Backend Access to
    Database
    Oracle R12 - installation
    Guide
    Oracle 11i And R12
    Documentation
    Db sequential file read
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    7/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    Customer Account Creation


    Using TCA APIs
    Upgrading Oracle GRC from
    8.6.4.3000 to
    8.6.4.4000...
    Oracle GRC ACCG Installing
    CCG Patching strategy
    CCG configuring with RAC
    EBS database using ASM
    fi...
    Step by step Installation &
    configuration of Oracl...
    How to use ETRM
    Oracle Technical Data Model
    Oracle Application:Data
    Model
    1) What is ERP? Architecture
    of apps?
    A pa...
    Create Menu and
    responsibility to attached
    the Use...
    Time Converter in US to
    INDIA
    How to check the PF
    Trace
    Delete Script for XML
    template
    RTF Template - Variables
    RTF Template Word
    Features
    NACHA FORMAT in Oracle
    Apps
    how to identify the special
    character in oracle
    Charli Chaplin
    APJ abdul kalam speech
    How to find the backend
    SQL query from Self
    Servic...
    R12 Oracle Payables
    Management
    Fundamentals
    HRMS update position API
    HRMS update job API
    Concurrent Executable and
    Program Creations and
    De...
    SQL Report - Submenu and
    Function Details
    (Respons...
    How to submit the
    concurrent request from
    PLSQL
    How to register the oracle
    reports in oracle apps
    How to register the forms in
    oracle applications
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    8/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    Pay on Receipt(s) in Oracle


    Apps R12
    Purchase Order > Approval
    hierarchy in oracle apps...
    Query to find Project
    Manager Info of an Oracle
    Pr...
    API to cancel AP Invoice
    Few Important AP Tables
    How can you query the bank
    account associated with...
    R12 Supplier Bank Accounts
    Account Payable FAQs
    Table/View Changes in R12:
    Payables
    Setup - Approval Hierarchies
    in Oracle Purchasing
    HZ tables in Oracle
    Receivables
    List of Receipts API in
    Oracle Receivables
    AR Tables:A Diagrammatic
    Relation
    Trading Community
    Architecture (TCA) in
    Oracle App...
    AutoInvoice program setup
    steps in AR
    AutoInvoice in Oracle Apps
    R12
    Order to Cash (O2C) Cycle
    in oracle apps
    Query to get Customer
    Information in R12
    R12 Customer Bank
    Accounts
    Payment Method Defaulting
    Rule in oracle apps
    Delete HRMS Job API
    Delete HRMS Position API
    Summary column vs.
    Formula Column vs.
    Placeholder ...
    User Exits in Oracle Reports
    Calling a Report from a Form
    in oracle apps
    How Create a report with
    Lexical Parameter in
    orac...
    Lexical parameterThese are
    used to replace a value...
    SRW Package in Oracle
    Report
    If you want to design similar
    functionality as bel...
    11i vs. R12 Procure to Pay
    (P2P) Cycle different i...
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    9/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    To Remove Special
    Characters Use following
    Replace...
    How To Find the
    FND_PATCHSET_LEVEL
    While Applying ...
    There are no active
    responsibilities available
    for...
    Query to check value of
    Profile Options in R12
    Query to find currently
    running sql in database
    Patch release history query
    in oracle apps.
    Oracle apps Reports FAQ
    Important Tables for Oracle
    Apps DBA
    Free Space in Tempory
    Tablespace
    Obsolete Database
    Parameters
    Oracle Instance last started
    Database uptime and
    startup time / Lost clone in
    D...
    Oracle Dependency Tree
    structure
    Oracle Schema Summery
    Active session queries in
    oracle apps
    Table Locking Information in
    SQL/PLUS
    uncommited TRANSACTION
    in apps
    Multiple session list of a user
    Oracle Certification exams
    Uncosted Material
    Transactions with
    CSTPSISC.INS_S...
    APP-FND-00804: Program
    error: Invalid arguments
    to...
    How to get the 5th highest
    value from a table
    ORA-01002: fetch out of
    sequence
    Dblink Details in oracle apps
    REP-3000: Internal error
    starting Oracle Toolkit
    Rapid Clone adcfgclone.pl
    Error
    RA-12154 TNS:could not
    resolve service name
    ORA-06512: at line
    ORA-06550:
    ORA-01722: invalid number
    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    10/11

    11/22/2014

    oracle concepts for you: R12 Supplier Bank Accounts

    Clear the temporary


    tablespace
    java.io.FileNotFoundExcepti
    on,
    Transuction resister is
    erroring out
    Getting FRM-41839 FRM41092 FRM-40737 FRM40734 Wh...
    Oracle account error
    ORA_28000
    FRM-40735: ZOOM trigger
    raised unhandled
    exception...
    May (181)
    April (23)
    March (10)
    February (5)
    January (55)
    2013 (556)
    2012 (301)
    2011 (239)

    FISH

    Picture Window template. Template images by JacobH. Powered by Blogger.

    http://appselangovan.blogspot.in/2014/06/r12-supplier-bank-accounts.html

    11/11

    You might also like