I need to get only posted AP invoices in Oracle EBS R12. Is there any function to check with whether an invoice is posted or not?
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I need to get only posted AP invoices in Oracle EBS R12. Is there any function to check with whether an invoice is posted or not?
There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) .
This function take the invoice_id parameter and return one of four values:
‘Y’ – Posted
‘N’ – Unposted
‘S’ – Selected
‘P’ – Partially Posted
These values is the invoice posting status flag.
Example:
Output:
INVOICE_NUM
————————————————–
INVOICE_POSTING_FLAG
——————————————————————————–
ERS-9163-109073
Y
19879-781
N
ERS-4400-109091
Y
ERS-9164-109093
P
ERS-6970-109094
Y
ERS-6971-109095
Y