Oracle Data Conversion

Oracle Data Conversion

[@JohansToyWorld]

Hello Sir, Your videos are really helpful..The way you explain makes your videos unique from other youtube videos. Kindly share a video on approval hierarchy configuration in purchasing and its usage..

[@OracleEbizandFusionVideos]

Sure

[@devenderb498]

Hello Sir, the videos which you are posting is really good, helpful and very clear to understand. Can you please share a video on difference between Approval Hierarchy and Position Hierarchy and its usage and configuration in Payables/Purchasing...

[@narsoft85]

Very well explained. Thank you

[@OracleEbizandFusionVideos]

You are welcome!

[@dhirensamal7635]

Hi Arvind Your videos and documents have been really helpful for me to understand Oracle financials. Do you have any documents or videos for EB TAX set up with multiple scenarios

[@OracleEbizandFusionVideos]

Thanks for your feedback... Hope you are following my complete series of videos on Oracle EBS Financials... As part of this initiative, i will be uploading Videos on EBtax setups in the next few days from now.

[@abhisekhnayak5780]

The way u explain is mind blowing. I have one question, here we upload the trial balance first, in this case does the trial balance contains all the subleder open transaction balance also ?

[@OracleEbizandFusionVideos]

Trial balance is a summary of all ledger balances (including balances of subledger control accounts)

[@abhisekhnayak5780]

As I understood from your replay that the trail balance contains all the balances including subleder transansactions which are not yet transfer to GL aswell.

[@OracleEbizandFusionVideos]

@@abhisekhnayak5780 , Trial Balance is a summary of all balances (including subledger control account balances).... In general, this is extracted from legacy system (in any fresh implementation projects) and then uploaded into Oracle GL as a Web ADI journal

[@abhisekhnayak5780]

@@OracleEbizandFusionVideos thanks a lot

[@kathiravanap9864]

Hi Nice videos and the clarity in the explanation is excellent.I have a query like in " There is a AP invoice which has been already paid but not yet cleared in my bank statement. Cash clearing is enabled and client wants this to be uploaded" How do we achieve this. I wont be able to upload as a open item in the bank statement but at a future date this will be coming into the statement which will need a source payment to knock it off. Would be happy if can clarify

[@OracleEbizandFusionVideos]

One option which i can think of is:- Lets assume that AP invoice for an amount of say 100 dollars is paid but not cleared on Dec 30, 2020 in your legacy system.... You went live with new Oracle system on say Jan 1, 2021... This payment gets cleared and appears in Bank statement on say Jan 2, 2021.... When the Item appears in Bank statement, you might be passing a manual journal entry in GL by Debiting Cash Clearing account and crediting Cash Account... Now you can reconcile Bank statement line with this GL Journal entry line.... Hope this clarifies your question... if not, let me know

[@alirazakazmi1033]

Hello dear. Your videos are really valuables for the beginners and implementers also. one thing may be i am wrong, my suggestion is that when we are uploading the Trial Balance, we should not upload in GL AP liabilities and AR receivables, this will make TB imbalance, yes, however, when we will run transfer to GL from AP and AR, the TB will be balance and there is no need to reverse entries in GL again. and for FA , we should not upload from FA module, rather in GL directly, but the FA module data should match with GL. do you agree? or appreciate if you can correct me.

[@OracleEbizandFusionVideos]

In general, in any implementation project, you get TB from the legacy system of your customer... You should upload entire trial balance as is within GL...if you think logically, if you take out just AP liaibility and AR receivables from TB, TB will be unbalanced... you should not upload unbalanced TB into GL

[@shiahaq9191]

@@OracleEbizandFusionVideos yes you are right. However system allows unbalance JV too. This is useful for opening TB without Liability and receivables. When Liability and receiveables are transfered, then we get our TB balanced . please comment

[@OracleEbizandFusionVideos]

@@shiahaq9191 There are different ways for data conversion..... but based on my experience, i had never seen scenarios wherein we edit the trial balance given to us by customer (i.e. removing the AP liability account and AR receivable account) and uploaded in Oracle

[@sourabhsahu1308]

Keep it up!

[@OracleEbizandFusionVideos]

Thanks for your feedback...

[@KumR]

Good One Arvy. For FA , which report we can use to verify if conversion is done ?

[@OracleEbizandFusionVideos]

You can use Asset Cost Additions report

[@kalyanachakravarthy4047]

Hi, It was a nice video. Could you show about the historical data conversion. Also the order o the various modules for which the conversion should take place>

[@OracleEbizandFusionVideos]

In general Subledger transactions should be entered first and then GL...What do you mean by Historical data conversion? Can you elaborate

[@kalyanachakravarthy4047]

