Data Conversion in Oracle Cloud

Data Conversion is a process of moving required volumes of data from our clients' existing systems to Oracle

Points to note

• Convert Master Data as well as Transactional Data
• The conversion of closing balances data as on Cut Off Data in the form of journals in Oracle General Ledger
• Conversions of open transaction as on Cut Off Date into Oracle Subledger modules like Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing and Inventory.
• Import of Oracle Subledger Module data into Oracle General Ledger and reversing those entries in GL.

Summary of what we convert by module

Module	Conversion Data
AP	Supplier/ Supplier Sites Master
AP	Open Invoices, Debit Memos/Credit Memos and Prepayments
AR	Customer Master
AR	Open Customer Invoices, Debit Memos and Credit Memos and Unapplied Receipts
CM	Bank Master
CM	Open Bank Statement Lines
FA	Fixed Assets Balance
PO	Open Purchase Orders
PO	Employee Master
INV	Item Master
INV	Opening Balances – Quantity and Price
GL	Account Balances

Data Conversion EBS Vs Cloud using FBDI Templates

No technical work is involved in Fusion for Data conversion. The below high level process is followed for all activities like AP, AR, Journals conversion or asset conversions in Cloud using FBDI templates.

Steps	EBS Data Conversions	Steps	Fusion Data Conversion
1	Create Data Templates	1	Download templates from Oracle OER(Oracle Enterprise Repository)
2	Collect Data	2	Collect data from Business
3	Share with Technical	3	Create CSV files from data template
4	Convert into CSV	4	Upload CSV files into UCM(Universal Content Management)
5	Create Staging Tables	5	Populate data into interface tables
6	Coding	6	Import data into base tables
7	Populate data into staging tables from CSV
8	Validation
9	Populate data into interface tables
10	Import data into base tables

Some important seeded roles in Oracle Fusion

 

Role Title	Role Name
Accounts Payable Manager	AP_ACCOUNTS_PAYABLE_MANAGER_JOB
Accounts Payable Specialist	AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB
Accounts Payable Supervisor	AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB
Accounts Receivable Manager	AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB
Accounts Receivable Specialist	AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB
Asset Accountant	FA_ASSET_ACCOUNTANT_JOB
Asset Accounting Manager	FA_ASSET_ACCOUNTING_MANAGER_JOB
Billing Manager	AR_BILLING_MANAGER_JOB
Billing Specialist	AR_BILLING_SPECIALIST_JOB
Buyer	PO_BUYER_JOB
Cash Manager	CE_CASH_MANAGER_JOB
Chief Financial Officer	GL_CHIEF_FINANCIAL_OFFICER_JOB
Controller	GL_CONTROLLER_JOB
Expense Audit Manager	EXM_EXPENSE_AUDIT_MANAGER_JOB
Expense Auditor	EXM_EXPENSE_AUDITOR_JOB
Expense Manager	EXM_EXPENSE_MANAGER_JOB
Financial Analyst	GL_FINANCIAL_ANALYST_JOB
Functional Setups User	ASM_FUNCTIONAL_SETUPS_USER_ABSTRACT
General Accountant	GL_GENERAL_ACCOUNTANT_JOB
General Accounting Manager	GL_GENERAL_ACCOUNTING_MANAGER_JOB
Inventory Manager	INV_INVENTORY_MANAGER_JOB
IT Security Manager	FND_IT_SECURITY_MANAGER_JOB
Order Manager	DOO_ORDER_MANAGER_JOB
Procurement Manager	PO_PROCUREMENT_MANAGER_JOB
Procurement Preparer	POR_PROCUREMENT_PREPARER_ABSTRACT
Procurement Requester	POR_PROCUREMENT_REQUESTER_ABSTRACT
Revenue Analyst	AR_REVENUE_ANALYST_JOB
Revenue Manager	AR_REVENUE_MANAGER_JOB
Tax Accountant	ZX_TAX_ACCOUNTANT_JOB
Tax Administrator	ZX_TAX_ADMINISTRATOR_JOB
Tax Manager	ZX_TAX_MANAGER_JOB
Tax Specialist	ZX_TAX_SPECIALIST_JOB

Sequential Numbering (Document Sequence) in EBS GL

This is used to assign unique numbers to the Oracle concepts. Sequential number can be called voucher numbers or document category. I have explained the steps which are required to setup a document sequence for Journals in GL.

Define profile option sequential numbering at responsibility level

N: System Admin -> Profile -> System
Enable Responsibility: KT GL Super user
Profile: %Seq%numb%           ->Find

Profile Option Name	Site	Application	Responsibility	User
Sequential Numbering	Not USed		Partially Used

Save and close.

Define Sequential Numbering

N: System Admin -> Application -> Sequential Numbering ->Define

Name	Application	From	To	Type	Message	Initial Value
KT Exp	General Ledger	1-Apr-18		Automatic	√

Save and close.

Assign Sequential Numbering to the Category

N: System Admin -> Application -> Sequential Numbering ->Assign

Application	Category	Ledger	Method
General Ledger	Expenditures	KT PL	Manual
General Ledger	Expenditures	KT PL	Automatic

 

Go to Assignment tab

Application	Category	Start Date	End Date	Sequence
General Ledger	Expenditure	1-Apr-18		KT Exp
General Ledger	Expenditure	1-Apr-18		KT Exp

Save and post.

Enter Journal to check the result

N: GL -> Journals -> Enter      ->New Journal
Journal : Sequential Num Test                                   Category:Expenditure

Come to Lines

Line	Account	Debit	Credit
1	01.00.00.00.7420	40000
2	01.00.00.00.2210		40000

 Save.

One Popup window will come up i.e Sequence Number    ->Ok
Document Number: 1
Post and close the window.

Points to Note:

At Sequence

Automatic: General Ledger sequentially assigns a unique number to each document as it is created

Gapless: General Ledger sequentially assigns a unique number for each document, but ensures that the document was successfully generated before assigning the number.

Manual: The user must assign a number to each document when it is created. You must enter unique values. Sequential ordering and completeness are not enforced.

Assignment

Automatic: Assign sequential numbers to journal entries created automatically by General Ledger. Do not assign sequences defined with a manual numbering type to an automatic creation method.
Manual: Assign sequential numbers to journal entries you enter manually using the Enter Journals window.
Null = transactions can be created either Automatically or Manually