R12: OIE: Oracle Internet Expenses: Error: "Cannot run the macro "apwexpmc.xls!ChangeExpenseType"" when choosing the expense type in Expenses Disconnected Spreadsheet (Doc ID 2156284.1)

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.

Symptoms


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.


Changes

 New expense type addition in the Expense Template trigger such behavior.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms