Post-installation steps for 8.1.2.2.0 One-off patch

Perform the following post-installation steps:

1. OFS LRS 8.1.2.2 needs additional attributes in the Data Model. Extend OFS LRS 8.1.2.2 Data Model with the following attributes.

   Note:

   These columns are regularized as part of next available OFS LRS ML/IR Release.

   Table 2-1 Data Model Attributes for 8.1.2.2.0 release

   Physical Table Name	Column Name	Logical Name	Data Type	Domain	Null Allowed?	PK	FK	Reference Table Name	Reference Column Name	Column Comments	Bug ID
   FCT_LIQUIDITY_REP_LINE_COMMENT	V_REP_LINE_COLLECTIONS	Reporting Line Collections	VARCHAR2(2000)	Text_Message	Yes	No	No			This attribute stores reporting line collections	34528157
   FSI_REP_LINE_COMMENT	V_REP_LINE_COLLECTIONS	Reporting Line Collections	VARCHAR2(2000)	Text_Message	Yes	No	No			This attribute stores reporting line collections	34528157
   FSI_REG_APP_OUTPUT	F_BASEL_CAPITAL_ELIG_FLAG	Basel Capital Eligibility Flag	CHAR(1)	Flag	Yes	No	No			This column stores the flag to indicate whether the instrument is eligible to consider for capital calculation as per Basel guidelines	34311155
   FSI_REG_APP_OUTPUT	F_ELIG_TLAC_INSTR_FLAG	Eligible Total Loss Absorbing Capacity Instrument Flag	CHAR(1)	Flag	Yes	No	No			This column will be used to indicate if the instrument meets all the eligibility criteria of a total loss absorbing capacity instrument.These eligiblity criteria are jurisdiction specific.This will be a download column and will have list of values as Y or N.	34311155
   FSI_LRM_REP_LINE_DTLS	V_LOB_CODE	Line Of Business Code	VARCHAR2(20)	DESCRIPTION	Yes	No	No			Line of business (LOB) is a functional unit that offers the financial entity's products to the customer. Example: Corporate Finance, Trade Services, Private Wealth Management, Treasury Services, Retail Banking, Cards services etc. This column stores the unique code of the line of business applicable to the respective product.	34487217
   FSI_LRM_INSTRUMENT	N_PERPETUAL_MAT_TB_SKEY	Perpetual Maturity Time Bucket Surrogate Key	NUMBER(10)	SurrogateKey_Long	Yes	No	No			Stores the Perpetual Maturity Time Bucket Surrogate Key. This attribute is derived by the app based on based on Embedded options flag and Convertible Options Indicator for a certain set of identified products under Investments and Borrowings	34481885

2. Resave the hierarchies HLCOM012, LRMLA011, and LRMLA012.