How To Import Banks , Bank Branches and Bank Accounts In Fusion

January 1, 2020 by admin

Download Banks Spreadsheet

N: Setup and Maintenance Click on Search

Steps to Upload Bank, Branches & Accounts

N: Setup and Maintenance  à Click on Search

Search For Task: Upload Banks, Branches, and Accounts

Select Data File and Click on Submit

Validate the log:

N: Scheduled Processes

UCM/Process Details

How To Import Banks , Bank Branches and Bank Accounts In Fusion (Doc ID 1923921.1)

Analysis Queries (Success/Failures/Record Count)

Error log provide by standard Oracle process does not provided any clarity on the number of records processed/errored, the best way is to get the count from the below queries

Query to get the list of banks

SELECT BANK_NAME,
       COUNTRY_NAME
FROM   CE_BANKS_V;

Query to get the list of branches

SELECT BANK_NAME "BANK",
       BANK_BRANCH_NAME "BRANCH NAME",
       BRANCH_NUMBER,
       BANK_CODE,
       COUNTRY_NAME "COUNTRY"
FROM   CE_BANK_BRANCHES_V

Query to get the list of Bank/Branch Accounts

Select cb.BANK_NAME,
cb.COUNTRY,
cbb.BANK_BRANCH_NAME,
cba.BANK_ACCOUNT_NAME,
cba.BANK_ACCOUNT_NUM,
cba.CURRENCY_CODE
from CE_BANKS_V cb,
     CE_BANK_BRANCHES_V cbb,
     CE_BANK_ACCOUNTS cba
where cb.bank_party_id=cbb.bank_party_id
AND   cb.bank_party_id=cba.bank_id
AND   cbb.branch_party_id=cba.bank_branch_id

Validation Logic

Validation Query to check list of success/failure wrt loaded data- Padded the primary columns this extract should be compared with the provided data – based on the availability of the records – we can easily make out success and failure  records – There is no error table for this, only the log provided by standard process will have the info about the error reason

Select cb.BANK_NAME ||'-'||
cb.COUNTRY||'-'||
cbb.BANK_BRANCH_NAME||'-'||
cba.BANK_ACCOUNT_NAME||'-'||
cba.BANK_ACCOUNT_NUM||'-'||
cba.CURRENCY_CODE BBAC_DATA
from CE_BANKS_V cb,
     CE_BANK_BRANCHES_V cbb,
     CE_BANK_ACCOUNTS cba
where cb.bank_party_id=cbb.bank_party_id
AND   cb.bank_party_id=cba.bank_id
AND   cbb.branch_party_id=cba.bank_branch_id

Comments |0|