My Oracle Support Banner

Why when create Journal By FBDI : Journal Name Is Appending With Category (Doc ID 2300538.1)

Last updated on MAY 31, 2023

Applies to:

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

Goal

We are creating a GL Journal using FBDI csv file. Data from FBDI csv file is getting inserted into GL_interface table, Reference4 is Journal Name.
Data loaded from Gl_Interface table to the GL_JE_HEADERS table. NAME column of GL_JE_HEADERS should be mapped from Reference4 column of Gl_Interface table.

But Name is getting appended with the Category in GL_JE_HEADERS .

When we query the Journal from front end Journal name is coming along with the category as ‘430337Miscellaneous’ instead of 430337.

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.