Designing with Application Adapters

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.