My Oracle Support Banner

FRM-40741: Unable To Locate Record On Block CHARGES_DETAIL_BLK Service Request Form (Doc ID 837739.1)

Last updated on AUGUST 15, 2023

Applies to:

Oracle Teleservice - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 12.0.4 in Production:
When attempting to query Service Requests with using F11/CTRL-F11 in the Create Service Request
form, scrolling to the next record with "arrow down" leads to the
following error when the SR has a status with Disallow Charge Update" and "Disallow Charge" ticked
in the setup of status:

ERROR
FRM-40741: Unable to locate record 4 on block CHARGES_DETAIL_BLK

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.
NAV Service Request/Service Requests/Create Service Requests.
Make sure a few SRs are entered for a certain customer of which one or more have status Closed.
2.
Press F11.
Enter search criteria.
Press CTRL+F11.
3.
Scrolling to the next record with "arrow down" leads to a FRM-40471 error message.
4.
Check Setup
Service Requests/Service Request Statuses
Uncheck Disallow Charge Update" and "Disallow Charge" for status Closed.
Try again to reproduce. The error does not show.

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.