AR: Accounts Receivables Transactions Data Migration (DM) through FBDI Lean Specification

 

 

Data Conversion Specification

 

 

Receivables Invoice Conversion through FBDI Template

 

 

 

 

 

Cloud Implementation

 

Author:                                  

Creation Date:                     13^th November 2023        

Last Updated:                      13^th November 2023

Document Ref:                   

Version:                                 0.1

 

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/11/2023		0.1	Initial Draft

 

 

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

 

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 configurations, data mapping, interdependency, and component design specifications for the conversion of the Sales invoice that is going to be converted to the Oracle Cloud applications, where the Master Navision will be used as the source for “Sales Invoice” information, Then the Sales Invoice will be Created in Oracle Fusion Cloud Financials.

The Objective of this invoice conversion is to convert all unpaid Invoices from Legacy system to Oracle ERP Fusion Cloud.

Following Objects will be converted:

Sales Invoices.

Conversion Scope, Strategy, and Assumptions

The Conversion Component Designs are used by the team as the basis for the design and construction of the Sales Invoice conversion.

High-Level Conversion Process Overview Customer Conversion

The Data Migration of Oracle Sales Invoice data will involve the conversion of data from the Navision system into Oracle ERP Fusion.

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

 

Prerequisites

The following setups are defined in Oracle ERP Fusion Instance to upload the Sales Invoice.

A.     General Ledger (GL)

i.                 Chart of Accounts (COA)

B.     Accounts Receivable

i.                 All Customer Data should be available prior to conversion.

ii.                Auto Accounting should be setup prior to conversion.

iii.               Transaction Type should be created.

iv.               Create Data Migration Transaction Source.

v.                Invoice line DFF need to be setup prior to conversion.

MAPPING SPECIFICATIONS

All the Account Code Combinations are picked from Auto Accounting Setup.

Please Find Attached Field Mapping from Navision to Fusion.

Tips: AR Period Should in Open Status and Customers Data Should be loaded first

  

