My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.