You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

'SEGMENT' values blank after Spreadsheet journal import in GL_INTERFACE

Received Response
edited May 18, 2020 11:35AM in General Ledger & Intercompany 1 comment


'SEGMENT' values blank after Spreadsheet import in GL_INTERFACE



When using the spreadsheet import for journals (multiple journals worksheet), we fill out the entire SEGMENT values by double clicking one cell and entering the Code Combination.

When importing to interface tables, we query the GL_INTERFACE table and see that the seperate SEGMENT values are not populated. The CCID clumn is filled with a proper ID though. It's possible to import the journal without an issue.

Since we have reporting requirements on the GL_INTERFACE step: why are the SEGMENT values not showing? They are showing when we are using REST API to load Journals, for example.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!