Skip to main content

Posts

Showing posts with the label Data Migration

Data Conversion vs. Data Migration: What’s The Difference?

In the past I have worked as Migration lead and now I am working as conversion lead for one of the ERP implementation project. As having worked on both(migration/conversion) this is an effort to put forward the difference between migration and conversion. The terms  Data Conversion  and data migration are still sometimes used interchangeably on the internet. However, they do mean different things. Data conversion is the transformation  of data from one format to another. It implies extracting data from the source,  transforming  it and loading the data to the target system based on a  set of requirements . Data Migration  is the process of transferring data between silos, formats, or systems. Therefore, data conversion is only the first step in this complicated process. Except for data conversion, data migration includes data profiling, data cleansing, data validation, and the ongoing data quality assurance process in the target system. Both terms are ...

Accumulated depreciation or YTD depreciation projection as of specific period end.

Oracle by default does not maintain future depreciation information (Accumulated or YTD) as depreciation could change as per cost adjustment, addition or asset retirement. Often there will be requirement to write a function or package that returns YTD depreciation or Accumulated depreciation as of year-end or specific period(In this example it is Dec 2017) for example Accumulated depreciation as of Dec 2017, YTD depreciation as of Dec 2017 and remaining depreciation period for asset after Dec 2017. Over here I had requirement to get Asset depreciation as of Dec 2017 for  Workday Financial Conversion . Following is the function that returns depreciation as of certain period. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 ...