iExpenses Table ,Credit Card Transactions in Iexpense -> Process Flows

iExpenses Table

Table NameDescription
AP_EXPENSE_REPORT_HEADERS_ALLExpense report header information
AP_EXPENSE_REPORT_LINES_ALLExpense report lines information
AP_EXP_REPORT_DISTS_ALLExpense report distribution information. It contains the accounts against each expense report line.
AP_CREDIT_CARD_TRXNS_ALLTable to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards
AP_NOTESTable to store the comments entered by approvers and auditors
Setup tables
AP_EXPENSE_REPORTS_ALLThis table contains the header level information about the expense templates
AP_EXPENSE_REPORT_PARAMS_ALLThis table contains the detail level information about the expense templates
AP_POL_CAT_OPTIONS_ALLTable to store the policy options
AP_POL_CONTEXTTable to store the policy context
AP_POL_LOCATIONS_TLTable to store the locations for which policies have been defined.
AP_POL_VIOLATIONS_ALLTable to store the lines for which the defined policies have been violated
AP_POL_EXRATE_OPTIONS_ALLTable to store the exchange rate tolerance
AP_POL_HEADERSTable to store all the policy headers
AP_POL_LINESTable to store all the policy details
AP_CARDS_ALLTable to store the corporate credit card details for the employees
AP_EXPENSE_REPORTS_ALLTable to store the expense report templates that can be used by employees from different operating units
AP_POL_SCHEDULE_OPTIONSTable to store the basis of the policy created, E.g. location, currency, etc.
AP_EXPENSE_REPORT_PARAMS_ALLTable to store the expense template detailed information
Audit tables
AP_AUD_AUDITORSTable to store auditor id and security_profile_id
AP_AUD_AUDIT_REASONSTable containing the expense report header id and audit reason id and code
AP_AUD_AUTO_AUDITSTable to store the employees who are auditors. This table is updated through the seeded package,AP_WEB_AUDIT_PROCESS.add_to_audit_list
AP_AUD_RULE_ASSIGNMENTS_ALLTable containing audit rule assignments
AP_AUD_RULE_SETSTable containing audit rules

uring implementation of Internet Expenses, a company have to make a decision as to how the payment towards credit card expenses will be made. Oracle as product has three standard offering which is based out of 3 model in which they can choose any one of them , as described below:
A. Individual Pay
This is the easiest option, majority of company (specailly midsize). The user (employee) pays the credit card provider for all transactions. When the employee creates the expense report, only those transactions elated to business expenses are reported. The employee is then reimbursed by the employer for the credit card business expenses.Below are the process flow diagrams for your reference:
B. Both Pay
With this option, employer pays the credit card provider for expenses that are categorizes as business expenses. Employees need to pay the credit card provider for all personal expenses. An invoice cannot be created for the credit card provider until the expense report is imported into Oracle Payables as an Invoice.Below are the process flow diagrams for your reference:
if you are using this then everytime you need to run two programs after the expense report is reviewed and approved.One for the invoice due to employee as described in Individual Pay. The other one is for invoice due to the Credit Card provider.
C. Company Pay
Employer pays for all credit card transactions incurred by their employees. Employees are reimbursed for cash and other business expenses. Credit card transactions reported as business expenses will not impact the amount reimbursed to the employee. However,if the employee reports any transactions as personal expenses, these transactions are offset against any cash and other expenses reported on the expense report. In short, the amount reimbursable to the employee will be reduced by the amount of credit card personal expenses.Below are the process flow diagrams for your reference.
To import the invoice of the credit card provider into Payables, you need to run the Payables Open Interface Import program with ‘Credit Card’ as source , you need to make sure create Credit Card Invoice Interface program is alreadt run into Payable.


Excellent info...Thanks a lot


Post a Comment