Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Designing: Manufacturing
 

Classic Java CAPS

Developing Java CAPS Projects

Using SOAP Message Handlers

Creating a Runtime Environment

Designing Business Processes in the Sun Business Process Manager

Working with TCP/IP HL7 Collaborations

Developing Sun Master Indexes (Repository)

Developing Sun Master Patient Indexes

Developing OTDs for Application Adapters

Developing OTDs for Communication Adapters

Developing OTDs for Database Adapters

Developing OTDs for Web Server Adapters

Designing with Application Adapters

Building an Oracle Applications Custom Pre-Validation Package

Pre-Validation Scripts

Pre-Validation Procedures

To Build a Custom Pre-Validation Package for a Non-Supported Open Interface

Concurrent Manager Request Function

Template DTD

Naming Conventions for the Oracle Interface

Oracle Applications Manufacturing Module

Inventory Module

Purchase Order Import Module

Order Entry Module

Oracle Applications Financial Module

Accounts Payable Module

Accounts Receivable Module

Cash Management Module

Fixed Assets Module

General Ledger Module

Oracle Applications Validation Error Codes

Manufacturing

Financial Budget-GL

Configuring the PeopleSoft Server for the PeopleSoft Adapter Projects

Overview

Configuring PeopleTools 8.42

Configuring PeopleSoft for Enterprise Service Bus Posting

Additional HTTP Configurations

Additional JMS Configurations

Verifying PeopleSoft Server Logs

Notes on PeopleSoft Server Disconnections for JMS

Configuring PeopleTools 8.13

Creating the PeopleSoft Node to Receive Enterprise Service Bus HTTP Posts

Activating the Message Definition to Receive Enterprise Service Bus Posts

Defining Message Channel Routing Rules

Adding the PeopleSoft Subscription Handler

Configuring for Subscription

Creating an HTTP Adapter Message Node

Activating the Message Definition for Subscription

Defining the Message Channel Routing Rules

Adding the HTTP Publication Handler

Accessing Non-Local Queue Managers and Non-Local Queues

To Connect to a Remote WebSphere MQ Queue.

Creating the WebSphere MQ Queue

To Create the WebSphere MQ Queue

IBM WebSphere MQ Server and Queue Manager Limits and Settings

Designing with Communication Adapters

Designing with Web Server Adapters

SWIFT Integration Projects

Java EE Based Components

Designing with Sun JCA Adapters

About the TCP/IP JCA Adapter

Defining Constants and Variables

Using Database Operations

Developing Sun Master Indexes

Using the JMS JCA Wizard

Using the JAXB Wizard and Code-Seeder Pallete

Manufacturing

This section provides a description of each of the following Manufacturing error codes:

Inventory

This section provides a description of each of the Inventory error codes.

Customer Items

The Customer Items are listed in the table.

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.
Customer Item Cross-Reference

The Customer Item Cross-Reference is listed in the table.

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.
Cycle Count Entries

The Cycle Count Entries are listed in the table.

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

The Item Entries are listed in the table.

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

The Item Revisions are listed in the table.

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

Master

The Replenishment Master Errors are listed in the table.

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.

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.

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

Transactions

The Transaction Errors are listed in the table.

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.

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.

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.
Purchase Order Error Codes

This section provides a description of each of the Purchase Order error codes.

Import

Master

The Import Master Errors are listed in the table.

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.

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.

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

Master

The Receiving Master Errors are listed in the table.

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.

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.

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

The Requisition Errors are listed in the table.

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.