I have a question about the Additional Deployment Process functionality in Data Migration Manager projects. In short, is the functionality even implemented correctly in 24R2 or am I wasting my time in trying to get this to work?
I’m trying to migrate the EQUIPMENT_SERIAL object and eventually update the hierarchy. For performance reasons, the EQUIPMENT_OBJECT_SEQ field is auto generated and in the hierarchy, based on the SUP_CONTRACT and SUP_MCH_CODE fields, the FUNCTIONAL_OBJECT_SEQ (others also) is updated. Thought I could implement a Pre Deployment process of type UpdateMissingKeys to retrieve the Sequence from the database but it’s not working. The SQL that I would guess would be generated as the basis of the deployment would be the following using the EQUIPMENT_OBJECT_API.GET_EQUIPMENT_OBJECT_SEQ method as the basis to get the key. The SQL works so I’m guessing that DMM in 24R2 is completely foobared.
SELECT src.DATA1 AS CONTRACT,
src.DATA2 AS MCH_CODE,
src.DATA48 AS SUP_CONTRACT,
src.DATA47 AS SUP_MCH_CODE,
IFSAPP.EQUIPMENT_OBJECT_API.GET_EQUIPMENT_OBJECT_SEQ(src.DATA48, src.DATA47) AS FUNCTIONAL_OBJECT_SEQ
FROM IFSAPP.DAT_OUTPUT_CONT_DETAIL src
WHERE TARGET_ID = 'EQUIPMENT_SERIAL'
AND ROW_TYPE = 'Data'