Designing with Application Adapters

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.