My Oracle Support Banner

'File Record Detail ' UI Search Filters Are Not Working (Doc ID 2876929.1)

Last updated on JUNE 23, 2022

Applies to:

Oracle Financial Services Revenue Management and Billing Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On ORMB v3.2.0.0.0, Users gets an error when searching records

'File Record Detail ' UI search filters are not working. it is giving following error.
User should able to search records successfully.

ERROR
--------------------
The zone SQL number 1 has encountered an exception.
Message Number 11007, 11013

Note that post upgrade, this issue is observed in all upgraded environments.

STEPS
-------------
1. Navigate to -->File Upload Dashboard..search for file with some error records.
2. Click on error record count link--> to 'File Record Details'.
3. Search for records with different filter conditions like RECORD IDENTIFIER1,2,3, etc.
4. After clicking on 'Search' button, UI throws error message 'The zone SQL number 1 has encountered an exception'

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.