Creating Banks in Accounts Payables in oracle apps

Responsibility: Payables Manager
Navigation: Setup -> Payments -> Banks and Bank Branches

Click on Tab “Banks” and hit “Create” button. You will navigate to “Create Bank: Bank Information”. In this page only Country and Bank name are mandatory.

Enter these values and hit “Save and Next” Button. You will navigate to “Create Bank : Bank Address”. At this time, a record is inserted into following tables

a. HZ_PARTIES
b. HZ_CODE_ASSIGNMENTS
c. HZ_ORGANIZATION_PROFILES

Following Query can retrieve record from hz_parties

SELECT *
  FROM hz_parties
  WHERE party_name = :bank name

Take a note of party_id, lets call it bank_party_id

Following query can retrieve record from hz_code_assignments

SELECT *
  FROM hz_code_assignments
 WHERE owner_table_id   = :bank_party_id
   AND owner_table_name = 'HZ_PARTIES'

Important columns in this table are CLASS_CATEGORY and CLASS_CODE

Following query can retrieve data from hz_organization_profiles table
SELECT *
  FROM hz_organization_profiles
 WHERE party_id = :bank_party_id

Hit “Create” button in Address region and you will navigate to “Bank Address Details Page” Enter Address Details and hit “Apply” button.
You will come back to “Create Bank : Bank Address”.

At this time one record per address is inserted into HZ_PARTY_SITES and HZ_LOCATION tables.

Following query can give address details

SELECT *
  FROM hz_party_sites psite
     , hz_locations loc
 WHERE psite.location_id = loc.location_id
   AND psite.party_id    = :bank_party_id

Now hit “Save and Next” button. You will navigate to “Contacts” Page.

Hit “Create Contact Button. You will navigate to Contact Information Page

Enter contact Detail, Email, Phone and Address details.

For entering Phone details, hit “Add Another Row” button and phone number details

For entering Address details, hit “Create” button and enter address detail. If you click “Identifying Address” check-box and if contact already has one identifying address defined, then UI will give you option to uncheck existing identifying address.

After entering Addresses, Hit apply. You will navigate to page “Contacts”.

Hit “Finish” button to save your work. At this time, 2 records will be inserted into HZ_PARTIES. One record will have PARTY_TYPE as PERSON and it will be for CONTACT person. Other record will be for relationship between BANK and CONTACT person. It will have PARTY_TYPE as PARTY_RELATIONSHIP.
Take a note of party_id for PARTY_RELATIONSHIP and PERSON records. Let’s call these "relation_party_id" and "person_party_id".
This relation_party_id value is used for creating Contact point and address records. The value of person_party_id is used for
creating relationship between BANK and Contact PERSON.

Following query can retrieve Contact points

SELECT *
  FROM HZ_CONTACT_POINTS
 WHERE owner_table_id   = :relation_party_id
   AND owner_table_name = 'HZ_PARTIES'

Following query can retrieve address details

SELECT *
  FROM hz_party_sites psite
     , hz_locations   loc
 WHERE psite.location_id = loc.location_id
   AND psite.party_id    = :relation_party_id

Following query can give details of relationship records

SELECT *
  FROM hz_relationships
 WHERE subject_id         = :person_party_id
   AND subject_table_name = 'HZ_PARTIES'
   AND object_id          = :bank_party_id
   AND object_table_name  = 'HZ_PARTIES';

For this record, DIRECTIONAL_FLAG, DIRECTION_CODE and RELATIONSHIP_CODE should be 'F' (forward), 'P' (for Parent) and 'CONTACT_OF' Oracle will create backward relationship between bank_party_id and person_party_id. For backward relationship record, DIRECTIONAL_FLAG, DIRECTION_CODE and RELATIONSHIP_CODE should be 'B' (backward), 'C' (child) and 'CONTACT'. PARTY_ID value in both of these records will be same as relation_party_id value. RELATIONSHIP_TYPE for both records is CONTACT