Can code combinations be deleted or purged ?
It is not possible to delete or purge the account code combinations and segment values. You can only end date the combinations and segment values. The reason why it is not possible is that all applications that interface journals to GL could potentially use the combinations and you cannot remove a combination if it is used in a transaction. Currently there is no process to determine if a code combinations is still referenced in any part of the EBS application. Additionally, programs like translation check all the old values back to the earliest ever transaction in a separate table that stores the code combinations. Also transactions that used the code combination are stored and still referenceable in the subledgers, etc. There is currently an open enhancement request Bug 536423 GOLD CLIENT NEEDS TO BE ABLE TO PURGE GL_CODE_COMBINATIONS.