While Performing Data Migration from Legacy system to Oracle what are the requisites you will perform as a functional consultant for GL, AP, AR, and PO.

Answer Posted / tgs100

First and important step is to prepare the data template. We need to include all the required fields and also we should mention
1. which are all the mandatory fields
2. available values in case of LOV
3. If one field depends on the value of another field
4. Restrictions on size and format of the field, if any, etc

After data collection, we need to do preliminary validation if data is given in excel format. Also we can write few important validations in the code before the data is imported to staging/temporary table.

I usually pick one or two records from the excel file and enter manually in the Oracle apps (then I will delete those records from the excel file) to check if everything is ok.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to do customization while doing oracle implementation. what is the role of functional consultant in customization?

2165


While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.

2282


Invoice Approval Process?

2779


What is the use of hr: user type, while configure multiorg?

691


1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?

3391






can we define 2 different currency revaluation at a time??

1891


Payables Applications Technical Reference Manual

2022


what is the difference between before pages trigger and after parameter trigger in reports ?

1943


what is VAT claim process?

2089


We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

2145


What is the entry in oracle apps ap,ar,gl for following transations1.one pipe purchase at rs.1002.one pipe sales at rs.150

972


What is difference between primary and secondary ledger

601


What kind of budgets have you worked on?

1868


can any one tell me what exactly functional consultant do on daily basis? client requirements?

515


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

1775