Data Conversion
Mapping Specification
General
Ledger Data Conversion
Cloud
Implementation
Author:
Creation Date:
Last Updated:
Document Ref:
Version: 1.0
Change Record
|
Date |
Author |
Version |
Change Reference |
|
| |||
|
|
|
|
|
|
|
|
|
|
|
Name |
Position |
|
|
|
|
|
|
|
|
|
|
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........................................................................... 6
Data Extract Component
Logic...................................................................... 7
Data Extraction Rules................................................................................... 8
Data Reconciliation...................................................................................... 8
Upload Component Logic............................................................................. 9
Data Flow Assumptions/
Prerequisites............................................................ 9
Open and Closed Issues............................................................................. 10
Open Issues.............................................................................................. 10
Closed Issues............................................................................................ 10
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.
The purpose of this document is to
document and communicate the configurations, data
mapping,
interdependency and component
design specifications for the conversion of an individual entity that is going
to be converted to the Oracle Cloud applications.
Following Objects will be converted:
General Ledger legacy data conversion to Oracle fusion
Conversion Scope, Strategy, and
Assumptions
The Conversion Component Designs is
used by the Videojet team as the basis for the design and construction of the General
Ledger data conversion.
High Level Conversion Process Overview- GL data
A. The Data Migration of Oracle General
Ledger data will involve conversion of data from CLIENT’s old legacy system
into CLIENT’s new Oracle Fusion.
B. The data being migrated from
CLIENT’s old system into new system will be transformed because the source and
target data structures are different.
Following configurations are required in SaaS
·
Primary
and Secondary Ledgers
·
Journal
Sources
·
Journal
Categories
·
COA
segments and values
·
Currencies
·
Periods
should open
Data conversion process involves mapping of
source and destination columns which is the critical part of entire conversion
process. As discussed on Customers conversion with Videojet IT, mapping of the
columns will be provided along with data in standard FBDI templates or ADFDI sheet.
Please find attached Rapid Template for Mapping and
FBDI Template for Conversion.
Mapping Sheet.
|
Oracle Fields |
To be Filled |
Navision Field |
|
*Status Code |
New
|
No specific field in Navision |
|
*Ledger ID |
Should be entered as per the DEV
instance
|
No specific field in Navision |
|
*Effective Date of
Transaction |
YYYY/MM/DD - to select the period
|
|
|
*Journal Source |
Spreadsheet
|
VJ should finalize |
|
*Journal Category |
Balancesheet
|
VJ should finalize |
|
*Currency Code |
EUR
|
|
|
*Journal Entry
Creation Date |
YYYY/MM/DD - Last day of DEC
|
|
|
*Actual Flag |
A
|
No specific field in Navision |
|
Segment1 |
Company
|
|
|
Segment2 |
Location
|
|
|
Segment3 |
Department
|
|
|
Segment4 |
Account
|
|
|
Segment5 |
Subaccount
|
|
|
Segment6 |
Intercompany
|
|
|
Segment7 |
Product
|
|
|
Segment8 |
Saleschannel
|
|
|
Segment9 |
Future
|
|
|
Segment10 |
|
|
|
Segment11 |
|
|
|
Segment12 |
|
|
|
Segment13 |
|
|
|
Segment14 |
|
|
|
Segment15 |
|
|
|
Segment16 |
|
|
|
Segment17 |
|
|
|
Segment18 |
|
|
|
Segment19 |
|
|
|
Segment20 |
|
|
|
Segment21 |
|
|
|
Segment22 |
|
|
|
Segment23 |
|
|
|
Segment24 |
|
|
|
Segment25 |
|
|
|
Segment26 |
|
|
|
Segment27 |
|
|
|
Segment28 |
|
|
|
Segment29 |
|
|
|
Segment30 |
|
|
|
Entered Debit
Amount |
Debit amount
|
|
|
Entered Credit
Amount |
Credit amount
|
|
|
Converted Debit
Amount |
Converted Debit Amount if currency
is not EUR
|
|
|
Converted Credit
Amount |
Converted CreditAmount if currency
is not EUR
|
|
|
REFERENCE1 (Batch
Name) |
Journal Batch Name
|
|
|
REFERENCE2 (Batch
Description) |
|
|
|
REFERENCE3 |
|
|
|
REFERENCE4 (Journal
Entry Name) |
Journal Name
|
|
|
REFERENCE5 (Journal
Entry Description) |
|
|
|
REFERENCE6 (Journal
Entry Reference) |
|
|
|
REFERENCE7 (Journal
Entry Reversal flag) |
|
|
|
REFERENCE8 (Journal
Entry Reversal Period) |
|
|
|
REFERENCE9 (Journal
Reversal Method) |
|
|
|
REFERENCE10
(Journal Entry Line Description) |
|
|
|
Reference column 1 |
|
|
|
Reference column 2 |
|
|
|
Reference column 3 |
|
|
|
Reference column 4 |
|
|
|
Reference column 5 |
|
|
|
Reference column 6 |
|
|
|
Reference column 7 |
|
|
|
Reference column 8 |
|
|
|
Reference column 9 |
|
|
|
Reference column 10 |
|
|
|
Statistical Amount |
|
|
|
Currency Conversion
Type |
|
|
|
Currency Conversion
Date |
|
|
|
Currency Conversion
Rate |
|
|
|
Interface Group
Identifier |
Group ID for identification while
running program
|
No specific field in Navision |
|
Context field for
Journal Entry Line DFF |
|
|
|
ATTRIBUTE1 Value
for Journal Entry Line DFF |
|
|
|
ATTRIBUTE2 Value
for Journal Entry Line DFF |
|
|
|
Attribute3 Value
for Journal Entry Line DFF |
|
|
|
Attribute4 Value
for Journal Entry Line DFF |
|
|
|
Attribute5 Value
for Journal Entry Line DFF |
|
|
|
Attribute6 Value
for Journal Entry Line DFF |
|
|
|
Attribute7 Value
for Journal Entry Line DFF |
|
|
|
Attribute8 Value
for Journal Entry Line DFF |
|
|
|
Attribute9 Value
for Journal Entry Line DFF |
|
|
|
Attribute10 Value
for Journal Entry Line DFF |
|
|
|
Attribute11 Value
for Captured Information DFF |
|
|
|
Attribute12 Value
for Captured Information DFF |
|
|
|
Attribute13 Value
for Captured Information DFF |
|
|
|
Attribute14 Value for
Captured Information DFF |
|
|
|
Attribute15 Value
for Captured Information DFF |
|
|
|
Attribute16 Value
for Captured Information DFF |
|
|
|
Attribute17 Value
for Captured Information DFF |
|
|
|
Attribute18 Value
for Captured Information DFF |
|
|
|
Attribute19 Value
for Captured Information DFF |
|
|
|
Attribute20 Value
for Captured Information DFF |
|
|
|
Context field for
Captured Information DFF |
|
|
|
Average Journal
Flag |
|
|
|
Clearing Company |
|
|
|
Ledger Name |
|
|
|
Encumbrance Type ID |
|
|
|
Reconciliation
Reference |
|
|
|
Period Name |
|
|
|
REFERENCE 18 |
|
|
|
REFERENCE 19 |
|
|
|
REFERENCE 20 |
|
|
|
Attribute Date 1 |
|
|
|
Attribute Date 2 |
|
|
|
Attribute Date 3 |
|
|
|
Attribute Date 4 |
|
|
|
Attribute Date 5 |
|
|
|
Attribute Date 6 |
|
|
|
Attribute Date 7 |
|
|
|
Attribute Date 8 |
|
|
|
Attribute Date 9 |
|
|
|
Attribute Date 10 |
|
|
|
Attribute Number 1 |
|
|
|
Attribute Number 2 |
|
|
|
Attribute Number 3 |
|
|
|
Attribute Number 4 |
|
|
|
Attribute Number 5 |
|
|
|
Attribute Number 6 |
|
|
|
Attribute Number 7 |
|
|
|
Attribute Number 8 |
|
|
|
Attribute Number 9 |
|
|
|
Attribute Number 10 |
|
|
|
Global Attribute
Category |
|
|
|
Global Attribute 1 |
|
|
|
Global Attribute 2 |
|
|
|
Global Attribute 3 |
|
|
|
Global Attribute 4 |
|
|
|
Global Attribute 5 |
|
|
|
Global Attribute 6 |
|
|
|
Global Attribute 7 |
|
|
|
Global Attribute 8 |
|
|
|
Global Attribute 9 |
|
|
|
Global Attribute 10 |
|
|
|
Global Attribute 11 |
|
|
|
Global Attribute 12 |
|
|
|
Global Attribute 13 |
|
|
|
Global Attribute 14 |
|
|
|
Global Attribute 15 |
|
|
|
Global Attribute 16 |
|
|
|
Global Attribute 17 |
|
|
|
Global Attribute 18 |
|
|
|
Global Attribute 19
|
|
|
|
Global Attribute 20
|
|
|
|
Global Attribute
Date 1 |
|
|
|
Global Attribute
Date 2 |
|
|
|
Global Attribute
Date 3 |
|
|
|
Global Attribute
Date 4 |
|
|
|
Global Attribute
Date 5 |
|
|
|
Global Attribute
Number 1 |
|
|
|
Global Attribute
Number 2 |
|
|
|
Global Attribute
Number 3 |
|
|
|
Global Attribute
Number 4 |
|
|
|
Global Attribute
Number 5 |
|
|
Note:Describe the component logic for
the download component(s) used to convert the entity being converted.
Bring General Ledger data and
related details from existing legacy system to New Fusion.
|
Oracle FBDI
Field Name |
Description |
Mapping from
legacy system/Values |
|
*Status Code |
New |
No specific
field in Navision |
|
*Ledger ID |
Should be
entered as per the DEV instance |
No specific
field in Navision |
|
*Effective
Date of Transaction |
YYYY/MM/DD -
to select the period |
|
|
*Journal
Source |
Spreadsheet |
VJ should
finalize |
|
*Journal
Category |
Balancesheet |
VJ should
finalize |
|
*Currency
Code |
EUR |
|
|
*Journal
Entry Creation Date |
YYYY/MM/DD -
Last day of DEC |
|
|
*Actual Flag |
A |
No specific
field in Navision |
|
Segment1 |
Company |
|
|
Segment2 |
Location |
|
|
Segment3 |
Department |
|
|
Segment4 |
Account |
|
|
Segment5 |
Subaccount |
|
|
Segment6 |
Intercompany |
|
|
Segment7 |
Product |
|
|
Segment8 |
Saleschannel |
|
|
Segment9 |
Future |
|
|
Segment10 |
|
|
|
Segment11 |
|
|
|
Segment12 |
|
|
|
Segment13 |
|
|
|
Segment14 |
|
|
|
Segment15 |
|
|
|
Segment16 |
|
|
|
Segment17 |
|
|
|
Segment18 |
|
|
|
Segment19 |
|
|
|
Segment20 |
|
|
|
Segment21 |
|
|
|
Segment22 |
|
|
|
Segment23 |
|
|
|
Segment24 |
|
|
|
Segment25 |
|
|
|
Segment26 |
|
|
|
Segment27 |
|
|
|
Segment28 |
|
|
|
Segment29 |
|
|
|
Segment30 |
|
|
|
Entered Debit
Amount |
Debit amount |
|
|
Entered
Credit Amount |
Credit amount |
|
|
Converted
Debit Amount |
Converted
Debit Amount if currency is not EUR |
|
|
Converted
Credit Amount |
Converted
CreditAmount if currency is not EUR |
|
|
REFERENCE1
(Batch Name) |
Journal Batch
Name |
|
|
REFERENCE2
(Batch Description) |
|
|
|
REFERENCE3 |
|
|
|
REFERENCE4
(Journal Entry Name) |
Journal Name |
|
|
REFERENCE5
(Journal Entry Description) |
|
|
|
REFERENCE6
(Journal Entry Reference) |
|
|
|
REFERENCE7
(Journal Entry Reversal flag) |
|
|
|
REFERENCE8
(Journal Entry Reversal Period) |
|
|
|
REFERENCE9
(Journal Reversal Method) |
|
|
|
REFERENCE10
(Journal Entry Line Description) |
|
|
|
Reference
column 1 |
|
|
|
Reference
column 2 |
|
|
|
Reference
column 3 |
|
|
|
Reference
column 4 |
|
|
|
Reference
column 5 |
|
|
|
Reference
column 6 |
|
|
|
Reference
column 7 |
|
|
|
Reference
column 8 |
|
|
|
Reference
column 9 |
|
|
|
Reference
column 10 |
|
|
|
Statistical
Amount |
|
|
|
Currency
Conversion Type |
|
|
|
Currency
Conversion Date |
|
|
|
Currency
Conversion Rate |
|
|
|
Interface
Group Identifier |
Group ID for
identification while running program |
No specific
field in Navision |
|
Context field
for Journal Entry Line DFF |
|
|
|
ATTRIBUTE1
Value for Journal Entry Line DFF |
|
|
|
ATTRIBUTE2
Value for Journal Entry Line DFF |
|
|
|
Attribute3
Value for Journal Entry Line DFF |
|
|
|
Attribute4
Value for Journal Entry Line DFF |
|
|
|
Attribute5
Value for Journal Entry Line DFF |
|
|
|
Attribute6
Value for Journal Entry Line DFF |
|
|
|
Attribute7
Value for Journal Entry Line DFF |
|
|
|
Attribute8
Value for Journal Entry Line DFF |
|
|
|
Attribute9
Value for Journal Entry Line DFF |
|
|
|
Attribute10
Value for Journal Entry Line DFF |
|
|
|
Attribute11
Value for Captured Information DFF |
|
|
|
Attribute12
Value for Captured Information DFF |
|
|
|
Attribute13
Value for Captured Information DFF |
|
|
|
Attribute14
Value for Captured Information DFF |
|
|
|
Attribute15
Value for Captured Information DFF |
|
|
|
Attribute16
Value for Captured Information DFF |
|
|
|
Attribute17
Value for Captured Information DFF |
|
|
|
Attribute18
Value for Captured Information DFF |
|
|
|
Attribute19
Value for Captured Information DFF |
|
|
|
Attribute20
Value for Captured Information DFF |
|
|
|
Context field
for Captured Information DFF |
|
|
|
Average
Journal Flag |
|
|
|
Clearing
Company |
|
|
|
Ledger Name |
|
|
|
Encumbrance
Type ID |
|
|
|
Reconciliation
Reference |
|
|
|
Period Name |
|
|
|
REFERENCE 18 |
|
|
|
REFERENCE 19 |
|
|
|
REFERENCE 20 |
|
|
|
Attribute
Date 1 |
|
|
|
Attribute
Date 2 |
|
|
|
Attribute
Date 3 |
|
|
|
Attribute
Date 4 |
|
|
|
Attribute
Date 5 |
|
|
|
Attribute
Date 6 |
|
|
|
Attribute
Date 7 |
|
|
|
Attribute
Date 8 |
|
|
|
Attribute
Date 9 |
|
|
|
Attribute
Date 10 |
|
|
|
Attribute
Number 1 |
|
|
|
Attribute
Number 2 |
|
|
|
Attribute
Number 3 |
|
|
|
Attribute
Number 4 |
|
|
|
Attribute
Number 5 |
|
|
|
Attribute
Number 6 |
|
|
|
Attribute
Number 7 |
|
|
|
Attribute
Number 8 |
|
|
|
Attribute
Number 9 |
|
|
|
Attribute
Number 10 |
|
|
|
Global
Attribute Category |
|
|
|
Global
Attribute 1 |
|
|
|
Global
Attribute 2 |
|
|
|
Global
Attribute 3 |
|
|
|
Global
Attribute 4 |
|
|
|
Global
Attribute 5 |
|
|
|
Global
Attribute 6 |
|
|
|
Global
Attribute 7 |
|
|
|
Global
Attribute 8 |
|
|
|
Global
Attribute 9 |
|
|
|
Global
Attribute 10 |
|
|
|
Global Attribute
11 |
|
|
|
Global
Attribute 12 |
|
|
|
Global
Attribute 13 |
|
|
|
Global
Attribute 14 |
|
|
|
Global
Attribute 15 |
|
|
|
Global
Attribute 16 |
|
|
|
Global
Attribute 17 |
|
|
|
Global
Attribute 18 |
|
|
|
Global
Attribute 19 |
|
|
|
Global
Attribute 20 |
|
|
|
Global
Attribute Date 1 |
|
|
|
Global
Attribute Date 2 |
|
|
|
Global
Attribute Date 3 |
|
|
|
Global
Attribute Date 4 |
|
|
|
Global
Attribute Date 5 |
|
|
|
Global
Attribute Number 1 |
|
|
|
Global
Attribute Number 2 |
|
|
|
Global Attribute
Number 3 |
|
|
|
Global
Attribute Number 4 |
|
|
|
Global
Attribute Number 5 |
|
|
Data
Extraction
Rules
·
Click
the Generate CSV File button to generate a ZIP file containing one or more CSV
files. Upload the data using the Load Interface File for Import process into Import
Journals .
·
After
you successfully load your data, you must submit the Import Journals to import
the data into the application tables and create the Journals.
·
To submit the Import Journals process:
1. Navigate to the Tools.
2. Click on Schedule new process.
3. Run the Load Interface File for Import
program and select Import Journals.
4. Run Import Journals once file got loaded
into interface successfully
The development specifications for asset data assume the following:
Key
Assumptions are:
·
The data of GL Journals will be provided by the CLIENT
extraction team directly into Oracle standard FBDI/ADFDI formats.
·
All required setups/configurations have
been completed before the program is run.
·
All
system level profile options have been setup.
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.
|
ID |
Issue |
Resolution |
Responsibility |
Target
Date |
Impact
Date |
|
|
1 |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
3. |
|
|
|
|
|
|
|
4 |
|
|
|
|
|
|
|
ID |
Issue |
Resolution |
Responsibility |
Target Date |
Impact Date |
|
1 |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
3. |
|
|
|
|
|
|
4 |
|
|
|
|
|
Comments
Post a Comment