3 Replies Latest reply: Apr 5, 2013 9:07 AM by scottymomo RSS

    Oracle iLearning 5.2: Staus Not_Attempted, Minutes_Spent has a value

    user6676448
      Hello,
      we are encountering an issue where an iLearning report is showing data in the minutes_spent, but the status is not_attempted. we are on oracle iLearning 5.2. I have seen an earlier user posted the same question in 2008. He was advised to apply patch 559512. Should we apply this patch?

      Here is the code
      -----------------------------------
      SELECT
      U.Id AS User_Id,
      INITCAP(U.Last_Name) AS Last_Name,
      INITCAP(U.First_Name) AS First_Name,
      U.Email,
      (SELECT Value FROM Custom_Attribute_Value
      WHERE Object_Id = P.User_Id AND Attribute_Id = 12514) AS Location,
      (SELECT Value FROM Custom_Attribute_Value
      WHERE Object_Id = P.User_Id AND Attribute_Id = 32797) AS Fvice,
      CO.Title AS Course,
      P.Id AS Performance_Id,
      DECODE(P.Id, NULL, 'Not Attempted', DECODE(P.Status, 'N', 'Not Attempted', 'P', 'Complete', 'F', 'Complete', 'C', 'Complete', 'I', 'Incomplete', 'Not Attempted')) AS Status,
      TO_CHAR(P.Completed_Date, 'MM/DD/YYYY HH24:MI:SS') AS Date_Completed,
      DECODE(P.Time, '-1001', NULL, ROUND(P.Time/60, 1)) AS Minutes_Spent
      FROM
      Users U,
      Content_Object CO,
      (SELECT OE.User_Id, O.Content_Object_Id FROM Offering_Enrollment OE, Offering O
      WHERE OE.Offering_Id = O.Id) O,
      Performance P
      WHERE
      U.Id = O.User_Id
      AND CO.id=O.Content_Object_Id
      AND O.User_Id = P.User_Id (+)
      AND O.Content_Object_Id = P.Content_Object_Id (+)
      AND O.Content_Object_Id =190791041
      )

      ------------------------------------

      Thanks in Advance

      Sud
        • 1. Re: Oracle iLearning 5.2: Staus Not_Attempted, Minutes_Spent has a value
          scottymomo
          This is certainly possible depending on the content. If the content did not send a status to the LMS of Incomplete, Completed, Passed, Failed, etc the status could remain as not attempted with time spent accumulated.

          I'd check attempt records on the given content object for the user(s) in question and check the raw_status and status of those attempts.

          Hope that helps,

          Scott
          http://www.seertechsolutions.com
          • 2. Re: Oracle iLearning 5.2: Staus Not_Attempted, Minutes_Spent has a value
            user6676448
            Hi Scott,
            Thanks for your help. I ran the following query and I am getting the INTERNAL_STATE of 'S' on some records.

            SELECT u.username AS username
            , u.first_name AS first_name
            , u.last_name AS last_name
            , o.name AS session_title
            , a.timestamp AS date_course
            , round(a.time/60,1) AS minutes_spent
            ,
            CASE
            WHEN a.status = 'N' THEN 'Not_Attempted'
            WHEN a.status = 'I' THEN 'Incomplete'
            WHEN a.status = 'C' THEN 'Complete'
            WHEN a.status= 'P' THEN 'Passed'
            WHEN a.status= 'F' THEN 'Failed'
            END AS status
            ,a.raw_status
            ,a.internal_state
            FROM users u, attempt a, offering o
            WHERE u.first_name= '&First_name'
            and u.last_name = '&Last_name'
            AND u.id = a.user_id
            AND o.name ='Pa Reporting System v1.01'
            AND a.offering_id = o.id
            AND a.time > 0
            ORDER BY timestamp

            -----------------------------
            Here are my results.

            ---------------------------

            Status1, RAW_STATUS, INTERNAL_STATE
            ------------------------------------------------------------
            N,N,S
            C,N,F


            I am getting two records for one employee, and the first one has Internal_State of 'S'.


            Appreciate your help.


            Thanks
            Sud

            Edited by: user6676448 on Apr 4, 2013 9:56 AM
            • 3. Re: Oracle iLearning 5.2: Staus Not_Attempted, Minutes_Spent has a value
              scottymomo
              Is the course in question a single object course? You should link the attempt to the content object if there is more than one object in the course otherwise you'll get one row for each object in the course I would think.

              The internal state of S means the attempt was suspended and no completion status sent to the LMS (hence the raw_status and status showing N for Not Attempted)
              The second attempt is a bit puzzling, not sure how you can have a raw status of N and a status of C. Are you sure the output you listed aligns to the raw_status and status?