How to configure printers in EBS 11i/R12 Oracle E-Business Suite offers two printing solutions to handle all your printing requirements. For most printing needs, the Pasta Utility offers quick setup and easy maintenance. For additional […]
— 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, […]
Following are 3 key programs that can be used to upload GL Daily Conversion Rates. A) XXCB FX Rates Data Load Program B) XXCB FX Rates Validation Procedure Program C) Program – Daily Rates Import […]
——————————————————————————- — Query to find all responsibilities of a user ——————————————————————————- SELECT fu.user_name “User Name”, frt.responsibility_name “Responsibility Name”, fu.start_date “User Access Start Date”, fu.end_date “User Access End Date”, furg.start_date “Resp Access Start Date”, furg.end_date “Resp […]
Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]
–Query to get GL Batches, Journal and Lines for Liability Account for a single GL period for source Payables and Category Purchase Invoices if you want include payment category then comment out category equals Purchase […]
Enterprise Resource Planning and Integrations BlogSpot 