Page 1 of 1

Overlapping Range of Accounts

Posted: Fri Oct 16, 2009 5:42 am
by EMANUEL
Hi,

The Oracle Diagnostic reports for period closing has thrown the following error

?ERROR - There are overlapping child ranges and/or children with multiple parents
ACTION - Review the following table to identify the overlapping child ranges. For further information refer to note: 118130.1 ?


Overlapping child ranges

Value Set Name Rollup Group Parent Immediate Parent Low High Immediate Parent Low High
LCC Accounts 230000 231100 231101 231107 231100 231101 231107
LCC Accounts 230000 231200 231201 231205 231200 231201 231205
LCC Accounts 230000 231300 231301 231305 231300 231301 231305
LCC Accounts 230000 231400 231401 231401 231400 231401 231401












on scrutiny I have come across the overlapping ranges of accounts as follows

GRAND SUB CHILD
230000 231000 231100
231200
231300
231400

231100 231101
231102
231103
231104
231105
231106
231107

231200 231201
231202
231203
231204
231205

231300 231301
231302
231303
231304
231305

231400 231401


Please advice how do I correct these and will it have any affect on the TB on any other way?


Rgds
Emanuel