Age Bands are assigned incorrectly
Last updated on OCTOBER 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
For few employees in the system, the Age Bands are being calculated incorrectly. They all seem to be off by one. For example of someone whose fact record shows AGE_IN_MONTHS of 719, yet the person is put into the band starting at 720.
Scenario I: In the below examples, each person is put into the wrong age band. The first one turned 40 in August and should be in the 40-55 Years band. The second one turned 55 in August and should be in the 55-60 Years age band. The general standard is that a number that is on the border of a band goes into the higher band.
|EMPL_ID||BIRTH_DATE||AGE BAND in OBIA for 2016||AGE BAND should be|
|XXX||21-AUG-1976||30-40 Years||40-55 Years|
|YYY||28-AUG-1961||40-55 Years||55-60 Years|
Scenario II: And, in some cases, the age band is assigned to the next interval as explained in the below example.
|EMPL_ID||BIRTH_DATE||AGE BAND in OBIA for 2013||AGE BAND should be|
|ZZZ||10-JAN-1954||>=60 Years||55-60 Years|
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms