Designing with Application Adapters

Fixed Assets

This section provides a description of each of the Fixed Assets error codes.

Table 1–25 Fixed Assets Errors

Error Code 

Error Message 

SB-FA-CATE-50200 

CATEGORY_ID cannot be NULL. 

SB-FA-CATE-50201 

SUMMARY_FLAG cannot be NULL. 

SB-FA-CATE-50202 

ENABLED_FLAG cannot be NULL. 

SB-FA-CATE-50203 

OWNED_LEASED cannot be NULL. 

SB-FA-CATE-50204 

LAST_UPDATE_DATE cannot be NULL. 

SB-FA-CATE-50205 

LAST_UPDATED_BY cannot be NULL. 

SB-FA-CATE-50206 

CATEGORY_TYPE cannot be NULL. 

SB-FA-CATE-50207 

CAPITALIZE_FLAG cannot be NULL. 

SB-FA-CATE-50208 

CAPITALIZE_FLAG should be either YES or NO. 

SB-FA-CATE-50209 

CATEGORY_TYPE should be in LEASE,LEASEHOLD,IMPROVEMENT,NON-LEASE. 

SB-FA-CATE-50210 

ENABLED_FLAG should be either Y or N. 

SB-FA-CATE-50211 

OWNED_LEASED should be either OWNED or LEASED. 

SB-FA-CATE-50212 

PROPERTY_1245_1250_CODE should be either 1245 or 1250. 

SB-FA-CATE-50213 

PROPERTY_TYPE_CODE should be either PERSONAL or REAL. 

SB-FA-CATE-50214 

SUMMARY_FLAG should be either Y or N. 

SB-FA-LOC-50100 

LOCATION_ID is a required column. Enter a valid value. 

SB-FA-LOC-50101 

SUMMARY_FLAG is a required column. Enter a valid value. 

SB-FA-LOC-50102 

ENABLED_FLAG is a required column. Enter a valid value. 

SB-FA-LOC-50104 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-FA-LOC-50105 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-FA-LOC-50110 

Valid values for ENABLED_FLAG column are Y,N. 

SB-FA-LOC-50111 

Valid values for SUMMARY_FLAG column are Y,N. 

SB-FA-MASS-50000 

ACCOUNTING_DATE cannot be NULL. 

SB-FA-MASS-50001 

ASSET_CATEGORY_ID cannot be NULL. 

SB-FA-MASS-50002 

ASSET_TYPE cannot be NULL. 

SB-FA-MASS-50003 

BOOK_TYPE_CODE cannot be NULL. 

SB-FA-MASS-50004 

CREATED_BY cannot be NULL. 

SB-FA-MASS-50005 

CREATED_DATE cannot be NULL. 

SB-FA-MASS-50006 

DATE_PLACED_IN_SERVICE cannot be NULL. 

SB-FA-MASS-50007 

DEPRECIATE_FLAG cannot be NULL. 

SB-FA-MASS-50008 

DESCRIPTION cannot be NULL. 

SB-FA-MASS-50009 

EXPENSE_CODE_COMBINATION_ID cannot be NULL. 

SB-FA-MASS-50010 

FIXED_ASSETS_COST cannot be NULL. 

SB-FA-MASS-50011 

FIXED_ASSETS_UNITS cannot be NULL. 

SB-FA-MASS-50012 

INVENTORIAL cannot be NULL. 

SB-FA-MASS-50013 

LAST_UPDATE_DATE cannot be NULL. 

SB-FA-MASS-50014 

LAST_UPDATE_LOGIN cannot be NULL. 

SB-FA-MASS-50015 

LAST_UPDATED_BY cannot be NULL. 

SB-FA-MASS-50016 

LOCATIOD_ID cannot be NULL. 

SB-FA-MASS-50017 

MASS_ADDITION_ID cannot be NULL. 

SB-FA-MASS-50018 

PAYABLES_CODE_COMBINATION_ID cannot be NULL. 

SB-FA-MASS-50019 

PAYABLES_COST cannot be NULL. 

SB-FA-MASS-50020 

PAYABLES_UNITS cannot be NULL. 

SB-FA-MASS-50021 

POSTING_STATUS cannot be NULL. 

SB-FA-MASS-50022 

QUEUE_NAME cannot be NULL. 

SB-FA-MASS-50023 

AP_DISTRIBUTION_LINE_NUMBER does not exists in AP_INVOICE_DISTRIBUTIONS_ALL table. 

SB-FA-MASS-50024 

ASSIGNED_TO does not exists in FA_EMPLOYEES table. 

SB-FA-MASS-50025 

INVOICE_ID does not exists in AP_INVOICES_ALL table. 

SB-FA-MASS-50026 

ADD_TO_ASSET_ID does not exists in FA_ADDITIONS_B table. 

SB-FA-MASS-50027 

ASSET_NUMBER does not exists in FA_ADDITIONS_B. 

SB-FA-MASS-50028 

PARENT_ASSET_ID does not exists in FA_ADDITIONS_B. 

SB-FA-MASS-50029 

ASSET_KEY_CCID does not exists in FA_ASSET_KEYWORDS. 

SB-FA-MASS-50030 

BOOK_TYPE_CODE does not exists in FA_BOOK_CONTROLS. 

SB-FA-MASS-50031 

ASSET_CATEGORY_ID does not exists in FA_CATEGORIES_B. 

SB-FA-MASS-50032 

LOCATION_ID does not exists in FA_LOCATIONS. 

SB-FA-MASS-50033 

PARENT_MASS_ADDITION_ID does not exists in FA_MASS_ADDITIONS. 

SB-FA-MASS-50034 

PAYABLES_CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS. 

SB-FA-MASS-50035 

EXPENSE_CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS. 

SB-FA-MASS-50036 

PROJECT_ID does not exists in PA_PROJECTS_ALL. 

SB-FA-MASS-50037 

PROJECT_ASSET_LINE_ID does not exists in PA_PROJECT_ASSET_LINES_ALL. 

SB-FA-MASS-50038 

TASK_ID does not exists in PA_TASKS. 

SB-FA-MASS-50039 

PO_VENDOR_ID does not exists in PO_VENDORS. 

SB-FA-MASS-50040 

ASSET_TYPE should be either CAPITALIZED, CIP, EXPENSED. 

SB-FA-MASS-50041 

DEPRECIATE_FLAG should be either YES or NO. 

SB-FA-MASS-50042 

PAYABLES_UNITS should have same value as that of FIXED_ASSETS_UNITS column. 

SB-FA-MASS-50043 

POSTING_STATUS should be either NEW, ON HOLD, POST. 

SB-FA-MASS-50044 

QUEUE_NAME should have same value as that of POSTING_STATUS. 

SB-FA-MASS-50045 

INVENTORIAL should be either YES or NO. 

SB-FA-MASS-50046 

NEW_MASTER_FLAG should be either YES or NO. 

SB-FA-MASS-50047 

SHORT_FISCAL_YEAR_FLAG should be either YES or NO. 

SB-FA-MASS-50048 

CONVERSION_DATE should not be NULL, when SHORT_FISCAL_YEAR_FLAG is YES.