Designing with Application Adapters

Financial Budget-GL

This section provides a description of each of the following Financial Budget error codes.

Accounts Payable

This section provides a description of each of the Accounts Payable error codes.

Table 1–20 Accounts Payable Errors

Error Code 

Error Message 

SB-AP-INVOICE-20000 

INVOICE_ID cannot be NULL. 

SB-AP-INVOICE-20001 

PO_NUMBER does not exist in PO_HEADERS. 

SB-AP-INVOICE-20002 

VENDOR_ID does not exist in PO_VENDORS. 

SB-AP-INVOICE-20003 

VENDOR_NUM does not exist in PO_VENDORS. 

SB-AP-INVOICE-20004 

VENDOR_NAME does not exist in PO_VENDORS. 

SB-AP-INVOICE-20005 

VENDOR_SITE_ID does not exist in PO_VENDOR_SITES. 

SB-AP-INVOICE-20006 

VENDOR_SITE_CODE does not exist in PO_VENDOR_SITES. 

SB-AP-INVOICE-20007 

INVOICE_CURRENCY_CODE does not exist in FND_CURRENCIES. 

SB-AP-INVOICE-20008 

EXCHANGE_RATE_TYPE does not exist in GL_DAILY_CONVERSION_TYPES. 

SB-AP-INVOICE-20009 

TERMS_ID does not exist in AP_TERMS. 

SB-AP-INVOICE-20010 

TERMS_NAME does not exist in AP_TERMS. 

SB-AP-INVOICE-20011 

AWT_GROUP_ID does not exist in AP_AWT_GROUPS. 

SB-AP-INVOICE-20012 

AWT_GROUP_NAME does not exist in AP_AWT_GROUPS. 

SB-AP-INVOICE-20013 

PREPAY_NUM does not exist in AP_INVOICES. 

SB-AP-INVOICE-20020 

INVOICE_TYPE_LOOKUP_CODE does not exist in AP_LOOKUP_CODES. 

SB-AP-INVOICE-20021 

PAYMENT_METHOD_LOOKUP_CODE does not exist in AP_LOOKUP_CODES. 

SB-AP-INVOICE-20022 

SOURCE does not exist in AP_LOOKUP_CODES. 

SB-AP-INVOICE-20023 

INVOICE_NUM cannot be NULL. 

SB-AP-INVOICE-20024 

SOURCE cannot be NULL. 

SB-AP-INVOICE-20025 

INVOICE_NUM and VENDOR_ID should be unique in AP_INVOICES_ALL. 

SB-AP-INVOICE-20026 

VENDOR_ID or VENDOR_NUM or VENDOR_NAME or PO_NUMBER should be entered. 

SB-AP-INVOICE-20027 

VENDOR_SITE_ID or VENDOR_SITE_CODE or PO_NUMBER should be entered. 

SB-AP-INVOICE-20028 

EXCHANGE_RATE required if INVOICE_CURRENCY_CODE is entered and EXCHANGE_RATE_TYPE is User. 

SB-AP-INVOICE-20029 

EXCHANGE_DATE required if INVOICE_CURRENCY_CODE is entered. 

SB-AP-INVOICE-20030 

WORKFLOW_FLAG Should be in Y,S,D or NULL. 

SB-AP-INVOICE-20031 

ACCTS_PAY_CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS. 

SB-AP-INVOICE-20032 

ORG_ID does not exists in HR_ORGANIZATION_UNITS_V. 

SB-AP-INVLIN-20100 

INVOICE_ID is a required column. Enter a valid value. 

SB-AP-INVLIN-20101 

LINE_NUMBER is a required column. Enter a valid value. 

SB-AP-INVLIN-20102 

LINE_TYPE_LOOKUP_CODE is a required column. Enter a valid value. 

SB-AP-INVLIN-20103 

AMOUNT is a required column. Enter a valid value. 

SB-AP-INVLIN-20111 

INVOICE_ID does NOT exist IN TABLE SB_AP_INVOICES_INTERFACE. 

SB-AP-INVLIN-20112 

Valid values for LINE_TYPE_LOOKUP_CODE column are ITEM,TAX,MISCELLANEOUS,FREIGHT. 

SB-AP-INVLIN-20113 

LINE_GROUP_NUMBER value must be a positive whole number. 

SB-AP-INVLIN-20114 

PO_NUMBER does NOT exist IN TABLE PO_HEADERS. 

SB-AP-INVLIN-20115 

PO_HEADER_ID does NOT exist IN TABLE PO_HEADERS. 

SB-AP-INVLIN-20116 

PO_LINE_ID does NOT exist IN TABLE PO_LINES. 

SB-AP-INVLIN-20117 

PO_LINE_NUMBER does NOT exist IN TABLE PO_LINES. 

SB-AP-INVLIN-20118 

PO_LINE_LOCATION_ID does NOT exist IN TABLE PO_LINE_LOCATIONS. 

SB-AP-INVLIN-20119 

PO_SHIPMENT_NUM does NOT exist IN TABLE PO_LINE_LOCATIONS. 

SB-AP-INVLIN-20120 

PO_DISTRIBUTION_NUM does NOT exist IN TABLE PO_DISTRIBUTIONS. 

SB-AP-INVLIN-20121 

PO_UNIT_OF_MEASURE does NOT exist IN TABLE PO_DISTRIBUTIONS 

SB-AP-INVLIN-20122 

INVENTORY_ITEM_ID does NOT exist IN TABLE MTL_SYSTEM_ITEMS. 

SB-AP-INVLIN-20123 

ITEM_DESCRIPTION does NOT exist IN TABLE PO_LINES. 

SB-AP-INVLIN-20124 

QUANTITY_INVOICED value must be a positive whole number. 

SB-AP-INVLIN-20125 

SHIP_TO_LOCATION_CODE does NOT exist IN TABLE PO_LINE_LOCATIONS. 

SB-AP-INVLIN-20126 

DISTRIBUTION_SET_ID does NOT exist IN TABLE AP_DISTRIBUTION_SETS. 

SB-AP-INVLIN-20127 

DISTRIBUTION_SET_NAME does NOT exist IN TABLE AP_DISTRIBUTION_SETS. 

SB-AP-INVLIN-20128 

DIST_CODE_CONCATENATED does NOT exist IN TABLE GL_CODE_COMBINATIONS. 

SB-AP-INVLIN-20129 

AWT_GROUP_ID does NOT exist IN TABLE AP_AWT_GROUPS. 

SB-AP-INVLIN-20130 

AWT_GROUP_NAME does NOT exist IN TABLE AP_AWT_GROUPS. 

SB-AP-INVLIN-20131 

PO_RELEASE_ID does NOT exist IN TABLE PO_RELEASES. 

SB-AP-INVLIN-20132 

RELEASE_NUM does NOT exist IN TABLE PO_RELEASES. 

SB-AP-INVLIN-20133 

RCV_TRANSACTION_ID does NOT exist IN TABLE RCV_TRANSACTIONS. 

SB-AP-INVLIN-20134 

ORG_ID does NOT exist IN VIEW HR_ORGANIZATION_UNITS_V. 

SB-AP-INVLIN-20135 

DIST_CODE_COMBINATION_ID does NOT exist IN TABLE GL_CODE_COMBINATIONS. 

SB-AP-INVLIN-20136 

ACCOUNTING_DATE,the date must be an open accounting period. 

SB-AP-INVLIN-20138 

Valid VALUES FOR PRORATE_ACROSS_FLAG are Y,N. 

SB-AP-INVLIN-20139 

INCOME_TAX_REGION does NOT exist IN AP_INCOME_TAX_TYPES TABLE AND should be active. 

SB-AP-INVLIN-20140 

PO_DISTRIBUTION_ID does NOT exist IN TABLE PO_DISTRIBUTIONS. 

SB-AP-INVLIN-20141 

’TYPE_1099 does NOT exist IN AP_INCOME_TAX_TYPES TABLE AND should be active. 

SB-AP-INVLIN-20142 

TAX_CODE does NOT exist IN AP_INCOME_TAX_TYPES TABLE AND should be active. 

Accounts Receivable

This section provides a description of each of the Accounts Receivable error codes.

Auto Invoice

The Auto Invoice Errors are listed in the table.

Table 1–21 Auto Invoice Errors

Error Code 

Error Message 

SB-AR-DIST-10400 

ACCOUNT_CLASS cannot be NULL. 

SB-AR-DIST-10401 

CODE_COMBINATION_ID does not exists in GL_CODE_COMBINATIONS table. 

SB-AR-DIST-10402 

ACCOUNT_CLASS should be either REV, FREIGHT, TAX, REC, CHARGES, UNBILL, UNEARN. 

SB-AR-LINES-10600 

CONVERSION_TYPE is a required column. Enter a valid value. 

SB-AR-LINES-10601 

BATCH_SOURCE_NAME is a required column. Enter a valid value. 

SB-AR-LINES-10602 

SET_OF_BOOKS_ID is a required column. Enter a valid value. 

SB-AR-LINES-10603 

LINE_TYPE is a required column. Enter a valid value. 

SB-AR-LINES-10604 

DESCRIPTION is a required column. Enter a valid value. 

SB-AR-LINES-10605 

CURRENCY_CODE is a required column. Enter a valid value. 

SB-AR-LINES-10606 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-AR-LINES-10607 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-AR-LINES-10608 

CREATED_BY is a required column. Enter a valid value. 

SB-AR-LINES-10609 

CREATION_DATE is a required column. Enter a valid value. 

SB-AR-LINES-10625 

CONVERSION_TYPE does not exists in GL_DAILY_CONVERSION_TYPES table. 

SB-AR-LINES-10626 

SET_OF_BOOKS_ID does not exists in AR_SYSTEM_PARAMETERS table. 

SB-AR-LINES-10627 

CURRENCY_CODE does not exists in FND_CURRENCIES table. 

SB-AR-LINES-10650 

Valid values for LINE_TYPE column are LINE,TAX,FREIGHT and CHARGES. 

SB-AR-LINES-10651 

ACCOUNTING_RULE_ID value should match with RULE_ID value of RA_RULES Table. 

SB-AR-LINES-10652 

ACCOUNTING_RULE_NAME value should match with NAME value of RA_RULES Table. 

SB-AR-LINES-10653 

AGREEMENT_NAME value should match with NAME value of SO_AGREEMENTS Table. 

SB-AR-LINES-10654 

