Custom expense report number in Oracle iExpense

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 report numbers by modifying the plsql function AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice. This function does not return a default value. If you do not implement this function, Internet Expenses uses the current numbering sequence.

The AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice function is located in the directory $AP_TOP/patch/115/sql/apwcstmb.pls. The input parameters passed for this function are:

p_employeeId – IN ap_expense_report_headers.employee_id%TYPE

p_userId – IN fnd_user.user_id%TYPE

p_reportHeaderId – IN ap_expense_report_headers.report_header_id%TYPE

The returned value is the new expense report number.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s