@@OracleEbizandFusionVideos Historical transactions. E.g is there any scenario where the requirement will be to enter last 3 years or more data into the system Second which module data would be transferred first eg HR, PaYRoLl, INV etc during conversion. To be frank I have not done end to end implementation and hence these queries.

[@OracleEbizandFusionVideos]

In general, open transactions (irrespective of the data from when its open) would be entered in subledgers i.e. transactions which are not yet paid in AP or received in AR.... If the transaction is already paid or received, then in general we do not do data conversion of those transactions.... Regarding sequence:- if you take P2P cycle as an example, then at first inventory items needs to be entered in system, then perform data conversion of Open PO's and then Open AP invoices

[@lalitbarhate3967]

Hello Sir, I have one question. Migrate Open AP invoices means to create invoice in New system ?

[@OracleEbizandFusionVideos]

Yes, thats correct

[@911wtfdude]

If you make a partial payment to an invoice,do you upload that invoice to the extent it is due in the new instance?

[@OracleEbizandFusionVideos]

Yes, there are two approaches:- Approach 1:- Upload only the outstanding amount in new system Approach 2:- Upload entire invoice and then make a dummy payment for the amount which was already paid in the old system

[@911wtfdude]

@@OracleEbizandFusionVideos Thank you for the answer.

[@KumR]

Hi Arvy - If some PO are received but not invoiced in legacy , how can we handle this in Oracle?

[@OracleEbizandFusionVideos]

so, it would be scenario of data conversion of Open PO's. This Open PO needs to be brought into Oracle as part of Purchasing Open PO data conversion activity

[@km0p]

Hi Arvind, Are all ar invoice lines to be converted or only summary? The best approach ? Pointers to consider in each approach please?

[@OracleEbizandFusionVideos]

Its suggested to bring over all AR Invoice lines from Legacy system into Oracle as part of data conversion... Couple of reasons:- 1. From reporting perspective, you need to all the lines with all the item details 2. This is also required if you are doing Line level receipt application

[@pavanvasireddy7631]

Hi Sir, I am new to learning Oracle, I have one doubt as you said we can upload historical GL TB in form journal in to GL so what is the JE (2) directly why can't upload into sub ledger instead of GL and why we need to reverse sub ledger je in gl...pls pls reply

[@OracleEbizandFusionVideos]

Please understand this from Accounting perspective:- 1. We need to upload GL Trial Balance so that all the balances including Expense account, AP Liability account would be reflected in GL Balances. 2. We are uploading the Open subledger transactions in subledger so that we can make the payment against the corresponding AP open invoice or create a receipt against corresponding AR open Invoice. When you run Create Accounting in AP, this invoice accounting entry would be pushed to GL, and we need to reverse this as the effect of this accounting entry is already reflected in opening GL Trial Balance which was uploaded. If we do not reverse this entry, then there would be duplicate accounting impact

[@pavanvasireddy7631]

@@OracleEbizandFusionVideos thanks sir.. what is the journal entry for in GL

[@OracleEbizandFusionVideos]

Trial Balance from Legacy System would be uploaded as Journal entry in GL.

[@arunsircar4342]

Very good video. Lots of information. Can you please elaborate on FA conversion? Should be not bring in WDV of assets instead of Cost of FA and accumulated depreciation? Either way, can you please suggest the steps to do that?

[@OracleEbizandFusionVideos]

Yes, you can bring in WDV of Assets instead of Cost of FA and Accumulated depreication...but with this approach, if for any reporting reason you want to know the original cost of the asset, then it might not be possible in Oracle and then you need to refer to Legacy system

[@arunsircar4342]

@@OracleEbizandFusionVideos Agreed. In that case I have two questions for you. a) What are the exact steps for FA to bring in asset cost original and accumulated depreciation? b) How do you bring in Open Bank Statements? What is the exact process or steps? Thanks, Arun

[@OracleEbizandFusionVideos]

Add a FA Asset with original cost and accumulated depreciation... Run Create Accounting and transfer entries to GL and reverse these entries in GL as these would have been already considered in opening TB upload in GL

[@OracleEbizandFusionVideos]

Open Bank Statements can be manually entered or you can bring them over via Bank statement interface

[@arunsircar4342]

@@OracleEbizandFusionVideos Ok, but how do I make sure that only the bank lines that are not reconciled are brought over?

[@shabeermohammad719]

Thank you

[@OracleEbizandFusionVideos]

You're welcome

[@venkatsundar84]

Hi Are there any drawbacks in loading the trial balance as the last activity?. What i am referring to here is load all conversion data, create accounting, reverse the accounting entries and then run trial balance. Appreciate your help and quick response in this regard as i am in the middle of an implementation.

[@OracleEbizandFusionVideos]

