Adding New Columns to GTT or RM Tables
To add new columns to GTT and RM tables:
- 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.
- Add the new columns to the replica table in the custom schema.
- Grant the new table access to the out-of-the-box BIP schema.
- Create a synonym for this object (public synonym). The BIP schema can access this new object.
- Modify the user exit package corresponding to this GTT to fill in the new custom table and logistics to load the additional two columns.
Parent topic: Extending using Custom Objects