FVS1001F Cannot Handle Account Mapping Views With Queries Larger Then 4K. (Doc ID 2059567.1)

Last updated on OCTOBER 01, 2015

Applies to:

Oracle Health Insurance Disbursements and Collections - Version 10.15.1.3 to 10.15.3.0 [Release 10.15]
Information in this document applies to any platform.

Symptoms

On test : 10.15.1.3 version, Usage

ACTUAL BEHAVIOR
---------------
when a large query (>4k) is given as input for an account mapping view in screen fvs1001f, the query is not saved. No error is given. Removing whitespace (thus reducing the size to <4k) the query is saved

EXPECTED BEHAVIOR
-----------------------
screen fvs1001f should be able to save large querys and or should give an error when the input is to large (>4k)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. start fvs1001f
2. search for an existing account mapping view
3. replace the existing query with an query larger then 4K.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot input needed account mappings in screen fvs1001f resulting in an incorrect processing of financial transactions

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