==================================================== 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 […]
— 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 SELECT * FROM (SELECT per.full_name, per.employee_num, aps.vendor_name, aps.segment1, […]
— Following Query gives Rejected Expense Report From “Expense Report Export” Concurrent Program — This will help to debug issue related to Expense Report Export SELECT * FROM (SELECT per.full_name, per.employee_num, aps.vendor_name, aps.segment1, aeh.invoice_num, aeh.week_end_date, […]
In R12, the Export Results are viewed via the Application. Follow steps: 1. Login to the System Administrator responsibility a. -Navigate to: Security -> Responsibility -> Define -Query the name of the Payables Manager Responsibility […]
1025 is daily Amex feed and supported by Oracle to upload Amex feed 1022 is Monthly file and equivalent to electronic copy of statement that is coming in. We can either choose to upload daily […]
What are the supported Credit Card Data File Formats? 1. American Express KR-1025 format (file name is Card Daily Data Feed) 2. Diner’s Club Standard Data File Format (file name is trans.dat) 3. US Bank […]
Implementing Accounting Client Extensions for Oracle Internet Expenses Table of Contents This white paper contains the following information. Overview Standard Accounting Generation Non-Project Expenses Expense Allocations Enabled with Online Validation Expense Allocations Enabled without […]
Enterprise Resource Planning and Integrations BlogSpot 