OPPORTUNITY_DATE column defaults to the system date on creation

In Release 9.1, the OPPORTUNITY_DATE column in the YFS_OPPORTUNITY table is mandatory and defaulted to the system date.

How it affects you

Release 9.1 provides a migration script that populates the OPPORTUNITY_DATE column in the YFS_OPPORTUNITY table with the value of CreateTS, when the value is not already defined.

Migration strategy

This section describes the migration process.

Automated migration processes

OPPORTUNITY_DATE is set to CreateTS for all existing entries in the YFS_OPPORTUNITY table using the migrator_opportunity.xml file located in the <INSTALL_DIR>/Migration/9.0/transaction/xmls directory.

Manual migration processes

None.