Designing: Financial Budget-GL

Financial Budget-GL

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

Accounts Payable.
Accounts Receivable.
Cash Management.
Fixed Assets.
General Ledger.

Accounts Payable

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

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.

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.

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.

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.

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.

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.

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.

Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Designing: Financial Budget-GL