Exporting Several BI Reports To CSV Format Add Invalid Null Values To Each Line
(Doc ID 2693458.1)
Last updated on SEPTEMBER 05, 2022
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.20.04.0 and laterInformation 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.
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 |