Creating Banks in Accounts Payables

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

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


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



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



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


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


6. Enter contact Detail, Email, Phone and Address details.


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


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


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


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