All Journal Are Failing Due To CVR Also All CVR Filter Condition and Values Are Duplicated After The ADFDi Upload
(Doc ID 2551894.1)
Last updated on OCTOBER 17, 2019
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.19.04.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.19.04.0 version, Create and Manage Journals
When attempting to create a journal that complies with a Cross Validation Rule (CVR), all journals are failing the CVR validations and the following error occurs.
ERROR
-----------------------
This combination is invalid: The message is Exception in Filter to WHERE clause conversion. Rule Code: XYZ Filter Type: CONDITION_FILTER Error Message:ORA-06502:PL/SLQ: numeric or value error : character string buffer too small.
OR
The validation fails for a Rule that is NOT even the one being tested
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upload a set of CVR from spreadsheet.
2. Verify the conditions and values are NOT duplicated on the Spreadsheet.
3. Test a Journal that does NOT violate CVR rules.
4. Edit the CVR and the conditions and filter values are all duplicated.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |