My Oracle Support Banner

ORA-01403: No Data Found Exception Using Install Base Tab For Customer/Contract In Contact Center (Doc ID 745485.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Service Contracts - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FORM:CSITSTAB.fmb
FORM:CSCCCCRC.FMB - Contact Center


Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to use the install base tab for a customer/contract in the Contact Center
the following error occurs:

ERROR
ORA-01403: no data found

This problem only happens with 1 contract.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.
Login to ebiz suite, and navigate to a responsibility which contains the
Contact Center form (CSCCCCRC).
2.
Select Contract Number from the Search By dropdown menu.
Enter the customer number in the box and press submit.
This loads the customers details in the Customer section of the page.
3.
Click the 'Install Base' tab
Error ORA-01403: no data found is shown.
4.
Enter contract number in the Filter By box under Install Base tab and press
Refresh button.
Also ORA-01403: no data found shows.
5.
Using the Install application verified that the same contract
contains 12000+ rows.
6.
If the contract is removed from the filter by on the install base tab, and refresh is
clicked, the IB items will display for the customer.
But it is needed to only see the items for that contract.
7.
If the 'Contracts' tab in the Contact center form is selected the
the contract can be queried successfully. This problem is only in the Install Base tab.



Changes

 

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
Changes
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.