Receiving (Designing with Application Adapters)

Designing with Application Adapters

Receiving

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.