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
0 comments