Hi, there is no harm in loading trial balance as the last activity...

[@arunbbm96]

Can you clarify my doubt on Asset Migration, When we migrate the assets, in case there are cost adjustment or life changes due to that there is a change in depreciation and accumulated depreciation in legacy environment. Now if I import those assets how can I handle this... My understanding is that only original asset cost is considered. Also throw some lights on different depreciation methods impacts in migration. Please clarify

[@OracleEbizandFusionVideos]

If i understand correctly, change in life or cost adjustments are already happening in your scenario in legacy environment, so when you are migrating these assets to Oracle, specify the updated accumulated depreciation and update life so that the calculations are right going forward in Oracle

[@raghuraghu-hi7qm]

aravind, is that this one means both migration and converstion are same meaning

[@OracleEbizandFusionVideos]

Yes... These are the two words which are used interchangebly

[@nkaur7609]

Hi,Can you please explain for GL data conversion, how does business decide whether they should load beginning, ending or period activity account balances from legacy system to Oracle. What is the best approach? how to decide it?

[@OracleEbizandFusionVideos]

Scenario 1:- Client goes live at the start of Financial year:- Beginning balance as at the start of the financial year are loaded Scenario 2:- Client goes live during the middle of the Financial year:- Beginning balance as at the start of the financial year are loaded and then period end balance for each of the periods from start of financial year upto the period of Go live period are loaded

[@KumR]

Hi Arvy - Is there a particular order of modules the conversion gets done ? Like first GL , then AR , AP, etc ?

[@OracleEbizandFusionVideos]

In general, conversion needs to be done at first for subledgers and at last GL

[@jampanavamsi]

Hi Mate Thanks so much for your videos. Today only i have seen ur video by searching for AGIS. Do u have any knowledge with regard to Year End Closure in GL. What are the Accounts we need to transfer to the Next Year like that.

[@OracleEbizandFusionVideos]

Hi Vamsi, i had already created a video on GL Period close in my channel. You can refer the same. As far as year end is concerned, once you open the first period of next year, system will transfer the net of income and expenses to retained earnings account.

[@MsRonyrony]

hi is there a specific sequence in which setups, master & setup data. I am trying to locate the sequence but unable to find it.

[@OracleEbizandFusionVideos]

Are you looking for the sequence of setups from Data Conversion perspective or from implementation project perspective?

[@majidnayyer8108]

First Masters Data like Supplier, Customers, Bank Information Then Transaction data. You can upload the Transaction data without having Masters data into the system.

[@pavanKumar-r8y8h]

Hello Sir, How to do reconciliation that all transactions uploaded or not from legacy system to AP

[@OracleEbizandFusionVideos]

It would be a manual process. Run a extract/report from you Legacy system detailing the list of all Open AP Invoices along with dollar value and then run a backend query from Oracle AP detailing all Open AP Invoices along with dollar value... Once you have these two reports in excel, then you can do a simple Vlookup to find out if there are any variances

[@pavanKumar-r8y8h]

@@OracleEbizandFusionVideos Hi Sir, thanks for the reply, I am new to learn the oracle, may I know the backend process procedure or Which SQL we need to run...can you pls elaborate in detail.. Thanks in advance.

[@Raj-xw1lv]

Hi sir If I will reverse the subledger accounting entries in GL then drill down functionality will not work.. If any one want to knw the more information about Liablitity open balance then we always go for account analysis drill down and entered in subledger transactions but after reversing the entries we cant follow this path..

[@OracleEbizandFusionVideos]

Please ensure note that this reversal of Subledger accounting entries in GL should be done only during Data Conversion. I do not think users will be ever interested in drilldown functionality for Data conversion entries.

[@srilakshmichinnumchetty7831]

Arvind Can you do Data Conversion in Fusion.?

[@OracleEbizandFusionVideos]

Yes, in general, Data Conversion is required for any new implementation.... Whether it could be moving from Legacy system to EBS or Legacy system to Fusion

[@SandeepYadav-bm4kx]

Hi How do you unfreeze the journal source for reversal ?

[@OracleEbizandFusionVideos]

Navigate to General Ledger Superuser --> Setup --> Journal --> Sources --> Query for concerned journal source and then set Freeze Journals value as No

[@mallimalli2156]

Bank information can i convert into oracle, if possible how we can do, kindly explain me..

[@OracleEbizandFusionVideos]

When you say bank information, are you referring to internal banks, bank branches and bank accounts?

[@mallimalli2156]

@@OracleEbizandFusionVideos yes, if once converted where bank information was store

[@OracleEbizandFusionVideos]

@@mallimalli2156 There are oracle standard API's through which you can import this information. You can search for API's on Oracle metalink support portal