Question Regarding PS_PO_LINE_DISTRIB.DISTRIB_LN_STATUS

Hello ,

Recently one of out User has Run the PO Close Process in the Production Database.

He was Successful in running a Couple of time and it Failed a Few Times

when the Process Failed

1 ) It has Set the IN_PROCESS_FLG = 'Y' on PS_PO_HDR table.

2 ) It has set the PS_PO_LINE_DISTRIB.DISTRIB_LN_STATUS = 'P'

so We have Done a SQL update the Reset the In_process_flg to N

Now we have Found that there are Whole bunch of Transactions where

PS_PO_HDR.PO_STATUS = 'D'

PS_PO_LINE.CANCEL_STATUS ='A'

PS_PO_LINE_SHIP.CANCEL_STATUS ='A'