This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

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?

Parents
  • 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
Reply
  • 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
Children
No Data