Run the following program as needed as part of your implementation or upgrade.
Run this program once, when you first implement or upgrade from a release earlier than 11i.HZ.K mini-pack. Run this program only if you used the ORIG_SYSTEM_REFERENCE column before upgrade and want to use source systems after upgrade. See: Source Systems Overview. In the program parameter, specify the batch size, or number of records to process for each commit.
The Source System - Migrate Party Level Source System References program migrates nonunique source IDs, or references, from these party level tables to the HZ_ORIG_SYSTEM_REFERENCES table:
HZ_CONTACT_POINTS
HZ_LOCATIONS
HZ_ORG_CONTACT_ROLES
HZ_ORG_CONTACTS
HZ_PARTIES
HZ_PARTY_SITES
Along with the migrated source IDs, the program assigns a corresponding UNKNOWN source system because the source system is usually not captured for all existing data. In addition, existing source IDs in party level tables are not unique, so multiple party level records can use the same source ID. The UNKNOWN source system allows the same source ID to point to multiple records for all party level tables that are enabled for Source System Management.