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.


On ORMB v3., 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.

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.

1. Navigate to -->File Upload 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'


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

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