Is the Table EXCEL_MAPPING_MASTER Updated During the OFSAA 7.2.10 -> 7.3.x Upgrade? (Doc ID 1992885.1)

Last updated on MARCH 24, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.3.0 and later
Information in this document applies to any platform.

Goal

While checking upgrade from 7.2.10 to 7.3 it was discovered that records were updated on the EXCEL_MAPPING_MASTER table.  The column V_EXCEL_NAME was updated as follows:

"0-LKP_PNCB_ALLOC_TABLE_DTL_template.xls" to "0-0-LKP_PNCB_ALLOC_TABLE_DTL_template.xls"

This table was not manually updated by any of user process.  Which part of the upgrade from OFSAA 5.6 -> 6.1.0.3 did this change and why? There is a backup table EXCEL_MAPPING_MASTER_BKP72 with the correct records so it is suspected something on the upgrade from 7.2.10 to 7.3 did the update. There are other tables with this prefix (_BKP72) on the CONFIG schema too.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms