Written by Helene Abrams Wednesday, December 19 2007
There are many reasons for separating data – each has its own challenges and business considerations. The first step in the process is to determine the business requirement, then find the relevant data, determine the criteria for filtering the data out, and determine what happens to the filtered data. Suppose for example, that you want to separate the data because your company has decided to sell off a division. Division is a segment in your accounting flexfield, so maybe you just determine the segment value of the division to be sold off, identify all the code combinations that have the value for that division, and then find all the tables that have the relevant code combination ID. Oh, you say, that’s easy. I can just write a select statement with a where clause (for division number 100) and my Oracle Applications will be separated. Not so fast. It’s not as easy as it sounds because all the transactions cannot be filtered easily based on the above condition.