AGREEMENT_ID value should match with ID value of SO_AGREEMENTS Table. 

SB-AR-LINES-10655 

BATCH_SOURCE_NAME value should match with NAME value of RA_BATCH_SOURCES_ALL Table. 

SB-AR-LINES-10656 

CONS_BILLING_NUMBER must not already exist in AR_CONS_INV_ALL table. 

SB-AR-LINES-10657 

CONVERSION_RATE should be not null if CONVERSION_TYPE is USER and CONVERSION_RATE should be null if CONVERSION_TYPE is not USER. 

SB-AR-LINES-10658 

Valid values for CREDIT_METHOD_FOR_ACCT_RULE column are PRORATE,LIFO,UNIT. 

SB-AR-LINES-10659 

Valid values for CREDIT_METHOD_FOR_INSTALLMENTS column are PRORATE,LIFO,UNIT. 

SB-AR-LINES-10660 

CUST_TRX_TYPE_ID value should match with CUST_TRX_TYPE_ID value of RA_BATCH_SOURCES_ALL Table. 

SB-AR-LINES-10661 

CUST_TRX_TYPE_NAME value should match with NAME value of RA_BATCH_SOURCES_ALL Table. 

SB-AR-LINES-10662 

FOB_POINT value should match with LOOKUP_CODE value of AR_LOOKUPS Table where LOOKUP_TYPE is FOB. 

SB-AR-LINES-10663 

INVENTORY_ITEM_ID value should match with INVENTORY_ITEM_ID value of MTL_SYSTEM_ITEMS Table. 

SB-AR-LINES-10664 

MEMO_LINE_ID value should match with MEMO_LINE_ID value of AR_MEMO_LINES_ALL_B Table. 

SB-AR-LINES-10665 

MEMO_LINE_NAME value should match with NAME value of AR_MEMO_LINES_ALL_B Table. 

SB-AR-LINES-10666 

Enter the appropriate value in ORIG_SYSTEM_BILL_ADDRESS_ID. 

SB-AR-LINES-10667 

Enter the appropriate value in ORIG_SYSTEM_BILL_ADDRESS_REF. 

SB-AR-LINES-10668 

Enter the appropriate value in ORIG_SYSTEM_BILL_CONTACT_ID. 

SB-AR-LINES-10669 

Enter the appropriate value in ORIG_SYSTEM_BILL_CONTACT_REF. 

SB-AR-LINES-10670 

ORIG_SYSTEM_BILL_CUSTOMER_ID value should match with CUST_ACCOUNT_ID value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10671 

ORIG_SYSTEM_BILL_CUSTOMER_REF value should match with ORIG_SYSTEM_REFERENCE value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10672 

Enter the appropriate value in ORIG_SYSTEM_SHIP_ADDRESS_ID. 

SB-AR-LINES-10673 

Enter the appropriate value in ORIG_SYSTEM_SHIP_ADDRESS_REF. 

SB-AR-LINES-10674 

Enter the appropriate value in ORIG_SYSTEM_SHIP_CONTACT_ID. 

SB-AR-LINES-10675 

Enter the appropriate value in ORIG_SYSTEM_SHIP_CONTACT_REF. 

SB-AR-LINES-10676 

ORIG_SYSTEM_SHIP_CUSTOMER_ID value should match with CUST_ACCOUNT_ID value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10677 

ORIG_SYSTEM_SHIP_CUSTOMER_REF value should match with ORIG_SYSTEM_REFERENCE value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10678 

ORIG_SYSTEM_SOLD_CUSTOMER_ID value should match with CUST_ACCOUNT_ID value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10679 

ORIG_SYSTEM_SOLD_CUSTOMER_REF value should match with ORIG_SYSTEM_REFERENCE value of HZ_CUST_ACCOUNTS Table. 

SB-AR-LINES-10680 

PRIMARY_SALESREP_ID value should match with SALESREP_ID value of RA_SALESREPS Table. 

SB-AR-LINES-10681 

PRIMARY_SALESREP_NUMBER value should match with SALESREP_NUMBER value of RA_SALESREPS Table. 

SB-AR-LINES-10682 

PRINTING_OPTION value should match with LOOKUP_CODE value of AR_LOOKUPS Table. 

SB-AR-LINES-10683 

REASON_CODE value should match with LOOKUP_CODE value of AR_LOOKUPS Table. 

SB-AR-LINES-10684 

REASON_CODE_MEANING value should match with MEANING value of AR_LOOKUPS Table. 

SB-AR-LINES-10685 

RECEIPT_METHOD_ID value should match with RECEIPT_METHOD_ID value of AR_RECEIPT_METHODS Table. 

SB-AR-LINES-10686 

RECEIPT_METHOD_NAME value should match with NAME value of AR_RECEIPT_METHODS Table. 

SB-AR-LINES-10687 

Enter the appropriate value in REFERENCE_LINE_CONTEXT. 

SB-AR-LINES-10688 

REFERENCE_LINE_ID value should match with CUSTOMER_TRX_LINE_ID value of RA_CUSTOMER_TRX_LINES Table. 

SB-AR-LINES-10689 

Enter the appropriate value in RELATED_BATCH_SOURCE_NAME. 

SB-AR-LINES-10690 

RELATED_CUSTOMER_TRX_ID value should match with CUSTOMER_TRX_ID value of RA_CUSTOMER_TRX_ALL Table. 

SB-AR-LINES-10692 

Enter the appropriate value in RELATED_TRX_NUMBER. 

SB-AR-LINES-10694 

TAX_CODE value should match with TAX_CODE value of AR_VAT_TAX Table.” 

SB-AR-LINES-10695 

Enter the appropriate value in TAX_EXEMPT_FLAG. 

SB-AR-LINES-10696 

TAX_EXEMPT_REASON_CODE value should match with LOOKUP_CODE value of AR_LOOKUPS Table. 

SB-AR-LINES-10697 

TAX_EXEMPT_REASON_CODE_MEANING value should match with MEANING value of AR_LOOKUPS Table. 

SB-AR-LINES-10698 

TERM_ID value should match with TERM_ID value of RA_TERMS Table. 

SB-AR-LINES-10699 

TERM_NAME value should match with NAME value of RA_TERMS Table. 

SB-AR-LINES-10700 

TERRITORY_ID value should match with TERRITORY_ID value of RA_TERRITORIES Table. 

SB-AR-LINES-10701 

TRX_NUMBER value should not match with TRX_NUMBER value of RA_CUSTOMER_TRX_ALL Table. 

SB-AR-LINES-10702 

UOM_CODE value should match with UOM_CODE value of MTL_UNITS_OF_MEASURE Table. 

SB-AR-LINES-10703 

UOM_NAME value should match with UNIT_OF_MEASURE value of MTL_UNITS_OF_MEASURE Table. 

SB-AR-LINES-10705 

AMOUNT value should be NULL when LINE_TYPE = CHARGES. 

SB-AR-LINES-10706 

AMOUNT_INCLUDES_TAX_FLAG should be either Y or N. 

SB-AR-LINES-10707 

GL_DATE must be OPEN or FUTURE ENTRY accounting period in GL_PERIOD_STATUSES. 

SB-AR-LINES-10708 

INVOICING_RULE_ID value should exist in RULE_ID column of RA_RULES Table. 

SB-AR-LINES-10709 

CUSTOMER_BANK_ACCOUNT_ID value should exist in BANK_ACCOUNT_ID column of AP_BANK_ACCOUNTS_ALL Table. 

SB-AR-LINES-10710 

CUSTOMER_BANK_ACCOUNT_NAME value should exist in BANK_ACCOUNT_NAME column of AP_BANK_ACCOUNTS_ALL Table. 

SB-AR-SALES-10500 

INTERFACE_SALESCREDIT_ID cannot be NULL. 

SB-AR-SALES-10530 

SALES_CREDIT_AMOUNT_SPLIT AND SALES_CREDIT_PERCENT_SPLIT cannot be Null/Not Null. 

SB-AR-SALES-10531 

SALES_CREDIT_AMOUNT_SPLIT cannot be Null and Should be between 0 and 100. 

SB-AR-SALES-10532 

SALES_CREDIT_TYPE_ID cannot be Null and does not exist in SO_SALES_CREDIT_TYPES Table. 

SB-AR-SALES-10533 

SALES_CREDIT_TYPE_NAME cannot be Null and SALES_CREDIT_TYPE_NAME does not exist in SO_SALES_CREDIT_TYPES Table. 

SB-AR-SALES-10534 

SALESREP_ID cannot be Null and SALESREP_ID does not exist in RA_SALESREPS. 

SB-AR-SALES-10535 

SALESREP_NUMBER does not exist in RA_SALESREPS. 

Auto Lock Box

The Auto Lock Box Errors are as listed in the table.

Table 1–22 Auto Lock Box Errors

Error Code 

Error Message 

SB-AR-PAYMENT-10800 

RECORD_TYPE is a required column. Enter a valid value. 

SB-AR-PAYMENT-10801 

ORIGINATION is a required column for record_type as RECEIPT. Enter a valid value. 

SB-AR-PAYMENT-10802 

BATCH_NAME is a required column for record_type as RECEIPT. Enter a valid value. 

SB-AR-PAYMENT-10803 

GL_DATE is a required column for record_type as RECEIPT. Enter a valid value. 

SB-AR-PAYMENT-10804 

REMITTANCE_AMOUNT is a required column for record_type as RECEIPT. Enter a valid value. 

SB-AR-PAYMENT-10805 

RECEIPT_METHOD_ID is a required column for record_type as RECEIPT. Enter a valid value. 

SB-AR-PAYMENT-10815 

TRANSMISSION_ID does not exists in AR_TRANSMISSIONS_ALL table. 

SB-AR-PAYMENT-10816 

RECEIPT_METHOD_ID does not exists in AR_RECEIPT_METHODS table. 

SB-AR-PAYMENT-10817 

CUSTOMER_SITE_USE_ID does not exists in HZ_CUST_SITE_USES_ALL table. 

SB-AR-PAYMENT-10818 

CUSTOMER_BANK_ACCOUNT_ID does not exists in AP_BANK_ACCOUNTS_ALL table. 

SB-AR-PAYMENT-10819 

CUSTOMER_ID does not exists in HZ_CUST_ACCOUNTS table. 

SB-AR-PAYMENT-10850 

RECORD_TYPE value should match with RECORD_IDENTIFIER value of AR_TRANS_RECORD_FORMATS Table. 

SB-AR-PAYMENT-10851 

TRANSMISSION_ID value should match with TRANSMISSION_ID value of AR_TRANSMISSIONS_ALL Table. 

SB-AR-PAYMENT-10852 

CUSTOMER_BANK_ACCOUNT_ID value should match with EXTERNAL_BANK_ACCOUNT_ID value of AP_BANK_ACCOUNT_USES_ALL Table. 

SB-AR-PAYMENT-10853 

Valid value for the STATUS field is either NULL or AR_PLB_NEW_RECORD. 

SB-AR-PAYMENT-10854 

ORIGINATION value should match with BANK_ORIGINATION_NUMBER value of AR_LOCKBOXES_ALL Table. 

SB-AR-PAYMENT-10855 

EXCHANGE_RATE_TYPE value should match with LOOKUP_CODE value of AR_LOOKUPS Table. 

SB-AR-PAYMENT-10856 

CUSTOMER_BANK_NAME value should match with the BANK_NAME value of AP_BANK_BRANCHES table. 

SB-AR-PAYMENT-10857 

REMITTANCE_BANK_NAME value should match with the BANK_NAME value of AP_BANK_BRANCHES table. 

SB-AR-PAYMENT-10858 

CUSTOMER_BANK_BRANCH_NAME value should match with the BANK_BRANCH_NAME value of AP_BANK_BRANCHES table. 

SB-AR-PAYMENT-10859 

CURRENCY_CODE value should match with the CURRENCY_CODE value of FND_CURRENCIES table. 

SB-AR-PAYMENT-10860 

TRANSIT_ROUTING_NUMBER value should match with BANK_NUM value of AP_BANK_BRANCHES Table. 

SB-AR-PAYMENT-10861 

ACCOUNT value should match with BANK_ACCOUNT_NUM value of AP_BANK_ACCOUNTS_ALL Table. 

SB-AR-PAYMENT-10862 

CUSTOMER_BANK_ACCOUNT_ID value should match with BANK_ACCOUNT_ID value of AP_BANK_ACCOUNTS_ALL. 

SB-AR-PAYMENT-10863 

LOCKBOX_NUMBER value should match with LOCKBOX_NUMBER value of AR_LOCKBOXES_ALL table. 

SB-AR-PAYMENT-10864 

BATCH_NAME value should match with NAME value of AR_BATCHES_ALL table. 

Customer Interface

The Customer Interface Errors are as listed in the table.

Table 1–23 Customer Interface Errors

Error Code 

Error Message 

SB-AR-PHONES-10700 

CREATED_BY cannot be NULL. 

SB-AR-PHONES-10701 

CREATION_DATE cannot be NULL. 

SB-AR-PHONES-10702 

INSERT_UPDATE_FLAG cannot be NULL. 

SB-AR-PHONES-10703 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-PHONES-10704 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-PHONES-10705 

ORIG_SYSTEM_CONTACT_REF cannot be NULL. 

SB-AR-PHONES-10706 

ORIG_SYSTEM_TELEPHONE_REF cannot be NULL. 

SB-AR-PHONES-10707 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-PHONES-10708 

CONTACT_JOB_TITLE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10709 

CONTACT_TITLE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10710 

ORIG_SYSTEM_CUSTOMER_REF does not exist in HZ_CUST_ACCOUNTS table. 

SB-AR-PHONES-10711 

ORIG_SYSTEM_ADDRESS_REF does not exist in HZ_CUST_ACCT_SITES_ALL table. 

SB-AR-PHONES-10712 

ORIG_SYSTEM_CONTACT_REF does not exist in HZ_ORG_CONTACTS table. 

SB-AR-PHONES-10713 

ORIG_SYSTEM_TELEPHONE_REF does not exist in HZ_CONTACT_POINTS table. 

SB-AR-PHONES-10714 

TELEPHONE_TYPE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10715 

INSERT_UPDATE_FLAG should be either I or U. 

SB-AR-PHONES-10716 

TELEPHONE cannot be null if ORIG_SYSTEM_TELEPHONE_REF entered. 

SB-AR-PHONES-10717 

CONTACT_LAST_NAME cannot be null if ORIG_SYSTEM_CONTACT_REF entered. 

SB-AR-PHONES-10718 

ORIG_SYSTEM_TELEPHONE_REF cannot be null if TELEPHONE entered. 

SB-AR-PHONES-10719 

TELEPHONE_TYPE cannot be null if ORIG_SYSTEM_TELEPHONE_REF entered. 

SB-AR-PAY-10300 

ORIG_SYSTEM_CUSTOMER_REF is a required column. Enter a valid value. 

SB-AR-PAY-10301 

PAYMENT_METHOD_NAME is a required column. Enter a valid value. 

SB-AR-PAY-10302 

PRIMARY_FLAG is a required column. Enter a valid value. 

SB-AR-PAY-10303 

START_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10304 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-AR-PAY-10305 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10306 

CREATION_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10307 

CREATED_BY is a required column. Enter a valid value. 

SB-AR-PAY-10315 

Valid values for PRIMARY_FLAG column are Y,N. 

SB-AR-PAY-10316 

Valid values for VALIDATED_FLAG column are Y,N. 

SB-AR-PAY-10317 

PAYMENT_METHOD_NAME does not exist in table AR_RECEIPT_METHODS. 

SB-AR-PAY-10318 

ORIG_SYSTEM_CUSTOMER_REF does not exist in table RA_CUSTOMERS and SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PAY-10319 

ORIG_SYSTEM_ADDRESS_REF does not exist in table RA_ADDRESSES and SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PAY-10320 

ORG_ID does not exist IN VIEW HR_ORGANIZATION_UNITS_V. 

SB-AR-BANKS-10200 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-BANKS-10201 

BANK_ACCOUNT_NAME cannot be NULL. 

SB-AR-BANKS-10202 

PRIMARY_FLAG cannot be NULL. 

SB-AR-BANKS-10203 

START_DATE cannot be NULL. 

SB-AR-BANKS-10204 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-BANKS-10205 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-BANKS-10206 

CREATION_DATE cannot be NULL. 

SB-AR-BANKS-10207 

CREATED_BY cannot be NULL. 

SB-AR-BANKS-10208 

BANK_ACCOUNT_CURRENCY_CODE cannot be NULL. 

SB-AR-BANKS-10209 

BANK_ACCOUNT_NUM cannot be NULL. 

SB-AR-BANKS-10210 

BANK_BRANCH_NAME cannot be NULL. 

SB-AR-BANKS-10211 

ORIG_SYSTEM_ADDRESS_REF cannot be NULL if the bank details are entered.Also it should be equal to BILL_TO address. 

SB-AR-BANKS-10212 

BANK_ACCOUNT_CURRENCY_CODE does not exist in FND_CURRENCIES table. 

SB-AR-BANKS-10213 

BANK_ACCOUNT_NAME does not exist in AP_BANK_ACCOUNTS table. 

SB-AR-BANKS-10214 

BANK_NUMBER does not exist in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10215 

BANK_NUM should be unique in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10216 

BANK_BRANCH_COUNTRY does not exist in FND_TERRITORIES table. 

SB-AR-BANKS-10217 

END_DATE should be greater than START_DATE. 

SB-AR-BANKS-10218 

ORIG_SYSTEM_CUSTOMER_REF does not exist in HZ_CUST_ACCOUNTS table. 

SB-AR-BANKS-10219 

PRIMARY_FLAG should be either Y or N. 

SB-AR-BANKS-10220 

BANK_NAME,BANK_BRANCH_NAME should be unique in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10221 

BANK_NAME cannot be NULL. 

SB-AR-BANKS-10222 

ORIG_SYSTEM_ADDRESS_REF does not exist in HZ_CUST_ACCT_SITES_ALL or SB_RA_CUSTOMERS_INTERFACE table.The address specified must have an active BILL_TO site defined. 

SB-AR-CUST-10000 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-CUST-10001 

SITE_USE_CODE cannot be NULL. 

SB-AR-CUST-10002 

ORIG_SYSTEM_ADDRESS_REF cannot be NULL. 

SB-AR-CUST-10003 

INSERT_UPDATE_FLAG cannot be NULL. 

SB-AR-CUST-10004 

CUSTOMER_NAME cannot be NULL. 

SB-AR-CUST-10005 

CUSTOMER_NUMBER cannot be NULL. 

SB-AR-CUST-10006 

CUSTOMER_STATUS cannot be NULL. 

SB-AR-CUST-10007 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-CUST-10008 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-CUST-10009 

CREATED_BY cannot be NULL. 

SB-AR-CUST-10010 

CREATION_DATE cannot be NULL. 

SB-AR-CUST-10011 

LOCATION cannot be NULL. 

SB-AR-CUST-10025 

SITE_USE_CODE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10026 

CUSTOMER_TYPE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10027 

ORIG_SYSTEM_PARENT_REF does not exists in RA_CUSTOMERS table. 

SB-AR-CUST-10028 

CUSTOMER_CATEGORY_CODE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10029 

CUSTOMER_CLASS does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10030 

DEMAND_CLASS_CODE does not exists in FND_COMMON_LOOKUPS table. 

SB-AR-CUST-10031 

CUST_SHIP_VIA_CODE does not exists in ORG_FREIGHT table. 

SB-AR-CUST-10032 

LANGUAGE does not exists in FND_LANGUAGES table. 

SB-AR-CUST-10033 

CUST_TAX_CODE value should match with TAX_CODE value of AR_VAT_TAX Table. 

SB-AR-CUST-10034 

SITE_USE_TAX_CODE value should match with TAX_CODE value of AR_VAT_TAX Table. 

SB-AR-CUST-10050 

ADDRESS cannot be NULL. 

SB-AR-CUST-10051 

INSERT_UPDATE_FLAG should be either I - Insert or U - Update. 

SB-AR-CUST-10052 

CUSTOMER_STATUS should be either A - Active or I - Inactive. 

SB-AR-CUST-10053 

CUSTOMER_TYPE should be either I - Internal or R - External. 

SB-AR-CUST-10054 

PRIMARY_SITE_USE_FLAG should be either Y - Yes or N - No or NULL. 

SB-AR-CUST-10055 

BILL_TO_ORIG_ADDRESS_REFP cannot be NULL. 

SB-AR-CUST-10056 

ORIG_SYSTEM_ADDRESS_REF does not exist in RA_ADDRESSES table. 

SB-AR-CUST-10057 

ORIG_SYSTEM_CUSTOMER_REF Value should be validated against the RA_CUSTOMERS Table based on Insert_Update_Flag Value. 

SB-AR-CUST-10058 

CITY,PROVINCE,STATE,COUNTY,POSTAL CODE, and COUNTRY fields should not be null and have valid data when ADDRESS1 is Not Null. 

SB-AR-CUST-10059 

PRIMARY SITE USE FLAG Should not be null when ADDRESS1 is not null. 

SB-AR-PROFILE-10100 

INSERT_UPDATE_FLAG is a required column. Enter a valid value. 

SB-AR-PROFILE-10101 

ORIG_SYSTEM_CUSTOMER_REF is a required column. Enter a valid value. 

SB-AR-PROFILE-10102 

CREDIT_HOLD is a required column. Enter a valid value. 

SB-AR-PROFILE-10103 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-AR-PROFILE-10104 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-AR-PROFILE-10105 

CREATION_DATE is a required column. Enter a valid value. 

SB-AR-PROFILE-10106 

CREATED_BY is a required column. Enter a valid value. 

SB-AR-PROFILE-10108 

Valid values for CREDIT_BALANCE_STATEMENTS column are Y,N. 

SB-AR-PROFILE-10109 

CREDIT_BALANCE_STATEMENTS must be N when STATEMENTS = N.Mandatory when STATEMENTS =Y. Must be null when STATEMENTS is null. 

SB-AR-PROFILE-10111 

Valid VALUES FOR CREDIT_CHECKING COLUMN are Y,N. 

SB-AR-PROFILE-10112 

Valid VALUES FOR CREDIT_HOLD COLUMN are Y,N. 

SB-AR-PROFILE-10113 

Valid VALUES FOR DISCOUNT_TERMS COLUMN are Y,N. 

SB-AR-PROFILE-10114 

Valid VALUES FOR DUNNING_LETTERS COLUMN are Y,N. 

SB-AR-PROFILE-10115 

Valid VALUES FOR INTEREST_CHARGES COLUMN are Y,N. 

SB-AR-PROFILE-10116 

Valid VALUES FOR STATEMENTS COLUMN are Y,N. 

SB-AR-PROFILE-10117 

Valid VALUES FOR OVERRIDE_TERMS COLUMN are Y,N. 

SB-AR-PROFILE-10118 

Valid VALUES FOR CHARGE_ON_FINANCE_CHARGE_FLAG COLUMN are Y,N.Required IF INTEREST_CHARGES IS SET TO Y AND no PROFILE class IS specified. 

SB-AR-PROFILE-10120 

CHARGE_ON_FINANCE_CHARGE_FLAG not required IF INTEREST_CHARGES IS SET TO N OR NULL. 

SB-AR-PROFILE-10121 

Valid VALUES FOR AUTO_REC_INCL_DISPUTED_FLAG COLUMN are Y,N. 

SB-AR-PROFILE-10122 

Valid VALUES FOR CONS_INV_FLAG COLUMN are Y,N. 

SB-AR-PROFILE-10123 

Valid VALUES FOR CONS_INV_TYPE COLUMN are SUMMARY,DETAIL,WHEN CON_INV_FLAG IS Y. 

SB-AR-PROFILE-10124 

CURRENCY_CODE required IF ANY one OF the following COLUMNS have VALUES. 

SB-AR-PROFILE-10125 

CURRENCY_CODE does not exist IN TABLE FND_CURRENCIES. 

SB-AR-PROFILE-10126 

CUSTOMER_PROFILE_CLASS_NAME does not exist IN TABLE HZ_CUST_PROFILE_CLASSES. 

SB-AR-PROFILE-10127 

IF COLUMN CUSTOMER_PROFILE_CLASS_NAME IS NULL,THEN enter the following COLUMNS COLLECTOR_NAME, CREDIT_BALANCE_STATEMENTS, CREDIT_CHECKING,’ || ’AUTO_REC_INCL_DISPUTED_FLAG, DISCOUNT_TERMS, DUNNING_LETTER, DUNNING_LETTER_SET_NAME, INTEREST_CHARGES, INTEREST_PERIOD_DAYS, CHARGE_ON_FINANCE_CHARGE_FLAG,’ || ’STATEMENTS, STATEMENT_CYCLE_NAME, TOLERANCE, TAX_PRINTING_OPTION, OVERRIDE_TERMS, GROUPING_RULE_NAME, STATEMENTS, CHARGE_ON_FINANCE_CHARGE_FLAG, AUTOCASH_HIERARCHY_NAME. 

SB-AR-PROFILE-10128 

ACCOUNT_STATUS does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10129 

AUTOCASH_HIERARCHY_NAME does not exist IN TABLE AR_AUTOCASH_HIERARCHIES. 

SB-AR-PROFILE-10130 

COLLECTOR_NAME does not exist IN TABLE AR_COLLECTORS. 

SB-AR-PROFILE-10131 

CREDIT_RATING does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10132 

DISCOUNT_GRACE_DAYS Must be greater than OR equal TO 0 AND, must be NULL WHEN DISCOUNT_TERMS IS NULL OR No. 

SB-AR-PROFILE-10133 

DUNNING_LETTER_SET_NAME does not exist IN TABLE AR_DUNNING_LETTER_SETS. 

SB-AR-PROFILE-10134 

DUNNING_LETTER_SET_NAME mandatory WHEN DUNNING_LETTERS IS Yes.Must be NULL WHEN DUNNING_LETTERS IS No OR NULL. 

SB-AR-PROFILE-10135 

GROUPING_RULE_NAME does not exist IN TABLE RA_GROUPING_RULES. 

SB-AR-PROFILE-10136 

INTEREST_PERIOD_DAYS must be greater than OR equal TO zero, mandatory when INTEREST_CHARGES value is Y. Must be NULL when INTEREST_CHARGES value is N OR NULL. 

SB-AR-PROFILE-10137 

ORIG_SYSTEM_CUSTOMER_REF does not exist IN TABLE RA_CUSTOMERS AND SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PROFILE-10138 

ORIG_SYSTEM_ADDRESS_REF does not exist IN TABLE RA_ADDRESSES AND SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PROFILE-10139 

TRX_CREDIT_LIMIT AND OVERALL_CREDIT_LIMIT must both be filled IN,OR both be NULL. 

SB-AR-PROFILE-10140 

RISK_CODE does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10141 

STANDARD_TERM_NAME does not exist IN TABLE RA_TERMS. 

SB-AR-PROFILE-10142 

STATEMENT_CYCLE_NAME does not exist IN TABLE AR_STATEMENT_CYCLES. 

SB-AR-PROFILE-10143 

STATEMENT_CYCLE_NAME must be NULL WHEN STATEMENTS IS No OR NULL. Mandatory WHEN STATEMENTS IS Yes. 

SB-AR-PROFILE-10144 

TAX_PRINTING_OPTION does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10145 

CLEARING_DAYS must be greater than OR equal TO zero. 

SB-AR-PROFILE-10146 

PAYMENT_GRACE_DAYS must be greater than OR equal TO zero. 

SB-AR-PROFILE-10147 

TOLERANCE must be BETWEEN -100 AND 100. 

SB-AR-PROFILE-10148 

ORG_ID does not exist IN VIEW HR_ORGANIZATION_UNITS_V. 

Cash Management

This section provides a description of each of the Cash Management error codes.

Table 1–24 Cash Management Errors

Error Code 

Error Message 

SB-CE-STHDR-30100 

STATEMENT_NUMBER is a required column. Enter a valid value. 

SB-CE-STHDR-30101 

BANK_ACCOUNT_NUM is a required column. Enter a valid value. 

SB-CE-STHDR-30102 

STATEMENT_DATE is a required column. Enter a valid value. 

SB-CE-STHDR-30103 

CURRENCY_CODE is a required column. Enter a valid value. 

SB-CE-STHDR-30107 

CURRENCY_CODE should be the same as the currency code defined for the bank account in AP_Banks_Accounts_All table. 

SB-CE-STHDR-30108 

CURRENCY_CODE does not exist IN TABLE FND_CURRENCIES. 

SB-CE-STHDR-30109 

CONTROL_END_BALANCE should be equal to (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR). 

SB-CE-STHDR-30110 

Valid values for RECORD_STATUS_FLAG column are E,N. 

SB-CE-STHDR-30111 

BANK_ACCOUNT_NUM does not exist IN TABLE AP_Banks_Accounts_All. 

SB-CE-STHDR-30112 

BANK_NAME does not exist IN TABLE AP_Bank_Branches. 

SB-CE-STHDR-30113 

BANK_BRANCH_NAME does not exist IN TABLE AP_Bank_Branches. 

SB-CE-STHDR-30114 

CHECK_DIGITS does not match with check_digits of the bank account number entered IN TABLE AP_Banks_Accounts_All. 

SB-CE-STHDR-30115 

ORG_ID does not exist IN view HR_ORGANIZATION_UNITS_V. 

SB-CE-STATE-30200 

Bank_Account_Num cannot be NULL. 

SB-CE-STATE-30201 

Statement_Number cannot be NULL. 

SB-CE-STATE-30202 

Line_number cannot be NULL. 

SB-CE-STATE-30203 

TRX_DATE cannot be NULL. 

SB-CE-STATE-30204 

Amount cannot be NULL. 

SB-CE-STATE-30205 

TRX_CODE cannot be NULL. 

SB-CE-STATE-30210 

Bank_Account_Num does not exists in SB_CE_STATEMENT_HEAD_INTERFACE. 

SB-CE-STATE-30211 

Statement_Number does not exists in SB_CE_STATEMENT_HEAD_INTERFACE. 

SB-CE-STATE-30212 

Currency_code does not exist in FND_CURRENCIES. 

SB-CE-STATE-30220 

TRX_code does not exist in CE_TRANSACTION_CODES. 

SB-CE-STATE-30221 

Exchange_rate does not exist in GL_DAILY_RATES. 

SB-CE-STATE-30222 

Exchange_rate_date does not exist in GL_DAILY_RATES. 

SB-CE-STATE-30223 

Exchange_rate_type does not exist in GL_DAILY_RATES. 

SB-CE-STATE-30224 

Trx_date cannot be greater than sysdate. 

SB-CE-STATE-30225 

Bank_trx_number does not exist in AP_CHECKS_V. 

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. 

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.