R11:R12:XTR: XTRJRNAL Revaluation/Accrual Related Journal Process Has Error: "GEN_JOURNALS procedure raised the following unhandled exception: Inserting journal into table..."

(Doc ID 1520893.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Treasury - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Acct'ing-Jounals,Accrual,Reval

When attempting to submit the Program - Revaluation/Accrual Related Journal Processing
the following error occurs.

ERROR
-----------------------
GEN_JOURNALS procedure raised the following unhandled exception: Inserting journal into table..
GEN_JOURNALS procedure raised the following unhandled exception: Inserting journal into table..
End journal generation for batch ID 18851.
End journal generation for company ITA for the following range of batch ID: 18851 - 18851.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to a Treasury Responsibility

2. N)Other/Submit Requests

3. Submit the Program - Revaluation/Accrual Related Journal Processing

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