PRP 34858743 Dms Scripts Assign SCCFP_MAP_ID = 1009 for the FA_FWS_PKG File Map Definition Which May Overwrite Custom Definition Previously Defined with Same Map ID (Doc ID 2982318.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

The upd34858743_01.dms script, delivered as part of PRP 34858743, includes the following delete statements:

The SCCFP_MAP_ID = 1009 is the Population Selection file map ID that was assigned to the new FA_FWS_PKG Map. However, institutions may have previously created their own institution-specific and custom map definition with the same SCCFP_MAP_ID = 1009; if so, that previously defined map definition will now be overwritten with the new delivered map definition.  

Any custom map definitions would typically be defined with values >= 1000, since the delivered definitions have always had values < 1000. It would be expected that the scripts would assign the new definition at a value < 1000 so as to not conflict with any custom definition that may have been created.

The issue can be reproduced with the following steps:

1. Query the PS_SCCFP_PS_MAP and PS_SCCFP_PS_MAPFLD tables to verify the existing data, and whether a row already exists with SCCFP_MAP_ID = 1009.
2. Apply Patch 34858743: COD: FEDERAL WORK STUDY REPORTING, including the step to execute the upd34858743_01.dms script in Change Assistant.
3. Repeat step 1 to compare the new data and see that SCCFP_MAP_ID = 1009 has now been updated with the FA_FWS_PKG map.

Changes

The issue occurs when applying Patch 34858743: COD: FEDERAL WORK STUDY REPORTING

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.