Just downloaded the Stat 5.8.1 software and noticed it contains the E-Business Suite RK 1.4. It that Resource Kit the latest version available? If not, where can I get the latest E-Business Suite RK 1.4?
Yes, we had this for all objects created by the RK scripts. Despite all scripts recording that they had been executed successfully, the prior SQL statement to set the migration order had not been executed. I just ran the SQL and it updated for all the new objects:
--********************************************************************************
-- Make sure a Migration Order row is inserted for every record.
--********************************************************************************
INSERT INTO STAT.STAT_OA_OBJTYPE_MIGR_ORDER (OBJECT_CLASS, OBJECT_TYPE, MIGR_ORDER, DEF_MIGR_ORDER)
SELECT T.OBJECT_CLASS, T.OBJECT_TYPE, 900, 900
FROM STAT.STAT_OBJECT_TYPES T
LEFT JOIN STAT.STAT_OA_OBJTYPE_MIGR_ORDER O
ON T.OBJECT_CLASS = O.OBJECT_CLASS
AND T.OBJECT_TYPE = O.OBJECT_TYPE
WHERE O.OBJECT_CLASS IS NULL
AND O.OBJECT_TYPE IS NULL
AND T.OBJECT_CLASS IN ('L')
AND T.OBJECT_TYPE <> '-1';
COMMIT;
Without that we were unable to use any of the new objects.
Yes, we had this for all objects created by the RK scripts. Despite all scripts recording that they had been executed successfully, the prior SQL statement to set the migration order had not been executed. I just ran the SQL and it updated for all the new objects:
--********************************************************************************
-- Make sure a Migration Order row is inserted for every record.
--********************************************************************************
INSERT INTO STAT.STAT_OA_OBJTYPE_MIGR_ORDER (OBJECT_CLASS, OBJECT_TYPE, MIGR_ORDER, DEF_MIGR_ORDER)
SELECT T.OBJECT_CLASS, T.OBJECT_TYPE, 900, 900
FROM STAT.STAT_OBJECT_TYPES T
LEFT JOIN STAT.STAT_OA_OBJTYPE_MIGR_ORDER O
ON T.OBJECT_CLASS = O.OBJECT_CLASS
AND T.OBJECT_TYPE = O.OBJECT_TYPE
WHERE O.OBJECT_CLASS IS NULL
AND O.OBJECT_TYPE IS NULL
AND T.OBJECT_CLASS IN ('L')
AND T.OBJECT_TYPE <> '-1';
COMMIT;
Without that we were unable to use any of the new objects.