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. |