Home » Applications » Oracle Fusion Apps & E-Business Suite » Data conversion Strategy
Data conversion Strategy [message #196865] Sun, 08 October 2006 16:55 Go to next message
Messages: 1
Registered: October 2006
Junior Member

1)Data Conversion for Open Invoices, Any solutions?

We are planning to reimplement our financials from 11.57 to 11.5.10(not, not an upgrade but reimplementation, as if we are moving form legacy to oracle). The reason being there is too much data corruption happening in the existing 11.5.7 due to wrong setups, clean up the business processes etc.etc.
We are going thru our data conversion strategy and ran into a bottleneck.

We are bringing in all unpaid invoices thru open interface table, Is there any other Approach other than this?

2)Data Conversion for Partially Paid Invoices, Any solutions?

we cannot bring partially Paid Invoices through gateway since it is very difficult identify the lines which have been paid. Is there any Approach for this?

3) Data Conversion for Fully Paid Invoices, Any solutions?
really do this for PAID invoices.

Did any one ever bring over paid informaiton, if so, did you do direct table updates, and if so, did you recreate the PK/FK ID's? Now, my concern is this might make us lose Oracle support, due to the fact that paid information is being populated into almost all of oracle tables with ID's that could cause data corruption?

Any thoughts/suggestions are greatly appreciated.
Re: Data conversion Strategy [message #218581 is a reply to message #196865] Thu, 08 February 2007 15:22 Go to previous message
Messages: 1
Registered: February 2007
Junior Member

To bring the partially paid invoices, we migrated the Invoice with legacy amount(total), and any amount paid against this invoice ( applying Credit Memo / Receipt) can be converted as a single Receipt with to balance the amount.

As part of this, If a credit memo is partially applied we brought only open amount for a credit memo. This would reconcile with the legacy aging report.

B) If the line details is not mandatory, just bring the open amount for that invoice with a memo line approach.

Yes, we can convert fully paid invoices, But it is risky and should be phased approach.

Bring the Open Invoices / Credit Memo / Debit Memo with the legacy amounts

Bring the Applied Credit Memo / Demit Memos

Bring the Receipts as it is

Step4 : Only apply the receipts against the invoices without creating. need a separate extraction for the amount being applied on each invoice.

Hope this is helpful..

Sravan Kumar Daggupati

Previous Topic: Contract to Employee
Next Topic: Sales Order Line
Goto Forum:

Current Time: Sun Oct 23 07:06:21 CDT 2016

Total time taken to generate the page: 0.05350 seconds