Oracle FBDI Column Names	To Be Filled	Default Value
Business Unit Identifier	No
*Business Unit Name	Yes	Videojet Italy
*Transaction Batch Source Name	Yes	0333VJ CONVERSION
*Transaction Type Name	Yes	0333VJ CONVERSION
Payment Terms	Yes	30 Net
Transaction Date	Yes	2023-10-19
Accounting Date	Yes	2023-10-19
Transaction Number	Yes	Conv12
Original System Bill-to Customer Reference	No
Original System Bill-to Customer Address Reference	No
Original System Bill-to Customer Contact Reference	No
Original System Ship-to Customer Reference	No
Original System Ship-to Customer Address Reference	No
Original System Ship-to Customer Contact Reference	No
Original System Ship-to Customer Account Reference	No
Original System Ship-to Customer Account Address Reference	No
Original System Ship-to Customer Account Contact Reference	No
Original System Sold-to Customer Reference	No
Original System Sold-to Customer Account Reference	No
Bill-to Customer Account Number	Yes	4
Bill-to Customer Site Number	Yes	12
Bill-to Contact Party Number	Yes If data available
Ship-to Customer Account Number	Yes	4
Ship-to Customer Site Number	Yes	12
Ship-to Contact Party Number	Yes If data available
Sold-to Customer Account Number	Yes If data available
*Transaction Line Type	Yes	LINE
*Transaction Line Description	Yes	Test12
*Currency Code	Yes	EUR
*Currency Conversion Type	Yes	User
Currency Conversion Date	No
Currency Conversion Rate	Yes	1
Transaction Line Amount	Yes	1122.00
Transaction Line Quantity	Yes	1.00
Customer Ordered Quantity	Yes If data available
Unit Selling Price	Yes	1122.00
Unit Standard Price	Yes If data available
Line Transactions Flexfield Context	Yet To Discuss
Line Transactions Flexfield Segment 1	Yet To Discuss
Line Transactions Flexfield Segment 2	Yet To Discuss
Line Transactions Flexfield Segment 3	Yet To Discuss
Line Transactions Flexfield Segment 4	Yet To Discuss
Line Transactions Flexfield Segment 5	Yet To Discuss
Line Transactions Flexfield Segment 6	Yet To Discuss
Line Transactions Flexfield Segment 7	Yet To Discuss
Line Transactions Flexfield Segment 8	Yet To Discuss
Line Transactions Flexfield Segment 9	Yet To Discuss
Line Transactions Flexfield Segment 10	Yet To Discuss
Line Transactions Flexfield Segment 11	Yet To Discuss
Line Transactions Flexfield Segment 12	Yet To Discuss
Line Transactions Flexfield Segment 13	Yet To Discuss
Line Transactions Flexfield Segment 14	Yet To Discuss
Line Transactions Flexfield Segment 15	Yet To Discuss
Primary Salesperson Number	No
Tax Classification Code	No
Legal Entity Identifier	No
Accounted Amount in Ledger Currency	No
Sales Order Number	No
Sales Order Date	No
Actual Ship Date	No
Warehouse Code	No
Unit of Measure Code	No
Unit of Measure Name	No
Invoicing Rule Name	No
Revenue Scheduling Rule Name	No
Number of Revenue Periods	No
Revenue Scheduling Rule Start Date	No
Revenue Scheduling Rule End Date	No
Reason Code Meaning	No
Last Period to Credit	No
Transaction Business Category Code	No
Product Fiscal Classification Code	No
Product Category Code	No
Product Type	No
Line Intended Use Code	No
Assessable Value	No
Document Sub Type	No
Default Taxation Country	No
User Defined Fiscal Classification	No
Tax Invoice Number	No
Tax Invoice Date	No
Tax Regime Code	No
Tax	No
Tax Status Code	No
Tax Rate Code	No
Tax Jurisdiction Code	No
First Party Registration Number	No
Third Party Registration Number	No
Final Discharge Location	No
Taxable Amount	No
Taxable Flag	No
Tax Exemption Flag	No
Tax Exemption Reason Code	No
Tax Exemption Reason Code Meaning	No
Tax Exemption Certificate Number	No
Line Amount Includes Tax Flag	No
Tax Precedence	No
Credit Method To Be Used For Lines With Revenue Scheduling Rules	No
Credit Method To Be Used For Transactions With Split Payment Terms	No
Reason Code	No
Tax Rate	No
FOB Point	No
Carrier	No
Shipping Reference	No
Sales Order Line Number	No
Sales Order Source	No
Sales Order Revision Number	No
Purchase Order Number	Yes
Purchase Order Revision Number	No
Purchase Order Date	No
Agreement Name	No
Memo Line Name	Yes
Document Number	No
Original System Batch Name	No
Link-to Transactions Flexfield Context	No
Link-to Transactions Flexfield Segment 1	No
Link-to Transactions Flexfield Segment 2	No
Link-to Transactions Flexfield Segment 3	No
Link-to Transactions Flexfield Segment 4	No
Link-to Transactions Flexfield Segment 5	No
Link-to Transactions Flexfield Segment 6	No
Link-to Transactions Flexfield Segment 7	No
Link-to Transactions Flexfield Segment 8	No
Link-to Transactions Flexfield Segment 9	No
Link-to Transactions Flexfield Segment 10	No
Link-to Transactions Flexfield Segment 11	No
Link-to Transactions Flexfield Segment 12	No
Link-to Transactions Flexfield Segment 13	No
Link-to Transactions Flexfield Segment 14	No
Link-to Transactions Flexfield Segment 15	No
Reference Transactions Flexfield Context	No
Reference Transactions Flexfield Segment 1	No
Reference Transactions Flexfield Segment 2	No
Reference Transactions Flexfield Segment 3	No
Reference Transactions Flexfield Segment 4	No
Reference Transactions Flexfield Segment 5	No
Reference Transactions Flexfield Segment 6	No
Reference Transactions Flexfield Segment 7	No
Reference Transactions Flexfield Segment 8	No
Reference Transactions Flexfield Segment 9	No
Reference Transactions Flexfield Segment 10	No
Reference Transactions Flexfield Segment 11	No
Reference Transactions Flexfield Segment 12	No
Reference Transactions Flexfield Segment 13	No
Reference Transactions Flexfield Segment 14	No
Reference Transactions Flexfield Segment 15	No
Link To Parent Line Context	No
Link To Parent Line Segment 1	No
Link To Parent Line Segment 2	No
Link To Parent Line Segment 3	No
Link To Parent Line Segment 4	No
Link To Parent Line Segment 5	No
Link To Parent Line Segment 6	No
Link To Parent Line Segment 7	No
Link To Parent Line Segment 8	No
Link To Parent Line Segment 9	No
Link To Parent Line Segment 10	No
Link To Parent Line Segment 11	No
Link To Parent Line Segment 12	No
Link To Parent Line Segment 13	No
Link To Parent Line Segment 14	No
Link To Parent Line Segment 15	No
Receipt Method Name	No
Printing Option	No
Related Batch Source Name	No
Related Transaction Number	No
Inventory Item Number	No
Inventory Item Segment 2	No
Inventory Item Segment 3	No
Inventory Item Segment 4	No
Inventory Item Segment 5	No
Inventory Item Segment 6	No
Inventory Item Segment 7	No
Inventory Item Segment 8	No
Inventory Item Segment 9	No
Inventory Item Segment 10	No
Inventory Item Segment 11	No
Inventory Item Segment 12	No
Inventory Item Segment 13	No
Inventory Item Segment 14	No
Inventory Item Segment 15	No
Inventory Item Segment 16	No
Inventory Item Segment 17	No
Inventory Item Segment 18	No
Inventory Item Segment 19	No
Inventory Item Segment 20	No
Bill To Customer Bank Account Name	No
Reset Transaction Date Flag	No
Payment Server Order Number	No
Last Transaction on Debit Authorization	No
Approval Code	No
Address Verification Code	No
Transaction Line Translated Description	No
Consolidated Billing Number	No
Promised Commitment Amount	No
Payment Set Identifier	No
Original Accounting Date	No
Invoiced Line Accounting Level	No
Override AutoAccounting Flag	Yes
Historical Flag	No
Deferral Exclusion Flag	No
Payment Attributes	No
Invoice Billing Date	No
Invoice Lines Flexfield Context	No
Invoice Lines Flexfield Segment 1	No
Invoice Lines Flexfield Segment 2	No
Invoice Lines Flexfield Segment 3	No
Invoice Lines Flexfield Segment 4	No
Invoice Lines Flexfield Segment 5	No
Invoice Lines Flexfield Segment 6	No
Invoice Lines Flexfield Segment 7	No
Invoice Lines Flexfield Segment 8	No
Invoice Lines Flexfield Segment 9	No
Invoice Lines Flexfield Segment 10	No
Invoice Lines Flexfield Segment 11	No
Invoice Lines Flexfield Segment 12	No
Invoice Lines Flexfield Segment 13	No
Invoice Lines Flexfield Segment 14	No
Invoice Lines Flexfield Segment 15	No
Invoice Transactions Flexfield Context	No
Invoice Transactions Flexfield Segment 1	No
Invoice Transactions Flexfield Segment 2	No
Invoice Transactions Flexfield Segment 3	No
Invoice Transactions Flexfield Segment 4	No
Invoice Transactions Flexfield Segment 5	No
Invoice Transactions Flexfield Segment 6	No
Invoice Transactions Flexfield Segment 7	No
Invoice Transactions Flexfield Segment 8	No
Invoice Transactions Flexfield Segment 9	No
Invoice Transactions Flexfield Segment 10	No
Invoice Transactions Flexfield Segment 11	No
Invoice Transactions Flexfield Segment 12	No
Invoice Transactions Flexfield Segment 13	No
Invoice Transactions Flexfield Segment 14	No
Invoice Transactions Flexfield Segment 15	No
Receivables Transaction Region Information Flexfield Context	No
Receivables Transaction Region Information Flexfield Segment 1	No
Receivables Transaction Region Information Flexfield Segment 2	No
Receivables Transaction Region Information Flexfield Segment 3	No
Receivables Transaction Region Information Flexfield Segment 4	No
Receivables Transaction Region Information Flexfield Segment 5	No
Receivables Transaction Region Information Flexfield Segment 6	No
Receivables Transaction Region Information Flexfield Segment 7	No
Receivables Transaction Region Information Flexfield Segment 8	No
Receivables Transaction Region Information Flexfield Segment 9	No
Receivables Transaction Region Information Flexfield Segment 10	No
Receivables Transaction Region Information Flexfield Segment 11	No
Receivables Transaction Region Information Flexfield Segment 12	No
Receivables Transaction Region Information Flexfield Segment 13	No
Receivables Transaction Region Information Flexfield Segment 14	No
Receivables Transaction Region Information Flexfield Segment 15	No
Receivables Transaction Region Information Flexfield Segment 16	No
Receivables Transaction Region Information Flexfield Segment 17	No
Receivables Transaction Region Information Flexfield Segment 18	No
Receivables Transaction Region Information Flexfield Segment 19	No
Receivables Transaction Region Information Flexfield Segment 20	No
Receivables Transaction Region Information Flexfield Segment 21	No
Receivables Transaction Region Information Flexfield Segment 22	No
Receivables Transaction Region Information Flexfield Segment 23	No
Receivables Transaction Region Information Flexfield Segment 24	No
Receivables Transaction Region Information Flexfield Segment 25	No
Receivables Transaction Region Information Flexfield Segment 26	No
Receivables Transaction Region Information Flexfield Segment 27	No
Receivables Transaction Region Information Flexfield Segment 28	No
Receivables Transaction Region Information Flexfield Segment 29	No
Receivables Transaction Region Information Flexfield Segment 30	No
Line Global Descriptive Flexfield Attribute Category	No
Line Global Descriptive Flexfield Segment 1	No
Line Global Descriptive Flexfield Segment 2	No
Line Global Descriptive Flexfield Segment 3	No
Line Global Descriptive Flexfield Segment 4	No
Line Global Descriptive Flexfield Segment 5	No
Line Global Descriptive Flexfield Segment 6	No
Line Global Descriptive Flexfield Segment 7	No
Line Global Descriptive Flexfield Segment 8	No
Line Global Descriptive Flexfield Segment 9	No
Line Global Descriptive Flexfield Segment 10	No
Line Global Descriptive Flexfield Segment 11	No
Line Global Descriptive Flexfield Segment 12	No
Line Global Descriptive Flexfield Segment 13	No
Line Global Descriptive Flexfield Segment 14	No
Line Global Descriptive Flexfield Segment 15	No
Line Global Descriptive Flexfield Segment 16	No
Line Global Descriptive Flexfield Segment 17	No
Line Global Descriptive Flexfield Segment 18	No
Line Global Descriptive Flexfield Segment 19	No
Line Global Descriptive Flexfield Segment 20	No
Comments	No
Notes from Source	No
Credit Card Token Number	No
Credit Card Expiration Date	No
First Name of the Credit Card Holder	No
Last Name of the Credit Card Holder	No
Credit Card Issuer Code	No
Masked Credit Card Number	No
Credit Card Authorization Request Identifier	No
Credit Card Voice Authorization Code	No
Receivables Transaction Region Information Flexfield Number Segment 1	No
Receivables Transaction Region Information Flexfield Number Segment 2	No
Receivables Transaction Region Information Flexfield Number Segment 3	No
Receivables Transaction Region Information Flexfield Number Segment 4	No
Receivables Transaction Region Information Flexfield Number Segment 5	No
Receivables Transaction Region Information Flexfield Number Segment 6	No
Receivables Transaction Region Information Flexfield Number Segment 7	No
Receivables Transaction Region Information Flexfield Number Segment 8	No
Receivables Transaction Region Information Flexfield Number Segment 9	No
Receivables Transaction Region Information Flexfield Number Segment 10	No
Receivables Transaction Region Information Flexfield Number Segment 11	No
Receivables Transaction Region Information Flexfield Number Segment 12	No
Receivables Transaction Region Information Flexfield Date Segment 1	No
Receivables Transaction Region Information Flexfield Date Segment 2	No
Receivables Transaction Region Information Flexfield Date Segment 3	No
Receivables Transaction Region Information Flexfield Date Segment 4	No
Receivables Transaction Region Information Flexfield Date Segment 5	No
Receivables Transaction Line Region Information Flexfield Number Segment 1	No
Receivables Transaction Line Region Information Flexfield Number Segment 2	No
Receivables Transaction Line Region Information Flexfield Number Segment 3	No
Receivables Transaction Line Region Information Flexfield Number Segment 4	No
Receivables Transaction Line Region Information Flexfield Number Segment 5	No
Receivables Transaction Line Region Information Flexfield Date Segment 1	No
Receivables Transaction Line Region Information Flexfield Date Segment 2	No
Receivables Transaction Line Region Information Flexfield Date Segment 3	No
Receivables Transaction Line Region Information Flexfield Date Segment 4	No
Receivables Transaction Line Region Information Flexfield Date Segment 5	No
Freight Charge	No
Insurance Charge	No
Packing Charge	No
Miscellaneous Charge	No
Commercial Discount	No
Enforce Chronological Document Sequencing	No
Payments transaction identifier	No
Interface Status	No
Invoice Lines Flexfield Number Segment 1	No
Invoice Lines Flexfield Number Segment 2	No
Invoice Lines Flexfield Number Segment 3	No
Invoice Lines Flexfield Number Segment 4	No
Invoice Lines Flexfield Number Segment 5	No
Invoice Lines Flexfield Date Segment 1	No
Invoice Lines Flexfield Date Segment 2	No
Invoice Lines Flexfield Date Segment 3	No
Invoice Lines Flexfield Date Segment 4	No
Invoice Lines Flexfield Date Segment 5	No
Invoice Transactions Flexfield Number Segment 1	No
Invoice Transactions Flexfield Number Segment 2	No
Invoice Transactions Flexfield Number Segment 3	No
Invoice Transactions Flexfield Number Segment 4	No
Invoice Transactions Flexfield Number Segment 5	No
Invoice Transactions Flexfield Date Segment 1	No
Invoice Transactions Flexfield Date Segment 2	No
Invoice Transactions Flexfield Date Segment 3	No
Invoice Transactions Flexfield Date Segment 4	No
Invoice Transactions Flexfield Date Segment 5	No

 

 

 

