0 Replies Latest reply: Feb 28, 2012 3:33 PM by 855136 RSS

    Transaction status code in CSI_TRANSACTIONS is blank

    855136
      Hi,

      I am working on finding the status of Install Base transactions i.e. trying to find if a Install Base transaction in complete or not.

      The "CSI_TRANSACTIONS" table has a column "Transaction_status_code" with different values (COMPLETE, PENDING, etc.) but almost 50% of the records in our system have this column as blank (NULL).

      Can anyone please help me in understanding the significance of this column in Oracle.

      An additional note: Asset tracking is NOT enabled in our system.

      Any help on this is highly appreciated!!!

      Thanks,
      Renganayaki S