Invoice Status in oracle payables r12.Invoice Validation status in oracle apps

Invoice Status in oracle payables r12.Invoice Validation status in oracle apps

 

In this post , we will discuss how we can see the Invoice Status in oracle payables r12 from Backend. Invoice status does not save in the data base directly but we need to use standard api to fetch the Invoice Status. This API gives Invoice Validation in Oracle Apps and if you also want to the Accounting status , then you also need to second api which will share the Accounting status of the invoice.

 

 

AP Invoice Status in oracle apps

APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code)

 

This is the API used to get the AP invoice Status in Oracle Apps. This API gives the status whether invoice is Validated Or Non Validate , Needs Validation ).

 

In this API we pass the Invoice Id , Invoice Amount, Payment Status Flag and Invoice Type Lookup Code. These all information's available in the AP_INVOICES_ALL TABLE.

 

 

 

AP Invoice Accounted status

AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id)

 

 

This API is used to get the AP Invoices Accounting Status. This API shares the Accounting status of the Invoice that whether Invoice is Accounted or Not.

 

 

 

Invoice Status in oracle payables r12.Invoice Validation status in oracle apps