I understand one can configure ILM Assistant to recommend archiving data on a table-by-table basis.
Obviously, Oracle E-Business Suite has a multitude of interrelated tables. To archive, a business object such as, say, 'invoices,' would require moving quite a few tables, all of which would need to move at the same time in order to retain data integrity.
Would one have to do all this work manually, or will Oracle provide pre-configured scripts that understand the complex EBS schema?
You are correct in that the current version of the ILM Assistant only permits single table management. However, we are aware of the requirement you present and plan to address the need to manage table groups in a future release.
An additional requirement is to pre-wire domain-specific knowledge of the actual EBS schema.
Then it becomes a business problem more than a technical problem - Once legal and business decide on a retention policy for, say, contracts, the IT guy can click-click-click implement the policy, and the auditors can verify compliance at a glance.