AP - Validation Date

[rajib.banerjee]

Dear All,
I have a requirement in AP. My client wants to have creation of Invoice and validation of such invoice on separate dates and wants to record the same. Where can i find the Invoice validation date either from the front end or from any back end table.
Please help

[karthikeyanp1981]

I don't think it is possible, the only table which stores the validation details of an invoice is AP_INVOICE_DISTRIBUTIONS_ALL table, in that table if the column MATCH_STATUS_FLAG has values as A then invoice is said to be in validation status, however there is no date field available in the table to capture the same.
One can use the LAST_UPDATE_DATE, but it can be any, need not be invoice validation action alone.