CSTRAIVR All Inventories Value Report(XML) - Excel output not correct, issue with column values and extended values per Row (Doc ID 1440224.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms


On : 12.1.3 version, Reports Issues

ACTUAL BEHAVIOR
---------------
All inventories value report(XML) output when created in excel, The column headers are not matching with data columns

also reported that

This report is incorrectly reflecting the  total quantity and extended value per row.

EXPECTED BEHAVIOR
-----------------------
Expect the Excel output for the All inventories value report(XML) to have column headers in sync with the data columns

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. View-->Request
2. Click on Submit New Request
3. Select the Report All Inventories Value Report(XML) in LOV's
4. Entering the Parameters
Cost Type: Average
Currency: GBP
Exchange Rate: 1
5. Click on OK.
6. Go to Scheduled Options, Change the format RTF to EXCEL.
7. Submit.

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