Data Extract Component Logic

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

Bring Unpaid Sales Invoices from existing Navision ERP to Oracle ERP Fusion.

 

Note: Not required to populate the data in RA_INTERFACE_DISTRIBUTIONS_ALL since we have defined the AutoAccounting Setup.

 

Data to be populated at “RA_INTERFACE_LINES_ALL” Sheet.

  

Oracle FBDI Fields	Description	Legacy System Mapping
Business Unit Identifier	Optional	No specific field available
*Business Unit Name	Name of the Business Unit	No specific field available
*Transaction Batch Source Name	Name of the Transaction Source	No specific field available
*Transaction Type Name	Provide Transaction Type name	No specific field available
Payment Terms	Provide payment terms at which the amount can be received on sales invoice	No specific field available
Transaction Date	Date at which the transaction is created YYYY/MM/DD format should be provided	No specific field available
Accounting Date	The date which the entries were posted to GL	No specific field available
Transaction Number	Number of the sales invoice	No specific field available
Original System Bill-to Customer Reference
Original System Bill-to Customer Address Reference
Original System Bill-to Customer Contact Reference
Original System Ship-to Customer Reference
Original System Ship-to Customer Address Reference
Original System Ship-to Customer Contact Reference
Original System Ship-to Customer Account Reference
Original System Ship-to Customer Account Address Reference
Original System Ship-to Customer Account Contact Reference
Original System Sold-to Customer Reference
Original System Sold-to Customer Account Reference
Bill-to Customer Account Number	Populate Bill-to Customer Account Number	No specific field available
Bill-to Customer Site Number	Populate Bill-to Customer Site Number	No specific field available
Bill-to Contact Party Number
Ship-to Customer Account Number	Populate Ship to Customer Account Number	No specific field available
Ship-to Customer Site Number	Populate Ship to Customer Site Number	No specific field available
Ship-to Contact Party Number
Sold-to Customer Account Number
*Transaction Line Type	Populate “LINE” as transaction type	No specific field available
*Transaction Line Description	Provide line description for the transaction	No specific field available
*Currency Code	Populate the currency code as “EUR”
*Currency Conversion Type	Provide Conversion type as “User” if it is functional currency. Provide Corporate if it is foreign currency.	No specific field available
Currency Conversion Date
Currency Conversion Rate	Provide 1 if we are creating a Sales invoice in ledger currency. Provide appropriate rate if the transaction is in foreign currency.	No specific field available
Transaction Line Amount	Populate the Line amount of the transaction	No specific field available
Transaction Line Quantity	Provide Line Quantity for this sales invoice	No specific field available
Customer Ordered Quantity
Unit Selling Price	Populate unit selling price	No specific field available
Unit Standard Price
Line Transactions Flexfield Context	Create a DFF at line level to concatenate lines with distributions	No specific field available
Line Transactions Flexfield Segment 1	Provide value to concatenate the line information with distributions	No specific field available
Line Transactions Flexfield Segment 2
Line Transactions Flexfield Segment 3
Line Transactions Flexfield Segment 4
Line Transactions Flexfield Segment 5
Line Transactions Flexfield Segment 6
Line Transactions Flexfield Segment 7
Line Transactions Flexfield Segment 8
Line Transactions Flexfield Segment 9
Line Transactions Flexfield Segment 10
Line Transactions Flexfield Segment 11
Line Transactions Flexfield Segment 12
Line Transactions Flexfield Segment 13
Line Transactions Flexfield Segment 14
Line Transactions Flexfield Segment 15
Primary Salesperson Number
Tax Classification Code
Legal Entity Identifier
Accounted Amount in Ledger Currency
Sales Order Number
Sales Order Date
Actual Ship Date
Warehouse Code
Unit of Measure Code
Unit of Measure Name
Invoicing Rule Name
Revenue Scheduling Rule Name
Number of Revenue Periods
Revenue Scheduling Rule Start Date
Revenue Scheduling Rule End Date
Reason Code Meaning
Last Period to Credit
Transaction Business Category Code
Product Fiscal Classification Code
Product Category Code
Product Type
Line Intended Use Code
Assessable Value
Document Sub Type
Default Taxation Country
User Defined Fiscal Classification
Tax Invoice Number
Tax Invoice Date
Tax Regime Code
Tax
Tax Status Code
Tax Rate Code
Tax Jurisdiction Code
First Party Registration Number
Third Party Registration Number
Final Discharge Location
Taxable Amount
Taxable Flag
Tax Exemption Flag
Tax Exemption Reason Code
Tax Exemption Reason Code Meaning
Tax Exemption Certificate Number
Line Amount Includes Tax Flag
Tax Precedence
Credit Method To Be Used For Lines With Revenue Scheduling Rules
Credit Method To Be Used For Transactions With Split Payment Terms
Reason Code
Tax Rate
FOB Point
Carrier
Shipping Reference
Sales Order Line Number
Sales Order Source
Sales Order Revision Number
Purchase Order Number
Purchase Order Revision Number
Purchase Order Date
Agreement Name
Memo Line Name
Document Number
Original System Batch Name
Link-to Transactions Flexfield Context
Link-to Transactions Flexfield Segment 1
Link-to Transactions Flexfield Segment 2
Link-to Transactions Flexfield Segment 3
Link-to Transactions Flexfield Segment 4
Link-to Transactions Flexfield Segment 5
Link-to Transactions Flexfield Segment 6
Link-to Transactions Flexfield Segment 7
Link-to Transactions Flexfield Segment 8
Link-to Transactions Flexfield Segment 9
Link-to Transactions Flexfield Segment 10
Link-to Transactions Flexfield Segment 11
Link-to Transactions Flexfield Segment 12
Link-to Transactions Flexfield Segment 13
Link-to Transactions Flexfield Segment 14
Link-to Transactions Flexfield Segment 15
Reference Transactions Flexfield Context
Reference Transactions Flexfield Segment 1
Reference Transactions Flexfield Segment 2
Reference Transactions Flexfield Segment 3
Reference Transactions Flexfield Segment 4
Reference Transactions Flexfield Segment 5
Reference Transactions Flexfield Segment 6
Reference Transactions Flexfield Segment 7
Reference Transactions Flexfield Segment 8
Reference Transactions Flexfield Segment 9
Reference Transactions Flexfield Segment 10
Reference Transactions Flexfield Segment 11
Reference Transactions Flexfield Segment 12
Reference Transactions Flexfield Segment 13
Reference Transactions Flexfield Segment 14
Reference Transactions Flexfield Segment 15
Link To Parent Line Context
Link To Parent Line Segment 1
Link To Parent Line Segment 2
Link To Parent Line Segment 3
Link To Parent Line Segment 4
Link To Parent Line Segment 5
Link To Parent Line Segment 6
Link To Parent Line Segment 7
Link To Parent Line Segment 8
Link To Parent Line Segment 9
Link To Parent Line Segment 10
Link To Parent Line Segment 11
Link To Parent Line Segment 12
Link To Parent Line Segment 13
Link To Parent Line Segment 14
Link To Parent Line Segment 15
Receipt Method Name
Printing Option
Related Batch Source Name
Related Transaction Number
Inventory Item Number
Inventory Item Segment 2
Inventory Item Segment 3
Inventory Item Segment 4
Inventory Item Segment 5
Inventory Item Segment 6
Inventory Item Segment 7
Inventory Item Segment 8
Inventory Item Segment 9
Inventory Item Segment 10
Inventory Item Segment 11
Inventory Item Segment 12
Inventory Item Segment 13
Inventory Item Segment 14
Inventory Item Segment 15
Inventory Item Segment 16
Inventory Item Segment 17
Inventory Item Segment 18
Inventory Item Segment 19
Inventory Item Segment 20
Bill To Customer Bank Account Name
Reset Transaction Date Flag
Payment Server Order Number
Last Transaction on Debit Authorization
Approval Code
Address Verification Code
Transaction Line Translated Description
Consolidated Billing Number
Promised Commitment Amount
Payment Set Identifier
Original Accounting Date
Invoiced Line Accounting Level
Override AutoAccounting Flag
Historical Flag
Deferral Exclusion Flag
Payment Attributes
Invoice Billing Date
Invoice Lines Flexfield Context
Invoice Lines Flexfield Segment 1
Invoice Lines Flexfield Segment 2
Invoice Lines Flexfield Segment 3
Invoice Lines Flexfield Segment 4
Invoice Lines Flexfield Segment 5
Invoice Lines Flexfield Segment 6
Invoice Lines Flexfield Segment 7
Invoice Lines Flexfield Segment 8
Invoice Lines Flexfield Segment 9
Invoice Lines Flexfield Segment 10
Invoice Lines Flexfield Segment 11
Invoice Lines Flexfield Segment 12
Invoice Lines Flexfield Segment 13
Invoice Lines Flexfield Segment 14
Invoice Lines Flexfield Segment 15
Invoice Transactions Flexfield Context
Invoice Transactions Flexfield Segment 1
Invoice Transactions Flexfield Segment 2
Invoice Transactions Flexfield Segment 3
Invoice Transactions Flexfield Segment 4
Invoice Transactions Flexfield Segment 5
Invoice Transactions Flexfield Segment 6
Invoice Transactions Flexfield Segment 7
Invoice Transactions Flexfield Segment 8
Invoice Transactions Flexfield Segment 9
Invoice Transactions Flexfield Segment 10
Invoice Transactions Flexfield Segment 11
Invoice Transactions Flexfield Segment 12
Invoice Transactions Flexfield Segment 13
Invoice Transactions Flexfield Segment 14
Invoice Transactions Flexfield Segment 15
Receivables Transaction Region Information Flexfield Context
Receivables Transaction Region Information Flexfield Segment 1
Receivables Transaction Region Information Flexfield Segment 2
Receivables Transaction Region Information Flexfield Segment 3
Receivables Transaction Region Information Flexfield Segment 4
Receivables Transaction Region Information Flexfield Segment 5
Receivables Transaction Region Information Flexfield Segment 6
Receivables Transaction Region Information Flexfield Segment 7
Receivables Transaction Region Information Flexfield Segment 8
Receivables Transaction Region Information Flexfield Segment 9
Receivables Transaction Region Information Flexfield Segment 10
Receivables Transaction Region Information Flexfield Segment 11
Receivables Transaction Region Information Flexfield Segment 12
Receivables Transaction Region Information Flexfield Segment 13
Receivables Transaction Region Information Flexfield Segment 14
Receivables Transaction Region Information Flexfield Segment 15
Receivables Transaction Region Information Flexfield Segment 16
Receivables Transaction Region Information Flexfield Segment 17
Receivables Transaction Region Information Flexfield Segment 18
Receivables Transaction Region Information Flexfield Segment 19
Receivables Transaction Region Information Flexfield Segment 20
Receivables Transaction Region Information Flexfield Segment 21
Receivables Transaction Region Information Flexfield Segment 22
Receivables Transaction Region Information Flexfield Segment 23
Receivables Transaction Region Information Flexfield Segment 24
Receivables Transaction Region Information Flexfield Segment 25
Receivables Transaction Region Information Flexfield Segment 26
Receivables Transaction Region Information Flexfield Segment 27
Receivables Transaction Region Information Flexfield Segment 28
Receivables Transaction Region Information Flexfield Segment 29
Receivables Transaction Region Information Flexfield Segment 30
Line Global Descriptive Flexfield Attribute Category
Line Global Descriptive Flexfield Segment 1
Line Global Descriptive Flexfield Segment 2
Line Global Descriptive Flexfield Segment 3
Line Global Descriptive Flexfield Segment 4
Line Global Descriptive Flexfield Segment 5
Line Global Descriptive Flexfield Segment 6
Line Global Descriptive Flexfield Segment 7
Line Global Descriptive Flexfield Segment 8
Line Global Descriptive Flexfield Segment 9
Line Global Descriptive Flexfield Segment 10
Line Global Descriptive Flexfield Segment 11
Line Global Descriptive Flexfield Segment 12
Line Global Descriptive Flexfield Segment 13
Line Global Descriptive Flexfield Segment 14
Line Global Descriptive Flexfield Segment 15
Line Global Descriptive Flexfield Segment 16
Line Global Descriptive Flexfield Segment 17
Line Global Descriptive Flexfield Segment 18
Line Global Descriptive Flexfield Segment 19
Line Global Descriptive Flexfield Segment 20
Comments
Notes from Source
Credit Card Token Number
Credit Card Expiration Date
First Name of the Credit Card Holder
Last Name of the Credit Card Holder
Credit Card Issuer Code
Masked Credit Card Number
Credit Card Authorization Request Identifier
Credit Card Voice Authorization Code
Receivables Transaction Region Information Flexfield Number Segment 1
Receivables Transaction Region Information Flexfield Number Segment 2
Receivables Transaction Region Information Flexfield Number Segment 3
Receivables Transaction Region Information Flexfield Number Segment 4
Receivables Transaction Region Information Flexfield Number Segment 5
Receivables Transaction Region Information Flexfield Number Segment 6
Receivables Transaction Region Information Flexfield Number Segment 7
Receivables Transaction Region Information Flexfield Number Segment 8
Receivables Transaction Region Information Flexfield Number Segment 9
Receivables Transaction Region Information Flexfield Number Segment 10
Receivables Transaction Region Information Flexfield Number Segment 11
Receivables Transaction Region Information Flexfield Number Segment 12
Receivables Transaction Region Information Flexfield Date Segment 1
Receivables Transaction Region Information Flexfield Date Segment 2
Receivables Transaction Region Information Flexfield Date Segment 3
Receivables Transaction Region Information Flexfield Date Segment 4
Receivables Transaction Region Information Flexfield Date Segment 5
Receivables Transaction Line Region Information Flexfield Number Segment 1
Receivables Transaction Line Region Information Flexfield Number Segment 2
Receivables Transaction Line Region Information Flexfield Number Segment 3
Receivables Transaction Line Region Information Flexfield Number Segment 4
Receivables Transaction Line Region Information Flexfield Number Segment 5
Receivables Transaction Line Region Information Flexfield Date Segment 1
Receivables Transaction Line Region Information Flexfield Date Segment 2
Receivables Transaction Line Region Information Flexfield Date Segment 3
Receivables Transaction Line Region Information Flexfield Date Segment 4
Receivables Transaction Line Region Information Flexfield Date Segment 5
Freight Charge
Insurance Charge
Packing Charge
Miscellaneous Charge
Commercial Discount
Enforce Chronological Document Sequencing
Payments transaction identifier
Interface Status
Invoice Lines Flexfield Number Segment 1
Invoice Lines Flexfield Number Segment 2
Invoice Lines Flexfield Number Segment 3
Invoice Lines Flexfield Number Segment 4
Invoice Lines Flexfield Number Segment 5
Invoice Lines Flexfield Date Segment 1
Invoice Lines Flexfield Date Segment 2
Invoice Lines Flexfield Date Segment 3
Invoice Lines Flexfield Date Segment 4
Invoice Lines Flexfield Date Segment 5
Invoice Transactions Flexfield Number Segment 1
Invoice Transactions Flexfield Number Segment 2
Invoice Transactions Flexfield Number Segment 3
Invoice Transactions Flexfield Number Segment 4
Invoice Transactions Flexfield Number Segment 5
Invoice Transactions Flexfield Date Segment 1
Invoice Transactions Flexfield Date Segment 2
Invoice Transactions Flexfield Date Segment 3
Invoice Transactions Flexfield Date Segment 4
Invoice Transactions Flexfield Date Segment 5

 

