1 2 3 4 5 6 7 8 9 10 SELECT Decode(Count(*), 0, 'false', 'true') FROM apps.ap_expense_report_headers_all WHERE report_header_id = :transactionId AND employee_id IN (SELECT ap_web_ame_pkg.Getawardmanagerid(award_id, sysdate) FROM apps. ap_exp_report_dists_all dist WHERE report_header_id = :transactionId […]
This article discussed how the accounting flexfield is generated in Oracle iExpenses when employee submits his or her expense report. For simplicity sake, let’s assume the expense report does not have any multi-currency or credit […]
This feature is called “Authorized Delegate”. To have the ability to enter expense reports, withdraw expense reports, etc. for other individuals, do the following: Authorization Preferences (Self-Service Delegate Assignment) Users can now maintain their own list […]
Use the Expense Report Number client extension to generate custom expense report numbers. You can, for example, customize the format of the expense report number to match your company’s numbering system. You create custom expense […]
Once the Expense Repot is converted to Invoice using the standard ‘Expense Report Export Program’ The invoice date is nothing but ‘week_end_date’ column populated on the ap_expense_report_headers_all table. Below is the logic used behind the screens […]
Below are queries for Oracle iExpense to find out the Policy violation detail for iExpense reports. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 […]
==================================================== Oracle (EBusiness Suite 11i/R12) – Concur Expense Integration. ==================================================== Are you using Concur cloud application for expenses and want to post expense data into your oracle application General Ledger module? No Problem, we […]
— Criteria For expense report selection during expense report export — Criteria for this cursor is: — Expense status code should not be ‘ERROR’ or ‘PEND_HOLDS_CLEARANCE’ or ‘HOLD_PENDING_RECEIPTS’ — Vouchno = 0 — XH.hold_lookup_code is […]
— Following Query gives Rejected Expense Report in AP Invoice Interface During “Expense Report Export” Concurrent Program processing — This will help to debug issue related to Expense Report Export — CURSOR c_rejected_invoices(l_request_id IN NUMBER) […]
— Following Query gives Successful Expense Report in “Expense Report Export” Concurrent Program Output File — This will help to debug issue related to Expense Report Export –c_successful_invoices SELECT ai.invoice_id, aerh.report_header_id, aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply FROM ap_expense_report_headers_all […]
