Page 1 of 1

Flexfield Structure Changes

Posted: Fri Apr 20, 2007 7:52 am
by anu_uma
Hi All,
Will be useful for Oracle customers seeking assistance with restructuring financials.


There is a third party tool developed by a US company to change the flexfield structure that has been already used by a company.

With the Software tool, we can take the old data with reference to the new flexfield structure.

Its glad to inform you all , that I have been a part of doing the testing before releasing the product.


Visit the Website for details www.flexfieldexpress.com otherwise mail me to know more about it.
For Example : -

Vision Operations Accounting Flexfield
----------------------------------------------------
Company
Department
Account
Sub-Account
Product

We can create following new flexfield to conver the Vision Operations, the structure for new AFF will be as follows:


New Accounting Flexfield
-----------------------------------
Company
Business Unit
Department
Account
Project
Future

We can define following mappings in the product:

Constant Value Mapping
---------------------------------
Future (New Flexfield) "set the default value as" 0000

Segments Mappings
---------------------------
Company (Vision Operations) "maps to" Company,Business Unit (New Flexfield)
Department (Vision Operations) "maps to" Department (New Flexfield)
Account, Sub-Account (Vision Operations) "maps to" Account (New Flexfield)
Product (Vision Operations) "maps to" Project (New Flexfield)

Whatever transactions we have done in vision operations flexfield will reflect in the new flexfield structure and its really amazing...



we can see the change of the flexfield structure - name in the Set of Books.



Regards,

Uma