2.1 Pre-installation Requirements

The prerequisites are as follows:

• Ensure that you have OFS LRS version 8.1.2.0.0 as the minimum patch set level.
• Login to My Oracle Support (MOS), download and install the OFSAAI v8.1.2.6 ML release (ID: 36895538)
• Ensure that you remove any tables or attributes that are added manually in the atomic schema.
• To resolve the Primary Key and Not Null Column changes in specific tables, follow these steps:

  Table 2-1 Pre-installation Steps to resolve Primary Key and Not Null Column changes

  Step No.	Pre-installation Steps	Example
  1	Create a backup table of each of the following Tables if you upgrade from OFRLRS 8.1.2.1.0 or 8.1.2.2.0: STG_PARTY_PARTY_RELATIONSHIP FCT_PARTY_PARTY_RELATIONSHIP STG_GL_DATA Create a backup table of only the following Table if you upgrade from OFSDF 8.1.2.4.0: STG_GL_DATA	The backup table of STG_GL_DATA can be STG_GL_DATA_LRS_8126_BKP
  2	Truncate the Original Table.	Truncate the STG_GL_DATA.

• If the upgrade is from 8.1.2.2.5 to 8.1.2.6.0 take the backup of the table STG_INVESTMENTS into STG_INVESTMENTS_LRS_8126_BKP.

  Note:

  If you have defined any custom run purpose, ensure to take a backup of the tables FSI_LRM_LOOKUP_TL and FSI_LRM_PROCESS_PURPOSE_MAP, before you install the ML.

  Note:

  Starting in September 2020, OFSAA Application Minor releases out-of-the-box (OOB) data models using the latest Erwin Data Modeler version. The new Erwin Data Modeler version supported is 2020 R2. Provided a roadmap of the Erwin Data Modeler versions usage for the OFSAA out-of-the-box Data Models in the MOS Doc ID 2725208.1.