CM: Banks and Bank Branches Data Migration Through FBDI Lean Specification Document

 

 

Data Conversion Specification

 

 

Banks and Bank Branches Conversion

 

 

 

 

 

Cloud Implementation

 

Author:                                  Ravi Teja Kattamuri

Creation Date:                     13^th October 2023

Last Updated:                      14^th November 2023

Document Ref:                   

Version:                                 1.0

 

Note:Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents.  When you change any of these values, be careful not to accidentally delete the bookmark.  You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region.

 

 

Document Control

Change Record

2

Date	Author	Version	Change Reference
13/10/2023		0.1	Initial Draft
14/11/2023		1.0

 

 

Reviewers

Name	Position

 

Approvers

 

Name	Position

 

 

Contents

Document Control...................................................................................... 2

Change Record........................................................................................... 2

Reviewers.................................................................................................. 2

Approvers.................................................................................................. 2

Introduction.............................................................................................. 4

Conversion Scope, Strategy, and Assumptions.................................................. 4

Prerequisites.............................................................................................. 4

MAPPING SPECIFICATIONS........................................................................... 5

Data Extract Component Logic...................................................................... 6

Data Extraction Rules................................................................................... 6

Data Reconciliation...................................................................................... 6

Upload Component Logic........................................................................... 10

Data Flow Assumptions/ Prerequisites.......................................................... 10

Open and Closed Issues............................................................................. 11

Open Issues.............................................................................................. 11

Closed Issues............................................................................................ 11

 

Note:To update the table of contents, put the cursor anywhere in the table and press [F9].  To change the number of levels displayed, select the menu option Insert‑>Index and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.

 

Introduction

Note:A work product document should be produced for each of the business entities being converted.  You may want to use the Subject field to indicate the business entity.

The purpose of this document is to document and communicate the component design specifications for the conversion of the Banks and Bank Branches that is going to be converted to the Oracle Cloud applications, where the Master Videojet Client will be used as the source for “Bank and Bank Branch” information, Then the Bank and Bank Branches will be Created in Oracle Fusion Cloud.

Following Objects will be converted:

Banks and Bank Branches.

Conversion Scope, Strategy, and Assumptions

The Conversion Component Designs are used by the project team as the basis for the design and construction of the Bank and Bank Branches conversion.

High-Level Conversion Process Overview Customer Conversion

The Data Migration of Oracle Bank and Bank Branch data will involve the conversion of data from the Videojet Team into Oracle ERP Fusion.

a.                The data being migrated from Videojet team into Oracle ERP Fusion will be transformed because the source and target data structures are different.

 

Prerequisites

       Make sure that HCM Team have to configure “Manage Geographies” and “Manage Address Formats.”

 

 

 

 

MAPPING SPECIFICATIONS

Mapping for Banks and branches

Navision Field	Fusion Field
DEN_160	Bank Name
ABI	Bank Number
ABI_CAB	Branch Name (Concatenation of Bank Code and Branch Code)
CAB	Branch Number

Mapping for Branch Address

Italy Language (Navision)	English Language (Fusion Field)
INDIRIZZO	Address
CAP	Postal Code (add 0 in begin to make it 5 digits)
DES_COM_ITA	City
DES_STATO	Country

 

Extract of all Banks and Branches from Central bank of Italy

Recon Report of data loaded in Dev2

Reconciliation Report for Banks & Branches Conversion. 

Considered the below data for Banks and Branches  

Load Status: 

Object Name	Received Count	Import count	Import Error	Loaded Count	Total Error Count
Bank Branches	19832	19775	57	19775	57
Total	19832	19775	57	19775	57

Error Details: 

Banks and Branches Duplicated: 57 

 

Resolution for the Issues: 

Duplicates were removed. 

Data Extract Component Logic

Note:Describe the component logic for the download component(s) used to convert the entity being converted.

Bring Banks and Bank Branches from Central Bank of Italy to Oracle ERP Fusion.

 

 

 

Data Extraction Rules

1. Navigate to the website of Central Bank of Italy

2. Extract the full list of banks and branches

3. Ignore the inactive banks and branches

4. Load the active branches

 

Conversion Approach to load Banks and Branches

Extract the data and populate it in Rapid Implementation Template.

·        Validate the data and change the data as required and generate .CSV file from Rapid Implementation.

·        Go to the task Upload Bank and Branches in Fusion and choose the .CSV file to upload.

·        Review output log for successfully migrated records and exceptions. Correct exceptions and reload errored records.

·        Validate the data if all columns are populated correctly.

 

Conversion Approach to load Branches Address

·        Navigate to Tools -> Import Management and download the template for Organization

·        Extract the Branch Party Number from BIP report.

·        Populate the Organization template with address and Branch Party Number (which is auto generated by system).

·        Create a Import Activity and load the addresses.

 

 

FUSION NAVIGATION

1.      Login to Oracle Fusion Applications

    

   

2.      Click on username and from it click on Setup and maintenance.

3. Search for the task called Manage Banks.

4. Here we can see all the banks. 

5. Select the desired bank to view branches for that bank and click on view branches (UI).

6. We can see all branches for a particular bank.

       

          

                             

   Flow Chart of Banks and Bank Branches through Rapid Implementation

    

 

Open and Closed Issues

 

Note:Add open issues that you identify while writing or reviewing this document to the open issues section.  As you resolve issues, move them to the closed issues section and keep the issue ID the same.  Include an explanation of the resolution.

When this work product is complete, any open issues should be transferred to the project- or process-level Issue Log (Manage focus area) and managed using a project level Issue Form (Manage focus area).  In addition, the open items should remain in the open issues section of this work product, but flagged in the resolution column as being transferred.

Open Issues

 

ID	Issue	Resolution	Responsibility	Target Date		Impact Date
1
2
3.
4

 

Closed Issues

 

ID	Issue	Resolution	Responsibility	Target Date	Impact Date
1
2
3.
4