Adding New Columns to GTT or RM Tables

To add new columns to GTT and RM tables:

1. Create a replica of the GTT in the custom schema. For example, if the customer needs new columns in the GTT_RPT_AGG_CASE table, create the replica of this table in the custom schema, named XX_ GTT_RPT_AGG_CASE.
2. Add the new columns to the replica table in the custom schema.
3. Grant the new table access to the out-of-the-box BIP schema.
4. Create a synonym for this object (public synonym). The BIP schema can access this new object.
5. Modify the user exit package corresponding to this GTT to fill in the new custom table and logistics to load the additional two columns.