Oracle Concepts for You_ R12 Supplier Bank Accounts

11 

Full text

(1)

oracle concepts for you

FRIDAY, 6 JUNE 2014

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).

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: ElangovanRagavan எ ண ய த ேவ , ந லேவ ெய ண ேவ ; தி ண ய ெந ச ேவ , ெதள த ந லறி ேவ ; ப ண ய பாவெம லா ப தி பன ேய ேபால, ந ண ய நி ன நசி திட ேவ அ னா !

View my complete profile

ABOUT ME

Join this site

with Google Friend Connect

Members (54) More »

Already a member? Sign in

FOLLOWERS

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;

(2)

Newer Post

Home

Older Post

Subscribe to: Post Comments (Atom)

Posted by ElangovanRagavan at 16:16

Labels: Bank Query, Supplier

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;

Recommend this on Google

Enter your comment...

Comment as: Google Account

Publish Preview

No comments:

Post a Comment

Live Traffic Feed

Real-time view

·

Menu

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 ago

A visitor from Chennai, Tamil

Nadu viewed "

oracle concepts for

you: To add Responsibility in

Back end Process

" 9 mins ago

A visitor from Mechelen,

Antwerpen viewed "

oracle

concepts for you: Contract

Purchase Agreements in Purchase

Order

" 12 mins ago

A visitor from India 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 Cuauhtémoc,

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

ago

A visitor from San Francisco,

California viewed "

oracle

concepts for you: December

2013

" 24 mins ago

TOTAL PAGEVIEWS

3 0 8 7 2 6

ADF (2) Advanced PL/SQL (16) AIGS (10) AIM Document (1) Alert (7) AME (17) AOL (5) AP Functional Accounting (9) AP_Module (76) APEX (70) API'S / INTREFACES (62) Application Short Name (1) approved supplier list (1) LABELS

(3)

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)

(4)

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)

(5)

VPD in Oracle (1) Web ADI in Oracle (4) Windows XP (1) Workflow (4) XLA_SUB_LEDGER (20) xml (78) ▼ 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 :

Row-Level 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

(6)

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

(7)

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

E-Business 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

(8)

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

(9)

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

(10)

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:

(11)

Clear the temporary tablespace java.io.FileNotFoundExcepti on, Transuction resister is erroring out Getting 41839 41092 40737 FRM-40734 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

Figure

Updating...

Related subjects :