Payables Invoice Validation Status

In Oracle payables, for paying supplier payment we have created the invoices into this modules.

Whenever the invoices is created, how to find out the status of the invoice whether it is validated never validated or approved.

1.       A user is created the invoice manually, the data will be inserted into  different tables

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

AP_PAYMENT_SCHEDULES_ALL

To find out the status of the invoices, we need to check the match_status_flag column of ap_invoice_distributions_all table.

1.Match_status_flag = Null

Invoice is Never Validated status

2.Match_status_flag=’A’

 Invoice is Validated Status

3.Match_status_flag=’N’

Invoice is Need Revalidation status

           Api is also available to find the status of the invoices which is given below

             AP_INVOICES_UTILITY_PKG.Get_approval_status(  l_invoice_id IN NUMBER,                              l_invoice_amount           IN NUMBER,  l_payment_status_flag      IN VARCHAR2,                 l_invoice_type_lookup_code IN VARCHAR2)

         How you know who has validated the invoice and who has made the payment for that particular invoices.

We can identified the user who has validated the invoices using ap_invoice_distributions_all table

In ap_invoice_distributions_all table  if the match_status_flag=’A’ then pickup the value of last_updated_by column and find out name in per_people_f table using person_id.

  Select * from per_people_f where person_id=last_updated_by;

  If we using the fnd_user table then the command is

 Select * from fnd_user where employee_id = last_updated_by

For payments we need to check ap_payment_schedules_all tables.

In ap_payment_schedules_all table if the payment_status_flag=’Y’ then pickup the value of last_updated_by column.

  Select * from per_people_f where person_id=last_updated_by;

  If we using the fnd_user table then the command is

 Select * from fnd_user where employee_id = last_updated_by