My Oracle Support Banner

Incorrect Account Setup Data Validation Report - Data Mismatch In Exported Report (Doc ID 2760077.1)

Last updated on MARCH 22, 2021

Applies to:

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

Symptoms

In RMB v2.9.0.1, Data Mismatch in exported report.

ACTUAL BEHAVIOR
------------------------------
Incorrect Account Setup - No. of records in exported sheet doesn’t match with UI output.
Only 1998 records exported whereas original output contains 97544 records.

EXPECTED BEHAVIOR
---------------------------------
No. of records in exported sheet should match against records shown in UI.
Also Extra column ‘Account Information’ should not be present in exported sheet as it was not in UI.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to ORMB R8 -> Reports->Data Validation->Data Validation Reports2.
Report screen is displayed. Name: Data Validation Reports - This report has multiple sub report options. Go through each of them one by one.
2. Incorrect Account Setup Note: This sub report is used for checking incorrect account setup for settlement, invoice and usage accounts (Assumption).
3. Enter the required fields (auto populated but editable) and click on Search button.
Report is displayed in a tabular format.
4. Click on the Explorer Zone Menu and select "Export to Excel" option
5. Open the File and validate the data in spreadsheet with data in the report UI.
No. of records in exported sheet does not match with UI output. Only 1998 records exported whereas original output contains 97544 records.
Extra column ‘Account Information’ present in exported sheet.

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.