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

Last updated on AUGUST 24, 2017

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

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