Introduction
This Post illustrates the steps required to Export employee data with personal expenses in i-expense and the expense is not claimed in Oracle EBS R12.
Script to Export employee data with personal expenses in i-expense
SELECT pap.full_name, pap.email_address, pap.employee_number,
aeh.invoice_num, aeh.total total_amount,
aeh.amt_due_employee personal_amount, aeh.expense_status_code,
aeh.report_header_id, aeh.employee_id, aeh.org_id, aeh.ROWID,
round((trunc(sysdate)-trunc(aia.creation_date)))days,aia.creation_date
FROM ap_expense_report_headers_all aeh, per_all_people_f pap,ap_invoices_all aia
WHERE aeh.employee_id = pap.person_id
AND aeh.org_id = p_organization_id
AND AIA.INVOICE_NUM=aeh.invoice_num
AND aeh.amt_due_employee < 0
and aia.AMOUNT_PAID = 0;
What we expect in the script.
This script helps us to comprehend how Export employee data with personal expenses in i-expense and the expense is not claimed.A couple of tables which is being used in the scripts are ap_expense_report_headers_all, per_all_people_f,etc
Summary
This Post described the script for Export employee data with personal expenses in i-expense and the expense is not claimed in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
