Category Archives: General Ledger

General Ledger Interface Tables

General Ledger Interface Tables Purpose of Table GL_INTERFACE GL_INTERFACE is used to import journal entry batches through Journal Import.Base Tables: GL_JE_HEADERS GL_JE_LINES GL_INTERFACE_CONTROL GL_INTERFACE_CONTROL is used to control Journal Import execution. Whenever you start Journal Import from the Import Journals form, a row is inserted into this table for each source and group id that… Read More »

API to find out Code Combination ID for given Segments

Here is a usage of standard API “fnd_flex_ext.get_combination_id” to find code_combination_id for given segment values. Returns TRUE if combination is valid, or FALSE and sets error message on server using FND_MESSAGE if invalid. Note: This API return Code Combination ID but it will NOT create a Code Combination ID if it is not existing. 1… Read More »