My Oracle Support Banner

WebADI Upload Error: Unable to Obtain Reversal Date java.lang.String cannot be cast to java.sql.Timestamp (Doc ID 2791149.1)

Last updated on MAY 23, 2022

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2 and later
Information in this document applies to any platform.
WebADI: Web Applications Desktop Integrator


When attempting to upload a journal with a reversal period/date the following error message is received.
If the reversal period/date column is left blank then data is uploaded successfully.
Unable to obtain Reversal Date information.. java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Timestamp

The issue can be reproduced at will with the following steps:

1. (N) Desktop Integration Responsibility > Create Document
2. Select integrator = General Ledger - Journals and layout = Functional Actuals - Single
3. Once the template is created, enter data journal data including the reversal period/date.
4. Click Upload. Error occurs in the processing window.

The issue has the following business impact:
Due to this issue, users cannot upload journals that contain a reversal period/date.


Upgrade to 12.2.9


To view full details, 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 a vibrant support community of peers and Oracle experts.