How To Identify Where An Expense Report Is In the Process

The values for the column EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all come from the Payables Lookup Code EXPENSE REPORT STATUS

Code	Lookup Code Meaning
CANCELLED	Cancelled
EMPAPPR	Pending Individual’s Approval
ERROR	Pending System Administrator Action
HOLD_PENDING_RECEIPTS	Hold Pending Receipts
INPROGRESS	In Progress
INVOICED	Ready for Payment
MGRAPPR	Pending Payables Approval
MGRPAYAPPR	Ready for Invoicing
PAID	Paid
PARPAID	Partially Paid
PAYAPPR	Payables Approved
PENDMGR	Pending Manager Approval
PEND_HOLDS_CLEARANCE	Pending Payment Verification
REJECTED	Rejected
RESOLUTN	Pending Your Resolution
RETURNED	Returned
SAVED	Saved
SUBMITTED	Submitted
UNUSED	Unused
WITHDRAWN	Withdrawn

2 thoughts

Pingback: Top Referred Articles on KnowOracle | Shivmohan Purohit's Oracle Applications Blog
Raghav says:

December 2, 2009 at 8:53 am

Hi Team,

I am using a query to find out the expense reports which are having IN PROCESS status, as you mentioned above there is a status called IN PROGRESS but i cant find it in the ap_lookup_codes, I am using 11.5.10.2 version, is this the status code introduded in R12??

Appreciate your respone

Thanks,
Raghav

LikeLike

Reply