R12: OIE: Oracle Internet Expenses: Error: "Cannot run the macro "apwexpmc.xls!ChangeExpenseType"" when choosing the expense type in Expenses Disconnected Spreadsheet
Last updated on JUNE 30, 2016
Applies to:Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to import spreadsheet to the expense report, an error appears when choosing a different expense type in the excel file.
In the spreadsheet error is: Cannot run the macro "apwexpmc.xls!ChangeExpenseType". The macro may not be available in this workbook or all macros may be disabled.
In the application error is: Line1: Expense Type: Please enter a value in this field
Final Result: Expense type in the Expense Report is empty.
The issue can be reproduced at will with the following steps:
1. Fill data in excel spreadsheet.
2. Copy/paste in the application
3. Notice that Expense Type is not imported.
New expense type addition in the Expense Template trigger such behavior.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms