Designing with Application Adapters

General Ledger

This section provides a description of each of the General Ledger error codes.

Table 1–26 General Ledger Errors

Error Code 

Error Message 

SB-GL-BUDGT-40000 

BUDGET_NAME cannot be NULL. 

SB-GL-BUDGT-40001 

BUDGET_ENTITY_NAME cannot be NULL. 

SB-GL-BUDGT-40002 

CURRENCY_CODE cannot be NULL. 

SB-GL-BUDGT-40003 

FISCAL_YEAR cannot be NULL. 

SB-GL-BUDGT-40004 

UPDATE_LOGIC_TYPE cannot be NULL. 

SB-GL-BUDGT-40005 

CURRENCY_CODE does not exists in FND_CURRENCIES table. 

SB-GL-BUDGT-40006 

BUDGET_ENTITY_ID does not exists in GL_BUDGET_ENTITIES table. 

SB-GL-BUDGT-40007 

BUDGET_VERSION_ID does not exists in GL_BUDGET_VERSIONS table. 

SB-GL-BUDGT-40008 

CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS table. 

SB-GL-BUDGT-40009 

PERIOD_TYPE does not exists in GL_PERIOD_TYPES table. 

SB-GL-BUDGT-40010 

SET_OF_BOOKS_ID does not exists in GL_SETS_OF_BOOKS table. 

SB-GL-BUDGT-40011 

ACCOUNT_TYPE should be either A-Asset, L-Liability, E-Expense, O-Owners Equity, R-Revenue. 

SB-GL-BUDGT-40012 

DR_FLAG should be either Y-Yes, N-No. 

SB-GL-BUDGT-40013 

UPDATE_LOGIC_TYPE should be either A-Add, R-Replace. 

SB-GL-BUDGT-40014 

BUDGET_ENTITY_NAME does not exists in GL_BUDGET_ENTITIES table. 

SB-GL-BUDGT-40015 

FISCAL_YEAR does not exists in GL_ENTITY_BUDGETS table. 

SB-GL-DLRT-40100 

FROM_CURRENCY is a required column. Enter a valid value. 

SB-GL-DLRT-40101 

TO_CURRENCY is a required column. Enter a valid value. 

SB-GL-DLRT-40102 

FROM_CONVERSION_DATE is a required column. Enter a valid value. 

SB-GL-DLRT-40103 

TO_CONVERSION_DATE is a required column. Enter a valid value. 

SB-GL-DLRT-40104 

USER_CONVERSION_TYPE is a required column. Enter a valid value. 

SB-GL-DLRT-40105 

CONVERSION_RATE is a required column. Enter a valid value. 

SB-GL-DLRT-40106 

MODE_FLAG is a required column. Enter a valid value. 

SB-GL-DLRT-40120 

FROM_CURRENCY does not exist IN TABLE FND_CURRENCIES. 

SB-GL-DLRT-40121 

TO_CURRENCY does not exist IN TABLE FND_CURRENCIES. 

SB-GL-DLRT-40122 

USER_ID does not exist IN TABLE FND_USER. 

SB-GL-DLRT-40123 

USER_CONVERSION_TYPE does not exist IN TABLE GL_DAILY_CONVERSION_TYPES. 

SB-GL-DLRT-40130 

Valid values for LAUNCH_RATE_CHANGE column are Y,N. 

SB-GL-DLRT-40131 

Valid values for MODE_FLAG column are D,I,X. 

SB-GL-INTERFACE-40200 

STATUS cannot be NULL. 

SB-GL-INTERFACE-40201 

SET_OF_BOOKS_ID cannot be NULL. 

SB-GL-INTERFACE-40202 

USER_JE_SOURCE_NAME cannot be NULL. 

SB-GL-INTERFACE-40203 

USER_JE_CATEGORY_NAME cannot be NULL. 

SB-GL-INTERFACE-40204 

ACCOUNTING_DATE cannot be NULL. 

SB-GL-INTERFACE-40205 

CURRENCY_CODE cannot be NULL. 

SB-GL-INTERFACE-40206 

DATE_CREATED cannot be NULL. 

SB-GL-INTERFACE-40207 

CREATED_BY cannot be NULL. 

SB-GL-INTERFACE-40208 

ACTUAL_FLAG cannot be NULL. 

SB-GL-INTERFACE-40209 

SET_OF_BOOKS_ID does not exists in GL_SETS_OF_BOOKS Table. 

SB-GL-INTERFACE-40210 

CURRENCY_CODE does not exists in FND_CURRENCIES Table. 

SB-GL-INTERFACE-40211 

FUNCTIONAL_CURRENCY_CODE does not exists in FND_CURRENCIES table. 

SB-GL-INTERFACE-40212 

BUDGET_VERSION_ID does not exists in GL_BUDGET_VERSIONS table. 

SB-GL-INTERFACE-40213 

JE_BATCH_ID does not exists in GL_JE_BATCHES table. 

SB-GL-INTERFACE-40214 

ENCUMBRANCE_TYPE_ID does not exists in GL_ENCUMBRANCE_TYPES table. 

SB-GL-INTERFACE-40215 

JE_HEADER_ID does not exists in GL_JE_HEADRS table. 

SB-GL-INTERFACE-40216 

JE_LINE_NUM does not exists in GL_JE_LINES table. 

SB-GL-INTERFACE-40217 

CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS table. 

SB-GL-INTERFACE-40218 

ORIGINATING_BAL_SEG_VALUE does not exists in FND_FLEX_VALUES table. 

SB-GL-INTERFACE-40219 

USER_CURRENCY_CONVERSION_TYPE does not exists in GL_DAILY_CONVERSION_TYPES table. 

SB-GL-INTERFACE-40220 

USER_JE_CATEGORY_NAME does not exists in GL_JE_CATEGORIES table. 

SB-GL-INTERFACE-40221 

USER_JE_SOURCE_NAME does not exists in GL_JE_SOURCES table. 

SB-GL-INTERFACE-40222 

PERIOD_NAME does not exists in GL_PERIODS table. 

SB-GL-INTERFACE-40223 

USSGL_TRANSACTION_CODE does not exists in GL_USSGL_TRANSACTION_CODES table. 

SB-GL-INTERFACE-40224 

ACTUAL_FLAG should be either A-Actual, B-Budget, E-Encumbrance. 

SB-GL-INTERFACE-40225 

AVERAGE_JOURNAL_FLAG should be either Y-Yes, N-No. 

SB-GL-INTERFACE-40226 

CURRENCY_CONVERSION_RATE should be entered for USER_CURRENCY_CONVERSION_TYPE = User. 

SB-GL-INTERFACE-40227 

CURRENCY_CONVERSION_DATE should be entered for USER_CURRENCY_CONVERSION_TYPE!= User.