This section provides a description of each of the following error code types returned by the validation scripts:
If new Error Codes are needed, you must drop the current sb_errors table and either manually or automatically (through the OTD builder) re-run the sb_install.sql script so that a new sb_errors table is created with new entries.hi.
A description of the validation process is found in Building an Oracle Applications Custom Pre-Validation Package.
This section provides a description of each of the following Manufacturing error codes:
This section provides a description of each of the Inventory error codes.
The Customer Items are listed in the table.
Table 1–2 Customer Item Errors
Error Code |
Error Message |
---|---|
SB-INVCIT-25301 |
Customer_Item_Number is mandatory and the current value is NULL. |
SB-INVCIT-25302 |
Transaction_Type is mandatory and the current value is NULL. |
SB-INVCIT-25303 |
Item_Definition_Level is mandatory and the current value is NULL. |
SB-INVCIT-25304 |
Customer ID, Number and Name are mandatory and the current value is NULL. |
SB-INVCIT-25305 |
Address columns are mandatory and the current value is NULL. |
SB-INVCIT-25306 |
Customer category columns are mandatory and the current value is NULL. |
SB-INVCIT-25307 |
Commodity code columns are mandatory and the current value is NULL. |
SB-INVCIT-25308 |
Container item org columns are mandatory and the current value is NULL. |
SB-INVCIT-25309 |
Model customer item columns are mandatory and the current value is NULL. |
SB-INVCIT-25310 |
Customer_ID is invalid. |
SB-INVCIT-25311 |
Customer_Number is invalid. |
SB-INVCIT-25312 |
Customer_Name is invalid. |
SB-INVCIT-25313 |
Address_ID is invalid. |
SB-INVCIT-25314 |
Customer Category columns are invalid. |
SB-INVCIT-25315 |
Model customer item columns are invalid. |
SB-INVCIT-25316 |
Commodity code is inactive. |
SB-INVCIT-25317 |
Constainer_item_org_id is invalid. |
SB-INVCIT-25318 |
Inactive flag has invalid value. |
SB-INVCIT-25319 |
Container_org_code is invalid. |
SB-INVCIT-25320 |
Container org name is invalid. |
SB-INVCIT-25321 |
Demand tolerance positive value is invalid. |
SB-INVCIT-25322 |
Demand tolerance negative value is invalid. |
SB-INVCIT-25323 |
Min_Fill_Percentage is invalid. |
SB-INVCIT-25324 |
Departure plan required flag is invalid. |
SB-INVCIT-25325 |
Departure plan build flag is invalid. |
SB-INVCIT-25326 |
Departure plan flags combination is invalid. |
The Customer Item Cross-Reference is listed in the table.
Table 1–3 Customer Item Cross-Reference Errors
Error Code |
Error Message |
---|---|
SB-INVCCR-22601 |
Process_flag is mandatory and the current value is NULL. |
SB-INVCCR-22602 |
Process_mode is mandatory and the current value is NULL. |
SB-INVCCR-22603 |
Last_update_date is mandatory and the current value is NULL. |
SB-INVCCR-22604 |
Last_updated_by is mandatory and the current value is NULL. |
SB-INVCCR-22605 |
Creation_date is mandatory and the current value is NULL. |
SB-INVCCR-22606 |
Created_by is mandatory and the current value is NULL. |
SB-INVCCR-22607 |
Transaction_Type is mandatory and the current value is NULL. |
SB-INVCCR-22608 |
Cust_Item_Number is mandatory and the current value is NULL. |
SB-INVCCR-22609 |
Preference_Number is mandatory and the current value is NULL. |
SB-INVCCR-22610 |
Inactive_flag is mandatory and the current value is NULL. |
SB-INVCCR-22611 |
Lock_flag is mandatory and the current value is NULL. |
SB-INVCCR-22612 |
Cust_Category is mandatory and the current value is NULL. |
SB-INVCCR-22613 |
Address is mandatory and the current value is NULL. |
SB-INVCCR-22614 |
Item_Def_Level is mandatory and the current value is NULL. |
SB-INVCCR-22615 |
Customer is mandatory and the current value is NULL. |
SB-INVCCR-22616 |
Customer_ID is invalid. |
SB-INVCCR-22617 |
Customer_No is invalid. |
SB-INVCCR-22618 |
Customer_Name is invalid. |
SB-INVCCR-22619 |
Address_Valid is invalid. |
SB-INVCCR-22620 |
Cust_Cat_Code is invalid. |
SB-INVCCR-22621 |
Customer_item_id is invalid. |
SB-INVCCR-22622 |
Master_Organization_id is invalid. |
SB-INVCCR-22623 |
Inventory_Item_id is invalid. |
SB-INVCCR-22624 |
Inactive_Flag is invalid. |
The Cycle Count Entries are listed in the table.
Table 1–4 Cycle Count Entry Errors
Error Code |
Error Message |
---|---|
SB-INVCCE-23301 |
CC_ENTRY_INTERFACE_ID is mandatory and the current value is NULL. |
SB-INVCCE-23302 |
ORGANIZATION_ID is mandatory and the current value is NULL. |
SB-INVCCE-23303 |
ACTION_CODE is mandatory and the current value is NULL. |
SB-INVCCE-23304 |
EMPLOYEE_ID is mandatory and the current value is NULL. |
SB-INVCCE-23310 |
ADJUSTMENT_ACCOUNT_ID is invalid. |
SB-INVCCE-23311 |
CYCLE_COUNT_ENTRY_ID is invalid. |
SB-INVCCE-23312 |
CYCLE_COUNT_HEADER_ID is invalid. |
SB-INVCCE-23313 |
LOCATOR_ID is invalid. |
SB-INVCCE-23314 |
REVISION is invalid. |
SB-INVCCE-23315 |
LOT_NUMBER is invalid. |
SB-INVCCE-23316 |
ORGANIZATION_ID is invalid. |
SB-INVCCE-23317 |
SUBINVENTORY is invalid. |
SB-INVCCE-23318 |
SERIAL_NUMBER is invalid. |
SB-INVCCE-23319 |
INVENTORY_ITEM_ID is invalid. |
SB-INVCCE-23320 |
TRANSACTION_REASON_ID is invalid. |
SB-INVCCE-23321 |
COUNT_UNIT_OF_MEASURE is invalid. |
SB-INVCCE-23322 |
COUNT_UOM is invalid. |
SB-INVCCE-23330 |
EMPLOYEE_ID value is not valid. |
SB-INVCCE-23331 |
PROJECT_ID value is not valid. |
SB-INVCCE-23332 |
TASK_ID value is not valid. |
SB-INVCCE-23333 |
VALID_FLAG value is not valid. |
SB-INVCCE-23334 |
DELETE_FLAG value is not valid. |
SB-INVCCE-23335 |
LOCK_FLAG value is not valid. |
SB-INVCCE-23336 |
PROCESS_FLAG value is not valid. |
SB-INVCCE-23337 |
PROCESS_MODE value is not valid. |
SB-INVCCE-23338 |
STATUS_FLAG value is not valid. |
The Item Entries are listed in the table.
Table 1–5 Item Errors
Error Code |
Error Message |
---|---|
SB-INVITM-21301 |
Organization_Code or Organization_ID is mandatory and the current value is NULL. |
SB-INVITM-21302 |
item_Number or Segment#s 1 to 20 is mandatory and the current value is NULL. |
SB-INVITM-21303 |
Process_Flag is mandatory and the current value is NULL. |
SB-INVITM-21304 |
Transaction_Type is mandatory and the current value is NULL. |
SB-INVITM-21305 |
Set_Process_ID is mandatory and the current value is NULL. |
SB-INVITM-21306 |
Summary_Flag is invalid. |
SB-INVITM-21307 |
Enabled_Flag is invalid. |
SB-INVITM-21308 |
Purchasing_Item_Flag is invalid. |
SB-INVITM-21309 |
Shippable_Item_Flag is invalid. |
SB-INVITM-21310 |
Customer_Order_Flag is invalid. |
SB-INVITM-21311 |
Internal_Order_Flag is invalid. |
SB-INVITM-21312 |
Service_Item_Flag is invalid. |
SB-INVITM-21313 |
Service_Starting_Delay is less than Zero. |
SB-INVITM-21314 |
Inventory_Item_Flag is invalid. |
SB-INVITM-21315 |
Eng_Item_Flag is invalid. |
SB-INVITM-21316 |
Inventory_Asset_Flag is invalid. |
SB-INVITM-21317 |
Purchasing_Enabled_Flag is invalid. |
SB-INVITM-21318 |
Customer_Order_Enabled_Flag is invalid. |
SB-INVITM-21319 |
Internal_Order_Enabled_Flag is invalid. |
SB-INVITM-21320 |
So_Transactions_Flag is invalid. |
SB-INVITM-21321 |
Mtl_Transactions_Enabled_Flag is invalid. |
SB-INVITM-21322 |
Stock_Enabled_Flag is invalid. |
SB-INVITM-21323 |
Bom_Enabled_Flag is invalid. |
SB-INVITM-21324 |
Build_In_Wip_Flag is invalid. |
SB-INVITM-21325 |
Allow_Item_Desc_Update_Flag is invalid. |
SB-INVITM-21326 |
Receipt_Required_Flag is invalid. |
SB-INVITM-21327 |
Rfq_Required_Flag is invalid. |
SB-INVITM-21328 |
Planning_Time_Fence_Days is less than Zero. |
SB-INVITM-21329 |
Pick_Components_Flag is invalid. |
SB-INVITM-21330 |
Replenish_To_Order_Flag is invalid. |
SB-INVITM-21331 |
ATP_Components_Flag is invalid. |
SB-INVITM-21332 |
Cost_Of_Sales_Account is invalid. |
SB-INVITM-21333 |
Sales_Account is invalid. |
SB-INVITM-21334 |
Encumbrance_Account is invalid. |
SB-INVITM-21335 |
Expense_Account is invalid. |
SB-INVITM-21336 |
List_Price_Per_Unit is less than Zero. |
SB-INVITM-21337 |
Taxable_Flag is invalid. |
SB-INVITM-21338 |
Expense_Billable_Flag is invalid. |
SB-INVITM-21339 |
Time_Billable_Flag is invalid. |
SB-INVITM-21340 |
Service_Duration is invalid. |
SB-INVITM-21341 |
Market_Price is less than Zero. |
SB-INVITM-21342 |
Price_Tolerance_Percent is less than Zero. |
SB-INVITM-21343 |
Shelf_Life_Days is less than Zero. |
SB-INVITM-21344 |
Repetitive_Planning_Flag is invalid. |
SB-INVITM-21345 |
Acceptable_Rate_Decrease is less than Zero. |
SB-INVITM-21346 |
Acceptable_Rate_Increase is less than Zero. |
SB-INVITM-21347 |
Assembly_Pegging_Flag is invalid. |
SB-INVITM-21348 |
Postprocessing_Lead_Time is less than Zero. |
SB-INVITM-21349 |
Vendor_Warranty_Flag is invalid. |
SB-INVITM-21350 |
Serviceable_Component_Flag is invalid. |
SB-INVITM-21351 |
Serviceable_Product_Flag is invalid. |
SB-INVITM-21352 |
Preventive_Maintenance_Flag is invalid. |
SB-INVITM-21353 |
Ship_Model_Complete_Flag is invalid. |
SB-INVITM-21354 |
Prorate_Service_Flag is invalid. |
SB-INVITM-21355 |
Invoiceable_Item_Flag is invalid. |
SB-INVITM-21356 |
Invoice_Enabled_Flag is invalid. |
SB-INVITM-21357 |
Must_Use_Approved_Vendor_Flag is invalid. |
SB-INVITM-21358 |
Outside_Operation_Flag is invalid. |
SB-INVITM-21359 |
Costing_Enabled_Flag is invalid. |
SB-INVITM-21360 |
Cycle_Count_Enabled_Flag is invalid. |
SB-INVITM-21361 |
Auto_Created_Config_Flag is invalid. |
SB-INVITM-21362 |
Container_Item_Flag is invalid. |
SB-INVITM-21363 |
Vehicle_Item_Flag is invalid. |
SB-INVITM-21364 |
Check_Org_ID_Code is invalid. |
SB-INVITM-21365 |
Wip_Supply_Type is invalid. |
SB-INVITM-21366 |
Lot_Control_Code is invalid. |
SB-INVITM-21367 |
Shelf_Life_Code is invalid. |
SB-INVITM-21368 |
Serial_Number_Control_Code is invalid. |
SB-INVITM-21369 |
Restrict_Subinventories_Code is invalid. |
SB-INVITM-21370 |
Restrict_Locators_Code is invalid. |
SB-INVITM-21371 |
Planning_Time_Fence_Code is invalid. |
SB-INVITM-21372 |
Bom_Item_Type is invalid. |
SB-INVITM-21373 |
Allowed_Units_Lookup_Code is invalid. |
SB-INVITM-21374 |
Inventory_Planning_Code is invalid. |
SB-INVITM-21375 |
Planning_Make_Buy_Code is invalid. |
SB-INVITM-21376 |
Mrp_Safety_Stock_Code is invalid. |
SB-INVITM-21377 |
Material_Billable_Flag is invalid. |
SB-INVITM-21378 |
Reservable_Type is invalid. |
SB-INVITM-21379 |
Return_Inspection_Requirement is invalid. |
SB-INVITM-21380 |
Mrp_Planning_Code is invalid. |
SB-INVITM-21381 |
Location_Control_Code is invalid. |
SB-INVITM-21382 |
ITEM DESCRIPTION FIELD CANNOT BE NULL. |
The Item Revisions are listed in the table.
Table 1–6 Item Revision Errors
Error Code |
Error Message |
---|---|
SB-INVREV-22500 |
Set_process_ID is mandatory and the current value is NULL. |
SB-INVREV-22501 |
Inventory_Item_ID is mandatory and the current value is NULL. |
SB-INVREV-22502 |
Organization_ID is mandatory and the current value is NULL. |
SB-INVREV-22503 |
Revision is mandatory and the current value is NULL. |
SB-INVREV-22504 |
Change_Notice is invalid. |
SB-INVREV-22505 |
Organization_id is invalid. |
SB-INVREV-22506 |
Inventory_item_id is invalid. |
SB-INVREV-22507 |
Primary_key is invalid. |
SB-INVREV-22508 |
Process_flag is invalid. |
SB-INVREV-22509 |
Item_Number is invalid. |
Master
The Replenishment Master Errors are listed in the table.
Table 1–7 Replenishment Master Errors
Error Code |
Error Message |
---|---|
SB-INVREP-22430 |
Header has lines that have failed validation. |
Headers
The Replenishment Header Errors are listed in the table.
Table 1–8 Replenishment Header Errors
Error Code |
Error Message |
---|---|
SB-INVREP-22301 |
Replenishment_Header_ID is mandatory and the current value is NULL. |
SB-INVREP-22302 |
Replenishment_Count_Name is mandatory and the current value is NULL. |
SB-INVREP-22303 |
Count_Date is mandatory and the current value is NULL. |
SB-INVREP-22304 |
Last_Update_Date is mandatory and the current value is NULL. |
SB-INVREP-22305 |
Creation_Date is mandatory and the current value is NULL. |
SB-INVREP-22306 |
Created_By is mandatory and the current value is NULL. |
SB-INVREP-22307 |
Last_Updated_By is mandatory and the current value is NULL. |
SB-INVREP-22308 |
Organization_ID is mandatory and the current value is NULL. |
SB-INVREP-22309 |
SubInventory_Code is mandatory and the current value is NULL. |
SB-INVREP-22310 |
Process_Status is mandatory and the current value is NULL. |
SB-INVREP-22311 |
Process_Mode is mandatory and the current value is NULL. |
SB-INVREP-22312 |
Organization_ID is invalid. |
SB-INVREP-22313 |
SubInventory_Code is invalid. |
SB-INVREP-22314 |
Error_Flag is invalid. |
SB-INVREP-22315 |
Process_Mode is invalid. |
SB-INVREP-22316 |
Process_Status is invalid. |
SB-INVREP-22317 |
Replenish_Header is invalid. |
SB-INVREP-22318 |
Replenish_Count is invalid. |
SB-INVREP-22319 |
Last_Update is invalid. |
SB-INVREP-22320 |
Lines is invalid. |
Lines
The Replenishment Line Errors are listed in the table.
Table 1–9 Replenishment Line Errors
Error Code |
Error Message |
---|---|
SB-INVREP-22401 |
Replenishment_Header_ID is mandatory and the current value is NULL |
SB-INVREP-22402 |
Replenishment_Line_ID is mandatory and the current value is NULL |
SB-INVREP-22403 |
Last_Update_Date is mandatory and the current value is NULL |
SB-INVREP-22404 |
Creation_Date is mandatory and the current value is NULL |
SB-INVREP-22405 |
Created_By is mandatory and the current value is NULL |
SB-INVREP-22406 |
Last_Update_Login is mandatory and the current value is NULL |
SB-INVREP-22407 |
Last_Updated_By is mandatory and the current value is NULL |
SB-INVREP-22408 |
Inventory_Item_ID is mandatory and the current value is NULL |
SB-INVREP-22409 |
Count_Type_Code is mandatory and the current value is NULL |
SB-INVREP-22410 |
Count_Quantity is mandatory and the current value is NULL |
SB-INVREP-22411 |
Count_UOM is mandatory and the current value is NULL |
SB-INVREP-22412 |
Count_UOM_Code is mandatory and the current value is NULL |
SB-INVREP-22413 |
Organization_ID is invalid. |
SB-INVREP-22414 |
Rep_Header_ID is invalid. |
SB-INVREP-22415 |
Inventory_Item_ID is invalid. |
SB-INVREP-22416 |
Count_Uom is invalid. |
SB-INVREP-22417 |
Count_Uom_Code is invalid. |
SB-INVREP-22418 |
Segment is invalid. |
SB-INVREP-22419 |
Count_Type_Code is invalid. |
SB-INVREP-22420 |
Organization_ID is invalid. |
SB-INVREP-22421 |
Count_Type_Tracked is invalid. |
SB-INVREP-22421 |
Count_Type_Tracked23 is invalid. |
SB-INVREP-22422 |
Inventory_item is invalid. |
SB-INVREP-22423 |
MinMAx_Plan is invalid. |
SB-INVREP-22424 |
Count_Uom_Primary is invalid. |
Transactions
The Transaction Errors are listed in the table.
Table 1–10 Transaction Errors
Error Code |
Error Message |
---|---|
SB-INVTXN-20301 |
Source Code is mandatory and the current value is NULL. |
SB-INVTXN-20302 |
Source Line ID is mandatory and the current value is NULL. |
SB-INVTXN-20303 |
Source Header ID is mandatory and the current value is NULL. |
SB-INVTXN-20304 |
Process Flag is mandatory and the current value is NULL. |
SB-INVTXN-20305 |
Transaction Mode is mandatory and the current value is NULL. |
SB-INVTXN-20306 |
Transaction Interface ID is mandatory and the current value is NULL. |
SB-INVTXN-20307 |
Inventory Item ID is mandatory and the current value is NULL. |
SB-INVTXN-20308 |
Organization ID is mandatory and the current value is NULL. |
SB-INVTXN-20309 |
Transaction Quantity is mandatory and the current value is NULL. |
SB-INVTXN-20310 |
Transaction UOM is mandatory and the current value is NULL. |
SB-INVTXN-20311 |
Transaction Date is mandatory and the current value is NULL. |
SB-INVTXN-20312 |
Transaction Source ID is mandatory and the current value is NULL. |
SB-INVTXN-20313 |
Transaction Source Name is mandatory and the current value is NULL. |
SB-INVTXN-20314 |
Transaction Type ID is mandatory and the current value is NULL. |
SB-INVTXN-20319 |
Distribution Account ID is invalid. |
SB-INVTXN-20320 |
Inventory Item ID is invalid. |
SB-INVTXN-20321 |
Organization ID is invalid. |
SB-INVTXN-20322 |
Acct Period ID is invalid. |
SB-INVTXN-20323 |
Schedule ID is invalid. |
SB-INVTXN-20324 |
Operation Seq Num is invalid. |
SB-INVTXN-20325 |
Transportation Account is invalid. |
SB-INVTXN-20326 |
Locator ID is invalid. |
SB-INVTXN-20327 |
Transfer Organization is invalid. |
SB-INVTXN-20328 |
Transfer Locator is invalid. |
SB-INVTXN-20329 |
Revision is invalid. |
SB-INVTXN-20330 |
SubInventory Code is invalid. |
SB-INVTXN-20331 |
Transfer SubInventory is invalid. |
SB-INVTXN-20332 |
Schedule Number is invalid. |
SB-INVTXN-20333 |
Reason ID is invalid. |
SB-INVTXN-20334 |
Wip Entity Type is invalid. |
SB-INVTXN-20335 |
Substitution Type ID is invalid. |
SB-INVTXN-20344 |
Transaction Header ID is invalid. |
Lots
The Transaction Lots Errors are listed in the table.
Table 1–11 Transaction Lots Errors
Error Code |
Error Message |
---|---|
SB-INVTXN-20336 |
Transaction Interface ID is mandatory and the current value is NULL. |
SB-INVTXN-20337 |
Lot Number is mandatory and the current value is NULL. |
SB-INVTXN-20338 |
Transaction Quantity is mandatory and the current value is NULL. |
SB-INVTXN-20339 |
Transaction Temp ID is invalid. |
SB-INVTXN-20340 |
Transaction Interface ID is invalid. |
Serial Numbers
The Transaction Serial Number Errors are listed in the table.
Table 1–12 Transaction Serial Number Errors
Error Code |
Error Message |
---|---|
SB-INVTXN-20341 |
Transaction Interface ID is mandatory and the current value is NULL. |
SB-INVTXN-20342 |
Fm Serial Number is mandatory and the current value is NULL. |
SB-INVTXN-20343 |
Vendor Serial Number is invalid. |
This section provides a description of each of the Purchase Order error codes.
Master
The Import Master Errors are listed in the table.
Table 1–13 Import Master Errors
Error Code |
Error Message |
---|---|
SB-POIMP-20001 |
Header record does not exist for Po_Header_ID. |
SB-POIMP-25006 |
Header has lines that have failed validation. |
Headers
The Import Header Errors are listed in the table.
Table 1–14 Import Header Errors
Error Code |
Error Message |
---|---|
SB-POIMP-20002 |
Interface Header ID is mandatory and the current value is NULL. |
SB-POIMP-20003 |
Action is mandatory and the current value is NULL. |
SB-POIMP-20004 |
Document Type Code is mandatory and the current value is NULL. |
SB-POIMP-20006 |
Vendor Site Code is mandatory and the current value is NULL. |
SB-POIMP-20007 |
Vendor Doc Num is mandatory and the current value is NULL. |
SB-POIMP-20008 |
Action is mandatory and the current value is invalid. |
SB-POIMP-20009 |
Document Type Code is mandatory and the current value is invalid. |
SB-POIMP-20010 |
Vendor ID is invalid. |
SB-POIMP-20011 |
From Type Lookup Code is invalid. |
SB-POIMP-20012 |
Ship To Location ID is invalid. |
SB-POIMP-20013 |
Terms ID is invalid. |
SB-POIMP-20014 |
Ussgl Transaction Code is invalid. |
SB-POIMP-20015 |
Buyer specified is invalid. |
SB-POIMP-20016 |
Bill To Location ID is invalid. |
SB-POIMP-20017 |
Vendor Site ID is invalid. |
SB-POIMP-20018 |
Vendor Contact ID is invalid. |
SB-POIMP-20019 |
From Header ID is invalid. |
SB-POIMP-20020 |
Rate Type is invalid. |
SB-POIMP-20021 |
Currency Code is invalid. |
SB-POIMP-20022 |
Document Number is invalid. |
SB-POIMP-20023 |
Buyer Name is invalid. |
SB-POIMP-20024 |
Vendor Name or Vendor Num is invalid. |
SB-POIMP-20025 |
Vendor Site Code is invalid. |
SB-POIMP-20026 |
Vendor Contact is invalid. |
SB-POIMP-20027 |
Ship To Location Code is invalid. |
SB-POIMP-20028 |
Bill To Location Code is invalid. |
SB-POIMP-20029 |
Payment Terms is invalid. |
SB-POIMP-20030 |
Rfq Num is invalid. |
SB-POIMP-20031 |
Amount Limit is less than Amount Agreed. |
SB-POIMP-20032 |
Amount Limit is less than Min Release Amount. |
SB-POIMP-20033 |
Amount Limit is less than Zero. |
SB-POIMP-20088 |
Release Number is invalid. |
SB-POIMP-25007 |
Document Type is Standard, so Action cannot be Update or Replace. |
SB-POIMP-25008 |
Document Type is Standard, so Approval Status must be Incomplete. |
SB-POIMP-25009 |
Vendor Doc Num does not exist. |
SB-POIMP-25010 |
Vendor Doc Num already exists. |
SB-POIMP-25011 |
Release Date is reserved for future use and must be NULL. |
SB-POIMP-25012 |
Document Num must have a unique value, Current value already exists. |
SB-POIMP-25013 |
There must be at least one line per header document. |
SB-POIMP-25014 |
Fob_Active is invalid. |
SB-POIMP-25015 |
Freight_Terms_Active is invalid. |
SB-POIMP-25016 |
Document_Sub_Type is invalid. |
SB-POIMP-25017 |
Num_Of_Lines is invalid. |
Lines
The Import Line Errors are listed in the table.
Table 1–15 Import Line Errors
Error Code |
Error Message |
---|---|
SB-POIMP-20034 |
Interface Header ID is mandatory and the current value is NULL. |
SB-POIMP-20035 |
Interface Line ID is mandatory and the current value is NULL. |
SB-POIMP-20036 |
Organization ID is mandatory and the current value is NULL. |
SB-POIMP-20037 |
Po Header ID not found for modification. |
SB-POIMP-20038 |
Category ID is invalid. |
SB-POIMP-20039 |
Line Type ID is invalid. |
SB-POIMP-20040 |
Un Number ID is invalid. |
SB-POIMP-20041 |
Hazard Class ID is invalid. |
SB-POIMP-20042 |
Ussgl Transaction Code is invalid. |
SB-POIMP-20043 |
Closed By is invalid. |
SB-POIMP-20044 |
From Header ID is invalid. |
SB-POIMP-20045 |
From Line ID is invalid. |
SB-POIMP-20046 |
Tax Name is invalid. |
SB-POIMP-20047 |
Item Revision is invalid. |
SB-POIMP-20048 |
Unit Of Measure is invalid. |
SB-POIMP-20049 |
Unit Of Measure is invalid for the Item ID/Organization ID. |
SB-POIMP-20050 |
Item ID is invalid. |
SB-POIMP-20052 |
Item is invalid. |
SB-POIMP-20054 |
Uom Code is invalid. |
SB-POIMP-20055 |
Line Type is invalid. |
SB-POIMP-20056 |
Line Num is invalid. |
SB-POIMP-20057 |
Shipment Num is invalid. |
SB-POIMP-20058 |
Un Number is invalid. |
SB-POIMP-20059 |
Hazard Class is invalid. |
SB-POIMP-20060 |
Ship To Organization Code is invalid. |
SB-POIMP-20061 |
Ship To Location Code is invalid. |
SB-POIMP-20062 |
Template Name is invalid. |
SB-POIMP-20063 |
Payment Terms is invalid. |
SB-POIMP-20064 |
Receiving Routing is invalid. |
SB-POIMP-20065 |
Tax Code ID is invalid. |
SB-POIMP-20066 |
Not To Exceed Price must be NULL since Allow Price Override Flag is N. |
SB-POIMP-20067 |
Not To Exceed Price has to be greater or equal to Unit Price. |
SB-POIMP-20068 |
Max Order Quantity must be greater than Min Order Quantity. |
SB-POIMP-20069 |
Closed Code must be null for QUOTATION Document Type. |
SB-POIMP-20070 |
Committed Amount must be null for QUOTATION Document Type. |
SB-POIMP-20071 |
Market Price must be null for QUOTATION Document Type. |
SB-POIMP-20072 |
Allow Price Override Flag must be null for QUOTATION Document Type. |
SB-POIMP-20073 |
Not To Exceed Price must be null for QUOTATION Document Type. |
SB-POIMP-20074 |
Negotiated By Preparer Flag must be null for QUOTATION Document Type. |
SB-POIMP-20075 |
Capital Expense Flag must be null for QUOTATION Document Type. |
SB-POIMP-20076 |
Min Release Amount for QUOTATION/BLANKET Document Type. |
SB-POIMP-20077 |
Min Order Quantity is less than 0. |
SB-POIMP-20078 |
Max Order Quantity is less than 0. |
SB-POIMP-20079 |
Over Tolerance Error Flag must be either Y or N. |
SB-POIMP-20080 |
Qty Rcv Tolerance must be NULL for BLANKET Document Type. |
SB-POIMP-20081 |
Qty Rcv Exception Code must be NULL for BLANKET Document Type. |
SB-POIMP-20082 |
Freight Carrier must be NULL for BLANKET Document Type. |
SB-POIMP-20083 |
Fob must be NULL for BLANKET Document Type. |
SB-POIMP-20084 |
Freight Terms must be NULL for BLANKET Document Type. |
SB-POIMP-20085 |
Receipt Required Flag must be NULL for BLANKET Document Type. |
SB-POIMP-20086 |
Inspection Required Flag must be NULL for BLANKET Document Type. |
SB-POIMP-20087 |
Unit Price must not be NULL or < 0. |
SB-POIMP-20088 |
Release Num is reserved for future use and must be NULL. |
SB-POIMP-20089 |
Po Release ID is reserved for future use and must be NULL. |
SB-POIMP-20090 |
Source Shipment ID is reserved for future use and must be NULL. |
SB-POIMP-20091 |
Contract Num is reserved for future use and must be NULL. |
SB-POIMP-20092 |
Type 1099 must be NULL. |
SB-POIMP-20093 |
Receipt Days Exception Code must be NULL. |
SB-POIMP-20094 |
Need By Date must be NULL. |
SB-POIMP-20095 |
Promised Date must be NULL. |
SB-POIMP-20096 |
Closed Reason must be NULL. |
SB-POIMP-20097 |
Closed Date must be NULL. |
SB-POIMP-20098 |
Closed By must be NULL. |
SB-POIMP-20099 |
Firm Flag must be NULL. |
SB-POIMP-20100 |
Quantity must be greater than 0. |
SB-POIMP-25001 |
Committed Amount must be greater than 0. |
SB-POIMP-25002 |
Market Price must be greater than 0. |
SB-POIMP-25003 |
Negotiated By Preparer Flag must be either Y or N. |
SB-POIMP-25004 |
Capital Expense Flag must be either Y or N. |
SB-POIMP-25005 |
Tax name and Tax Code ID must be NULL if Taxable Flag is NULL or N. |
SB-POIMP-25014 |
FOB is inactive. |
SB-POIMP-25015 |
Freight_Terms is inactive. |
Master
The Receiving Master Errors are listed in the table.
Table 1–16 Receiving Master Errors
Error Code |
Error Message |
---|---|
SB-POREC-25006 |
Header has lines that have failed validation. |
Headers
The Receiving Header Errors are listed in the table.
Table 1–17 Receiving Header Errors
Error Code |
Error Message |
---|---|
SB-POREC-20100 |
Header_Interface_ID field is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20101 |
Group_ID field is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20102 |
Processing_Status_Code field is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20103 |
Receipt_Source_Code field is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20104 |
Transaction_Type field is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20105 |
Value Required in Vendor_Name or Vendor_Num field in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20106 |
Validation_Flag is mandatory in RCV_HEADERS_INTERFACE table and current value is null. |
SB-POREC-20107 |
ASN_TYPE field in RCV_HEADERS_INTERFACE must be ASN or ASBN. |
SB-POREC-20108 |
Processing_Status_Code field in RCV_HEADERS_INTERFACE must be PENDING. |
SB-POREC-20109 |
Receipt_Source_Code field in RCV_HEADERS_INTERFACE must be VENDOR. |
SB-POREC-20110 |
Transaction_Type field in RCV_HEADERS_INTERFACE must be NEW or CANCEL. |
SB-POREC-20111 |
Validation_Flag field in RCV_HEADERS_INTERFACE must be Y or N. |
SB-POREC-20112 |
Auto_Transact_Code field in RCV_HEADERS_INTERFACE must be SHIP or RECEIVE or DELIVER. |
SB-POREC-20113 |
Receipt_Num cannot be NULL when Auto_Transact_Code is SHIP. |
SB-POREC-20114 |
Shipped_Date cannot be NULL when Asn_Type is ASN or ASBN. |
SB-POREC-20115 |
Invoice_Num cannot be NULL when Asn_Type is ASBN. |
SB-POREC-20116 |
Invoice_Date cannot be NULL when Asn_Type is ASBN. |
SB-POREC-20117 |
Total_Invoice_Amount cannot be NULL or negative when Asn_Type is ASBN. |
SB-POREC-20118 |
Both Employee_ID and Employee_Name cannot be null when Auto_Transact_Code is RECEIVE. |
SB-POREC-20119 |
Invalid Vendor_Name. |
SB-POREC20189 |
Shipped_Date cannot be earlier than SYSDATE or EXPECTED_RECEIPT_DATE. |
SB-POREC20190 |
Invalid Employee_name. |
Transactions
The Receiving Transaction Errors are listed in the table.
Table 1–18 Receiving Transaction Errors
Error Code |
Error Message |
---|---|
SB-POREC-20120 |
Interface_Transaction_ID field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20121 |
Group_ID field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20122 |
Transaction_Type field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20123 |
Transaction_Date field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20124 |
Processing_Status_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20125 |
Processing_Mode_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20126 |
Transaction_Status_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20127 |
Quantity field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20128 |
Unit_Of_Measure field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20129 |
Item_Description field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20130 |
Value required in Document_Line_Num or Item_Num or Vendor_Item_Num or Item_ID or Po_Line_ID in rcv_transactions_interface table and currently all are null. |
SB-POREC-20131 |
Auto_Transact_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20132 |
Receipt_Source_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20133 |
Vendor_Site_ID field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20134 |
Value required in either Vendor_Name or Vendor_Num fields in rcv_transactions_interface table and currently both are null. |
SB-POREC-20135 |
Source_Document_Code field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20136 |
Value required in Document_Num or Po_Header_ID and currently both are null. |
SB-POREC-20137 |
Header_Interface_ID field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20138 |
Validation_Flag field is mandatory in rcv_transactions_interface table and current value is null. |
SB-POREC-20139 |
FK Validation. Invalid Routing_Header_ID. |
SB-POREC-20140 |
FK Validation. Invalid Routing_Step_ID. |
SB-POREC-20141 |
FK Validation. Invalid Parent_Transaction_ID. |
SB-POREC-20142 |
FK Validation. Invalid Po_Header_ID. |
SB-POREC-20143 |
FK Validation. Invalid Po_Line_ID. |
SB-POREC-20144 |
FK Validation. Invalid Po_Line_Location_ID. |
SB-POREC-20145 |
FK Validation. Invalid Inv_Transaction_ID. |
SB-POREC-20146 |
FK Validation. Invalid Po_Distribution_ID. |
SB-POREC-20147 |
FK Validation. Invalid Po_Release_ID. |
SB-POREC-20148 |
Foreign Key Validation. Invalid Requisition_Line_ID. |
SB-POREC-20149 |
FK Validation. Invalid Requisition_Distribution_ID. |
SB-POREC-20150 |
FK Validation. Invalid Inspection_Quality_Code. |
SB-POREC-20151 |
FK Validation. Invalid Charge_Account_ID. |
SB-POREC-20152 |
FK Validation. Invalid Employee_ID. |
SB-POREC-20153 |
FK Validation. Invalid Wip_Entity_ID. |
SB-POREC-20154 |
FK Validation. Invalid Item_ID. |
SB-POREC-20155 |
FK Validation. Invalid Transportation_Account_ID. |
SB-POREC-20156 |
FK Validation. Invalid Wip_Line_ID. |
SB-POREC-20157 |
FK Validation. Invalid Repetitive_Schedule_ID. |
SB-POREC-20158 |
Foreign Key Validation. Invalid Wip_Entity_ID for wip_operations. |
SB-POREC-20159 |
FK Validation. Invalid Wip_Entity_ID for wip_operations_resources. |
SB-POREC-20160 |
FK Validation. Invalid Bom_Resource_ID. |
SB-POREC-20161 |
FK Validation. Invalid Department_Code. |
SB-POREC-20162 |
FK Validation. Invalid Freight_Carrier_Code. |
SB-POREC-20163 |
FK Validation. Invalid SubInventory. |
SB-POREC-20164 |
FK Validation. Invalid Locator_ID. |
SB-POREC-20165 |
FK Validation. Invalid Uom_Code. |
SB-POREC-20166 |
FK Validation. Invalid Currency_Conversion_Type. |
SB-POREC-20167 |
FK Validation. Invalid Reason_ID. |
SB-POREC-20168 |
FK Validation. Invalid Source_Doc_Unit_Of_Measure. |
SB-POREC-20170 |
FK Validation. Invalid Shipment_Header_ID. |
SB-POREC-20171 |
FK Validation. Invalid Shipment_Line_ID. |
SB-POREC-20172 |
FK Validation. Invalid Primary_Unit_Of_Measure. |
SB-POREC-20173 |
Value required in any one of Item_Category or Category_ID or Document_Line_Num or Po_Line_ID field in rcv_transactions_interface. |
SB-POREC-20174 |
Transaction_Type must be SHIP or RECEIVE. |
SB-POREC-20175 |
Processing_Status_Code must be PENDING. |
SB-POREC-20176 |
Processing_Mode_Code must be BATCH. |
SB-POREC-20177 |
Auto_Transact_Code must be RECEIVE or DELIVER or SHIP. |
SB-POREC-20178 |
Receipt_Source_Code must be VENDOR. |
SB-POREC-20179 |
Source_Document_Code must be PO. |
SB-POREC-20180 |
Header_Interface_ID value not found in rcv_headers_interface. |
SB-POREC-20181 |
Validation_Flag must be Y or N. |
SB-POREC-20182 |
Employee_ID cannot be null when Transaction_Type is DELIVER. |
SB-POREC-20183 |
Valid Group_ID not found in rcv_headers_interface. |
SB-POREC-20184 |
Invalid Ship_To_Location_Code or Ship_To_Location_ID when ASN_TYPE is ASN. |
SB-POREC-20185 |
To_Organization_Code and To_Organization_ID, both cannot be null. |
SB-POREC-20186 |
There must be a valid Destination_Type_Code when Auto_Transact_Code is DELIVER. |
SB-POREC-20187 |
Invalid Expected_Receipt_Date. |
SB-POREC-20188 |
Transaction_Status_Code must be ERROR or COMPLETED. |
SB-POREC-20191 |
Invalid Item_Category. |
SB-POREC-20192 |
Invalid Location_Code. |
SB-POREC-20193 |
Invalid Vendor_Name. |
SB-POREC-20194 |
Invalid Vendor_Num. |
The Requisition Errors are listed in the table.
Table 1–19 Requisition Errors
Error Code |
Error Message |
---|---|
SB-POREQ-20100 |
Interface_Source_Code is mandatory and the current value is NULL. |
SB-POREQ-20101 |
Destination_Type_Code is mandatory and the current value is NULL. |
SB-POREQ-20102 |
Authorization_Status is mandatory and the current value is NULL. |
SB-POREQ-20103 |
Quantity is mandatory and the current value is NULL. |
SB-POREQ-20104 |
Preparer_ID and Preparer_Name values are NULL. Either one must have a value. |
SB-POREQ-20105 |
Charge_Account_ID and Charge_Account_Segment1 values are NULL. Either one must have a value. |
SB-POREQ-20106 |
Destination_Organization_ID and Destination_Organization_Code values are NULL. Either one must have a value. |
SB-POREQ-20107 |
Deliver_To_Location_ID and Deliver_To_Location_Code values are NULL. Either one must have a value. |
SB-POREQ-20108 |
Deliver_To_Requestor_ID and Deliver_To_Requestor_Name values are NULL. Either one must have a value. |
SB-POREQ-20109 |
If Currency_Code value present Rate_Date and Rate_Type are mandatory. |
SB-POREQ-20110 |
If Project_Accounting_Context is Y then you must enter relevent project accounting info like project_id,task_id,expenditure_type and expenditure_org_id. |
SB-POREQ-20111 |
If Destination_Type_code is INVENTORY then you must enter Destination_Subinventory and Item_ID. |
SB-POREQ-20112 |
If Source_Type_Code is INVENTORY then you must enter Item_ID. |
SB-POREQ-20113 |
If Destination_Type_Code is EXPENSE or SHOP FLOOR then you must Source_Type_Code. |
SB-POREQ-20114 |
Requisition_Type value either INTERNAL or PURCHASE. |
SB-POREQ-20115 |
Requisition Header ID is invalid,FK validation failed against po_requisition_headers_all table. |
SB-POREQ-20116 |
Category ID is invalid,FK validation failed against mtl_categories_b table. |
SB-POREQ-20117 |
Unit_Of_Measure is invalid,FK validation failed against mtl_units_of_measure_tl table. |
SB-POREQ-20118 |
Line_Type_ID is invalid,FK validation failed against po_line_types_b table. |
SB-POREQ-20119 |
UN_Number_ID is invalid,FK validation failed against po_un_numbers_b table. |
SB-POREQ-20120 |
Hazard_Class_ID is invalid,FK validation failed against po_hazard_classes_b table. |
SB-POREQ-20121 |
WIP_Entity_ID is invalid,FK validation failed against wip_entities table. |
SB-POREQ-20122 |
WIP_Line_ID is invalid,FK validation failed against wip_lines table. |
SB-POREQ-20123 |
WIP_Entity_ID or Dest_Org_ID or Wip_Operation_Seq_Num or Wip_Rept_Sch_ID either one is invalid,FK validation failed against wip_operations table. |
SB-POREQ-20124 |
WIP_Entity_ID or Dest_Org_ID or Wip_Operation_Seq_Num or Wip_Rept_Sch_ID or Resource_Seq_Num either one is invalid,FK validation failed against wip_operation_resources table. |
SB-POREQ-20125 |
WIP_Repetitive_Schedule_ID or Dest_Org_ID either one is invalid,FK validation failed against wip_repetitive_schedules table. |
SB-POREQ-20126 |
Requisition_Line_ID is invalid,FK validation failed against po_requisition_lines_all table. |
SB-POREQ-20127 |
Src_Org_ID is invalid,FK validation failed against org_organization_definitions table. |
SB-POREQ-20128 |
Dest_Org_ID is invalid,FK validation failed against org_organization_definitions table. |
SB-POREQ-20129 |
Source_Subinventory is invalid for a given Src_Org_ID,FK validation failed against MTL_Secondary_Inventories table. |
SB-POREQ-20130 |
Destination_Subinventory is invalid for a given Dest_Org_ID,FK validation failed against MTL_Secondary_Inventories table. |
SB-POREQ-20131 |
Deliver_To_Requestor_ID is invalid,FK validation failed against hr_employees table. |
SB-POREQ-20132 |
Suggested_Buyer_ID is invalid,FK validation failed against po_agents table. |
SB-POREQ-20133 |
Suggested_Vendor_ID is invalid,FK validation failed against po_vendors table. |
SB-POREQ-20134 |
Suggested_Vendor_Site_ID is invalid,FK validation failed against po_vendor_sites_all table. |
SB-POREQ-20135 |
Req_Distribution_ID is invalid,FK validation failed against Po_Req_Distributions_All table. |
SB-POREQ-20136 |
Suggested_Vendor_Contact_ID is invalid,FK validation failed against Po_Vendor_Contacts table. |
SB-POREQ-20137 |
Note1_ID is invalid,FK validation failed against Po_Notes table. |
SB-POREQ-20138 |
Accrual_Account_ID is invalid,FK validation failed against Gl_Code_Combinations table. |
SB-POREQ-20139 |
Variance_Account_ID is invalid,FK validation failed against Gl_Code_Combinations table. |
SB-POREQ-20140 |
Budget_Account_ID is invalid,FK validation failed against Gl_Code_Combinations table. |
SB-POREQ-20141 |
Ussgl_Transaction_Code is invalid,FK validation failed against gl_ussgl_transaction_codes table. |
SB-POREQ-20142 |
Currency_Code is invalid,FK validation failed against fnd_currencies table. |
SB-POREQ-20143 |
Rate is invalid,FK validation failed against gl_daily_conversion_rates_r10 table. |
SB-POREQ-20144 |
Rate_Type is invalid,FK validation failed against gl_daily_conversion_types table. |
SB-POREQ-20145 |
Approver_ID is invalid,FK validation failed against hr_employees table. |
SB-POREQ-20146 |
Autosource_Doc_Header_ID is invalid,FK validation failed against po_autosource_documents_all table. |
SB-POREQ-20147 |
Project_ID is invalid,FK validation failed against pa_projects_all table. |
SB-POREQ-20148 |
Task_ID is invalid,FK validation failed against pa_tasks table. |
SB-POREQ-20149 |
Note2_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20150 |
Note3_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20151 |
Note4_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20152 |
Note5_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20153 |
Note6_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20154 |
Note7_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20155 |
Note8_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20156 |
Note9_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20157 |
Note10_ID is invalid,FK validation failed against po_notes table. |
SB-POREQ-20158 |
Expenditure_Type is invalid,FK validation failed against pa_expenditure_types table. |
SB-POREQ-20159 |
Document_Type_Code is invalid,FK validation failed against po_document_types_all_b table. |
SB-POREQ-20160 |
Kanban_Card_ID is invalid,FK validation failed against mtl_kanban_cards table. |
SB-POREQ-20161 |
Preparer_ID is invalid,FK validation failed against hr_employees table. |
SB-POREQ-20162 |
Item_ID is invalid,FK validation failed against mtl_system_items_b table. |
SB-POREQ-20163 |
Item_Revision is invalid,FK validation failed against mtl_item_revisions table. |
SB-POREQ-20164 |
Charge_Account_ID is invalid,FK validation failed against gl_code_combinations table. |
SB-POREQ-20165 |
If Dest_Type_Code is INVENTORY then item must be stock enabled for dest org. If Dest_Subinventory present then item must be valid either in subinventory or to a subinventory. |
SB-POREQ-20166 |
If Dest_Type_Code is EXPENSE then item must be purchasing enabled for purchasing and dest org. |
SB-POREQ-20167 |
If Dest_Type_Code is SHOP FLOOR then item must be an outise-operation item and purchasing enabled for purchasing and dest org. |
SB-POREQ-20168 |
If Src_Type_Code is INVENTORY then the item must be stock enabled for the src org and internal-order-enabled for the purchasing. |
SB-POREQ-20169 |
If Src_Type_Code is VENDOR then the item must be purchasing enabled for the purchasing and dest org id. |
SB-POREQ-20170 |
Deliver_To_Location_ID is invalid,FK validation failed against Hr_Locations table. |
SB-POREQ-20171 |
category_id is invalid for the given item. |
This section provides a description of each of the following Financial Budget error codes.
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. |
This section provides a description of each of the Accounts Receivable error codes.
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. |
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. |
The Customer Interface Errors are as listed in the table.
Table 1–23 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. |
This section provides a description of each of the Cash Management error codes.
Table 1–24 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. |
This section provides a description of each of the Fixed Assets error codes.
Table 1–25 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. |
This section provides a description of each of the General Ledger error codes.
Table 1–26 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. |