Data Extraction Rules

 Bring Unpaid Sales Invoices from existing Navision ERP to Oracle ERP Fusion.

Data Reconciliation

Receivables data reconciliation will be done with the help of the BI report.

Conversion Approach

The following steps will be followed for loading of data to Oracle.

·        Extract the data and populate it in FBDI Template.

·        Download AutoInvoice Import Template from Oracle OER.

·        Populate the Data in template and convert to CSV files.

·        Go to Scheduled Processes in Fusion and Run “Load Interface File for Import” for “Import AutoInvoice” job and upload the ZIP file. After it was successful run “Import AutoInvoice” job to import the data from interface table to Base Table.

·        Validate the data and change the data as required and generate .CSV file and .ZIP file from template.

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

·        To delete errored record from interface table, run “Purge Interface Tables”.

·        Validate the data if all columns are populated correctly.  

Process Flow Chart of Receivables Invoices Data Migration.

  

FUSION NAVIGATION

1.      Login to Oracle Fusion Applications

2.      From the springboard go to Receivables >> Billing >> Task pane >> Manage Transactions and search for your Sales invoice from User Interface (UI).

Upload Component Logic

Data will be uploaded to Cloud by using Import Auto Invoice FBDI Template.

Data Flow Assumptions/ Prerequisites

Prerequisites, extraction, and upload criteria are mentioned above.

 

Key assumptions are:

 

·        The data of Sales Invoices will be provided by client extraction team into FBDI template.

·        Oracle technical team will generate the data in the required .CSV and ZIP format.

·        All the required configurations have been completed before the program is run.

ü  Please refer to the Prerequisites section for application setup requirement.

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	At present I am providing dummy data in flex fields, but discussion needs to be happened with functional team on what exactly we required in the transaction flex fields.
2	If there are any Memo Lines to be considered, then Functional team will do the configuration for auto accounting.
3	Example Considered the customer PETCO S.R.L. for ship to and bill to but failed due to Auto Accounting setup not done for this customer. We need to consider this while doing the customer conversion.

 

Closed Issues

 

ID	Issue	Resolution	Responsibility	Target Date	Impact Date
1	The business provided data consists of Transaction date of nearly 10 years so period status should be open for them.	Logged an SR with oracle and the SR # 3-34871432891. Oracle provided the solution Transaction/GL Date cannot be earlier than Customer Account Start Date. The interface record's TRX_DATE and/or GL_DATE should be on or after the "Account Established Date".
2
3.
4