Unable To Create A Write-Off Due To Request Timeout (Doc ID 2265536.1)

Last updated on JULY 20, 2017

Applies to:

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

Symptoms

On : 2.4.0.1.0 version, DB - Database

Unable to create a Write-Off due to request timeout.

Unable to create Write Offs in UHG production due to performance issues. The root cause seems to be SQLs that are doing Full Scans on FT tables.
Please find attached the SR document with details.

Scenario:

Unable to process a write-off request in UHG production due to request timeout.

Steps:
- Create a Write Off request.
- Select 10 Bill Segments to add to the Write Off.
- Edit the Request to update the Adjustment Type Code to be used for Write Off.
- Click Save.
- The request times out.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This issue has been escalated as a high risk as it is a big impact to operations in production.

Changes

 

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