My Oracle Support Banner

Exporting Several BI Reports To CSV Format Add Invalid Null Values To Each Line (Doc ID 2693458.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.04.0 version, Integration

When attempting to Import the csv generated by the report GL and SLA Account Analysis, Journal and other BI seeded reports, the file has invalid null values at the beginning of each line.

ERROR
-----------------------
..
2020-05-06 05:22:23,537 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["]
2020-05-06 05:22:23,537 DEBUG [AIF]: EPMFDM-140274:Message - null
2020-05-06 05:22:23,583 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 843

The csv file shows:

XLAAARPT,P_RESP_APPLICATION_ID,P_LEDGER_ID,P_COA_ID,...
[BLANK] "
[BLANK] null
[BLANK] null
[BLANK] ",,300000002060004,3037,,Mar-20....



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in into Fusion
2. Scheduled processes
3. Run the GL and SLA Account Analysis Report making the output csv
4. Review the csv file.


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.