Chartfield Reconfiguration

 When [Customer] upgraded to Financials 9.1, it was suggested by the consultant at the time to make the Class Field a field that was not needed, due to the fact that we do not use this field.  The consultant instructed the [Customer] to finish out the fiscal year and then inactivate it at the beginning of the next fiscal year, which is what the [Customer] did.  This has not caused any problems until now.  While running the Final Alter Audits, the scripts generated for the various Ledger tables abend with the message of a duplicate key.

While researching out the reason for the abend, it was discovered that the index attempting to be generated (BUSINESS_UNIT,   LEDGER,   ACCOUNT,   DEPTID,   FUND_CODE,   PROGRAM_CODE,   AFFILIATE,   AFFILIATE_INTRA1,   PROJECT_ID,   BOOK_CODE,   GL_ADJUST_TYPE,   CURRENCY_CD,   STATISTICS_CODE,   FISCAL_YEAR,   ACCOUNTING_PERIOD)  cannot be created since the old index (BUSINESS_UNIT,   LEDGER,   ACCOUNT,   DEPTID,   FUND_CODE,   PROGRAM_CODE,   AFFILIATE,   AFFILIATE_INTRA1,   PROJECT_ID,   BOOK_CODE,