Goal: If an expense report containing credit card transactions is approved and imported, then the associated invoice is deleted in Payables, are the credit card transactions then released for use with a new expense report […]
Goal: After an expense report with credit card transactions has been cancelled in Accounts Payable the expense report correctly shows a status of Cancelled, however, the credit card transactions on the expense report are not […]
Goal : A credit card related expense transaction was exported to AP successfully however the user noticed an anomly so they decided to cancel the invoice, purge data and retry to import the credit card […]
To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date and the Actual Termination Date to determine if an employee is Active. The […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 