Allocation Lookup Table Enhancements
VARCHAR domain columns are now allowed in the Allocation Lookup table. Data Redaction is also handled in all the PI columns present in an Allocation Lookup table.
The Allocation Lookup Tables now support Scheduler based components for lookup table Data Loading and lookup table Data Deletion. The Help button at the bottom of the Lookup screen provides the sample .CSV file to be used to upload the Allocation lookup table data in Object Store.
Auto Partition - Whenever an Allocation Lookup table is created with As-of-Date column present in it, the table is registered with Partition created on the As-of-Date column. This Auto Partition in turn supports the Data Retention "Drop Partition" policy on these tables.
A toggle button is added to the Lookup Table Data screen to toggle between Physical column names and Logical column names in the grid. When exported, the downloadable file gets generated with the Physical or the Logical Column Headers based on selection from this toggle button.
Enhances the usability of Allocation Lookup tables.
Steps to enable and configure
You don't need to do anything to enable this feature.
Tips and considerations
Regression Testing Recommended.
Key resources
https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html