Designing with Application Adapters

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.