My Oracle Support Banner

Journals Report Newly Added Columns Are Blank as Part of 22B in CSV format (Doc ID 2886571.1)

Last updated on JANUARY 17, 2024

Applies to:

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

Goal

On : 11.13.22.04.0 version, GL Reports & Inquire Screens

Journal Report newly added columns are blank as a part of 22B Upgrade

Per release readiness

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/22B/22B-financials-wn.htm#F22677

Journals Report Data Model Changes

The data model for the Journals report is enhanced to include additional columns. View more information about your batches, journals, and journal lines when you export the report to the CSV format.

NOTE: This data model change does not impact the existing report layout. The new additional columns are only viewable in the CSV output and not in the other report delivery output formats (PDF, Excel, HTML).

But, when generating in .csv format, the below columns details are blank:
BALANCING_SEGMENT_DESC
NATURAL_ACCOUNT_DESC
COST_CENTER_DESC
MANAGEMENT_SEGMENT_DESC
INTERCOMPANY_SEGMENT_DESC
GL_SECONDARY_DESC
ACCT_VALUE
BALANCING_SEGMENT_VALUE
COST_CENTER_VALUE
MANAGEMENT_SEGMENT_VALUE
INTERCOMPANY_SEG_VAL
SECONDARY_TRACK_SEG_VAL
LEGAL_ENTITY_ID
LEGAL_ENTITY_NAME
LE_ADDRESS_LINE_1
LE_ADDRESS_LINE_2
LE_ADDRESS_LINE_3

Why above columns are coming blank?
 

Solution

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
Goal
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.