Latest Stat Resource Kit for 1.4 in the Stat 5.8.1 Download?

Hi Tom,

I would say this is the latest RK. We upgraded (finally) to 5.8.1, with the help of a Quest consultant, at the end of November and have RK 1.4 installed.

Thanks,
Nic

Hi Nic,

Thanks for replying. Since you installed the RK1.4, let me know if you have any Oracle Apps Setup Objects that have "Null" values in columns "Migr Order" and or Default Migr. Order.

Tom Shaw

Hi Tom,

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.

Thanks,
Nic