R12: OIE: "java.sql.SQLException: Initialization Failed" When Generating Per Diem Amount in Details Form

(Doc ID 2189935.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
java.sql.SQLException: Initialization Failed
Calculate Amount
Cash and Other Expenses:Details Form
Per Diem
Allowance type Policy Schedule
Generate Per Diem (button)
Procedure CustomCalculateAmount


When selecting the Generate Per Diem (button) on the Cash and Other Expenses: Details page the following error occurs:

java.sql.SQLException: Initialization failed

The issue can be reproduced at will with the following steps:
1. Set up a Per Diem policy set up for "Allowance" with meals (Breakfast 12 USD, Lunch 13 USD and Dinner 24 USD).
2. Attach the policy to an expense type
3. Create an expense report using the expense type. On the Create Expense Report: Cash and Other Expenses: Per Diem Expenses (tab) enter one line as follows:
  Line 1 Start Date: 01-Sep-2016 Expense Type: Meal Allowance Destination: Tampa Justification: Test Num of days: 1 Reimbursable Amount (USD) 25.00
4. Select the Details button.
5. On the Details page select the Generate Per Diem (button)
6. Error occurs
7. Save the report
8. Attempt to update the report.
9. Error occurs
10. Attempt to submit the report, the following message appears:
  You have entered invalid data or you have not completed all required fields. Do you want to continue?
11. Users cannot update or submit the report.


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