Editioned columns left on core table following R12.2. upgrade
Hello all
We are running a very large installation of Oracle EBS - HCM, Payroll and OLM.
We have upgraded one of our development instances from R12.1.3 (latested RUP level) to R12.2.6 (running on RDBMS 11.2.0.4). The actual upgrade path was R12.1.3-to-R12.2, and then applied the R12.2.6 patch immediately afterwards.
Whilst we have a number of items reported from the compliance checker script (ADZDDBCC.sql) one of the main issues we have is with a custom index we have on the core HR table PER_POSITION_DEFINITIONS.
Our custom index is on the columns ID_FLEX_NUM, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, and SEGMENT5 of this table (thus mapping the segments that are in use on our Position Key Flexfield).