Configure Alphanumeric Dimensions

To configure a numeric dimension as alphanumeric and to remove the optional code attribute from prior releases, you should back up the affected dimension tables (like REV_DIMENSIONS_B, REV_DIM_ATTRIBUTES_B, REV_DIM_ATTRIBUTES_TL, and DIM_<DIMENSION>_ATTR) and perform the following steps on each applicable dimension.

1. 1. Set the member type as alphanumeric (VARCHAR2) in REV_DIMENSIONS_B and identify the member table’s alphanumeric code column name, if it is not populated already using the following code:
   Update REV_DIMENSIONS_B SET Member_Data_Type_Code = ’VARCHAR2’ [, Member_Code_Column = ‘{Alphanumeric Column Name}’] Where Dimension_ID = {Dimension ID}
   Example:
   Update REV_DIMENSIONS_B SET
   Member_Data_Type_Code = 'VARCHAR2', Member_Code_Column = 'TP_PRODUCT_CODE' Where Dimension_ID = 5;

   Note:

   In OFSAAI 8.1.x, the seeded key dimensions have already populated MEMBER_CODE_COLUMN.
2. In case, any rows in the Dimension member table contain a null alphanumeric code, you can populate the Numeric Member ID itself as alphanumeric member code as illustrated in the following example. This is to ensure that there is no null value for the Alphanumeric Member Code:
   Update DIM_GENERAL_LEDGER_B set GL_Account_Code = GL_Account_ID Where GL_Account_Code is null; Commit;
3. 
   
4.