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!!!