rcooperm

BPM_RUN_ASSIGNEES / Column: AI_STATUS_CODE (NULL)

Discussion created by rcooperm on May 18, 2013
Latest reply on Apr 3, 2017 by Srikar_Excers
Hi Guys,

We're running 12.1, planning our next steps to go to 13.1 in Development Environment.

Our DB Team noticed the following table: BPM_RUN_ASSIGNEES and column AI_STATUS_CODE

In the above column all AI responded are stored with their option (Approve / Done / Rejected).

When an AI is sent and is waiting user response have the following structure:
AI_STATUS_CODE = CAL_OPEN

Once is responded AI_STATUS_CODE = (Approve / Done / Rejected).

We noticed that there are some records with NULL in AI_STATUS_CODE, but we don't know why.

Do you know if is a known issue or is caused by some action?

At least we tried to cancel instance and delete process instance,the result is (deleted record in BPM_RUN_ASSIGNEES table).

We're searching, why there are records in NULL

Kind Regards,
Ricky

Outcomes