Minhajuddin wrote:You get this error when the "WHERE" clause in the update statement evaluates to false. Checkout your "WHERE" clause. Try it out in SQL plus and see what you get. Do you have a condition which is always false?(like 1=2)
Still having the same problem.
INSERT
INTO
PO_W
(ORD_I, PRIM_LINE_I, EPRS_C, DOC_TYPE_T, ORD_TYPE_T, ORD_STYP_T, BYR_ORG_C, SELR_ORG_C, HOT_PO_F, RSV_PO_F, RXMT_T, STAT_T, REQ_SHIP_D, REQ_CAN_D, PRMS_D, REQ_DLVR_D, SRCH_CRTR_1_T, CUST_PO_I, ORD_D, ACT_T, SHIP_NODE_T, SHIP_TO_I, RECV_NODE_T, NOTE_T, CRTE_USER_I, CRTE_USER_N, MODF_D, VEND_N, CNTC_TELE_I, VEND_TRM_T, VEND_COMM_METH_T, GMS_VEND_I, VEND_NOTE_T, VEND_ACTV_F, VEND_IMP_F, FOB_TYPE_C, PYMT_TYPE_C, FOB_CTRY_C, FOB_ST_C, FOB_CITY_N, FRT_TRM_C, FOB_ZIP_C, VEND_CNTC_N, VEND_CNTC_ADDR_1_T, VEND_CNTC_ADDR_2_T, VEND_CNTC_ADDR_3_T, VEND_CNTC_CITY_N, VEND_CNTC_ST_N, VEND_CNTC_ZIP_C, VEND_CNTC_CTRY_N, CNTC_EMAIL_I, VEND_CNTC_EMAIL_I, VEND_CNTC_TELE_I, BILL_TO_FRST_N, BILL_TO_ADDR_1_T, BILL_TO_CITY_N, BILL_TO_ST_N, BILL_TO_ZIP_C, BILL_TO_CTRY_N, SHIP_TO_CO_N, SHIP_TO_ADDR_1_T, SHIP_TO_CITY_N, SHIP_TO_ST_N, SHIP_TO_ZIP_C, SHIP_TO_CTRY_N, SHIP_FROM_CO_N, SHIP_FROM_ADDR_1_T, SHIP_FROM_CITY_N, SHIP_FROM_ST_N, SHIP_FROM_ZIP_C, SHIP_FROM_CTRY_N, IS_FORCE_RECV_F, ITEM_I, ITEM_DESC_T, UOM_T, AMZN_STD_INV_I, DPCI_I, VEND_STYL_I, UPC_C, TCBI_T, CSPK_Q, ORD_Q, RECV_Q, FORCE_RECV_Q, PO_RDY_F, TRF_1_I, TRF_2_I, TRF_3_I, TRF_4_I, TRF_5_I, ASRT_ITEM_F, KIT_ITEM_F, ITEM_NOTE_T, MIN_ORD_Q, PREP_C, PSLZ_F, CMT_D, ITEM_STAT_T, ITEM_ACT_T, BILL_TO_ADDR_2_T, SHIP_TO_ADDR_2_T, SHIP_FROM_ADDR_2_T, TOT_RETL_A, REQ_DOC_N, REQ_DOC_T, VISA_1_T, VISA_2_T, VISA_3_T, VISA_4_T, VISA_5_T, COLR_T, SIZE_T, LINE_STOT_A, LINE_TOT_A, UNIT_PRC_A, PRC_UOM_T, RETL_PRC_A, ITEM_TOT_RETL_A, SHIP_FROM_I, EDI850_CPLY_F, EDI860_CPLY_F)
VALUES
(ORCHESTRATE.ORD_I, ORCHESTRATE.PRIM_LINE_I, ORCHESTRATE.EPRS_C, ORCHESTRATE.DOC_TYPE_T, ORCHESTRATE.ORD_TYPE_T, ORCHESTRATE.ORD_STYP_T, ORCHESTRATE.BYR_ORG_C, ORCHESTRATE.SELR_ORG_C, ORCHESTRATE.HOT_PO_F, ORCHESTRATE.RSV_PO_F, ORCHESTRATE.RXMT_T, ORCHESTRATE.STAT_T, ORCHESTRATE.REQ_SHIP_D, ORCHESTRATE.REQ_CAN_D, ORCHESTRATE.PRMS_D, ORCHESTRATE.REQ_DLVR_D, ORCHESTRATE.SRCH_CRTR_1_T, ORCHESTRATE.CUST_PO_I, ORCHESTRATE.ORD_D, ORCHESTRATE.ACT_T, ORCHESTRATE.SHIP_NODE_T, ORCHESTRATE.SHIP_TO_I, ORCHESTRATE.RECV_NODE_T, ORCHESTRATE.NOTE_T, ORCHESTRATE.CRTE_USER_I, ORCHESTRATE.CRTE_USER_N, ORCHESTRATE.MODF_D, ORCHESTRATE.VEND_N, ORCHESTRATE.CNTC_TELE_I, ORCHESTRATE.VEND_TRM_T, ORCHESTRATE.VEND_COMM_METH_T, ORCHESTRATE.GMS_VEND_I, ORCHESTRATE.VEND_NOTE_T, ORCHESTRATE.VEND_ACTV_F, ORCHESTRATE.VEND_IMP_F, ORCHESTRATE.FOB_TYPE_C, ORCHESTRATE.PYMT_TYPE_C, ORCHESTRATE.FOB_CTRY_C, ORCHESTRATE.FOB_ST_C, ORCHESTRATE.FOB_CITY_N, ORCHESTRATE.FRT_TRM_C, ORCHESTRATE.FOB_ZIP_C, ORCHESTRATE.VEND_CNTC_N, ORCHESTRATE.VEND_CNTC_ADDR_1_T, ORCHESTRATE.VEND_CNTC_ADDR_2_T, ORCHESTRATE.VEND_CNTC_ADDR_3_T, ORCHESTRATE.VEND_CNTC_CITY_N, ORCHESTRATE.VEND_CNTC_ST_N, ORCHESTRATE.VEND_CNTC_ZIP_C, ORCHESTRATE.VEND_CNTC_CTRY_N, ORCHESTRATE.CNTC_EMAIL_I, ORCHESTRATE.VEND_CNTC_EMAIL_I, ORCHESTRATE.VEND_CNTC_TELE_I, ORCHESTRATE.BILL_TO_FRST_N, ORCHESTRATE.BILL_TO_ADDR_1_T, ORCHESTRATE.BILL_TO_CITY_N, ORCHESTRATE.BILL_TO_ST_N, ORCHESTRATE.BILL_TO_ZIP_C, ORCHESTRATE.BILL_TO_CTRY_N, ORCHESTRATE.SHIP_TO_CO_N, ORCHESTRATE.SHIP_TO_ADDR_1_T, ORCHESTRATE.SHIP_TO_CITY_N, ORCHESTRATE.SHIP_TO_ST_N, ORCHESTRATE.SHIP_TO_ZIP_C, ORCHESTRATE.SHIP_TO_CTRY_N, ORCHESTRATE.SHIP_FROM_CO_N, ORCHESTRATE.SHIP_FROM_ADDR_1_T, ORCHESTRATE.SHIP_FROM_CITY_N, ORCHESTRATE.SHIP_FROM_ST_N, ORCHESTRATE.SHIP_FROM_ZIP_C, ORCHESTRATE.SHIP_FROM_CTRY_N, ORCHESTRATE.IS_FORCE_RECV_F, ORCHESTRATE.ITEM_I, ORCHESTRATE.ITEM_DESC_T, ORCHESTRATE.UOM_T, ORCHESTRATE.AMZN_STD_INV_I, ORCHESTRATE.DPCI_I, ORCHESTRATE.VEND_STYL_I, ORCHESTRATE.UPC_C, ORCHESTRATE.TCBI_T, ORCHESTRATE.CSPK_Q, ORCHESTRATE.ORD_Q, ORCHESTRATE.RECV_Q, ORCHESTRATE.FORCE_RECV_Q, ORCHESTRATE.PO_RDY_F, ORCHESTRATE.TRF_1_I, ORCHESTRATE.TRF_2_I, ORCHESTRATE.TRF_3_I, ORCHESTRATE.TRF_4_I, ORCHESTRATE.TRF_5_I, ORCHESTRATE.ASRT_ITEM_F, ORCHESTRATE.KIT_ITEM_F, ORCHESTRATE.ITEM_NOTE_T, ORCHESTRATE.MIN_ORD_Q, ORCHESTRATE.PREP_C, ORCHESTRATE.PSLZ_F, ORCHESTRATE.CMT_D, ORCHESTRATE.ITEM_STAT_T, ORCHESTRATE.ITEM_ACT_T, ORCHESTRATE.BILL_TO_ADDR_2_T, ORCHESTRATE.SHIP_TO_ADDR_2_T, ORCHESTRATE.SHIP_FROM_ADDR_2_T, ORCHESTRATE.TOT_RETL_A, ORCHESTRATE.REQ_DOC_N, ORCHESTRATE.REQ_DOC_T, ORCHESTRATE.VISA_1_T, ORCHESTRATE.VISA_2_T, ORCHESTRATE.VISA_3_T, ORCHESTRATE.VISA_4_T, ORCHESTRATE.VISA_5_T, ORCHESTRATE.COLR_T, ORCHESTRATE.SIZE_T, ORCHESTRATE.LINE_STOT_A, ORCHESTRATE.LINE_TOT_A, ORCHESTRATE.UNIT_PRC_A, ORCHESTRATE.PRC_UOM_T, ORCHESTRATE.RETL_PRC_A, ORCHESTRATE.ITEM_TOT_RETL_A, ORCHESTRATE.SHIP_FROM_I, ORCHESTRATE.EDI850_CPLY_F, ORCHESTRATE.EDI860_CPLY_F)
UPDATE
PO_W
SET
EPRS_C = ORCHESTRATE.EPRS_C, DOC_TYPE_T = ORCHESTRATE.DOC_TYPE_T, ORD_TYPE_T = ORCHESTRATE.ORD_TYPE_T, ORD_STYP_T = ORCHESTRATE.ORD_STYP_T, BYR_ORG_C = ORCHESTRATE.BYR_ORG_C, SELR_ORG_C = ORCHESTRATE.SELR_ORG_C, HOT_PO_F = ORCHESTRATE.HOT_PO_F, RSV_PO_F = ORCHESTRATE.RSV_PO_F, RXMT_T = ORCHESTRATE.RXMT_T, STAT_T = ORCHESTRATE.STAT_T, REQ_SHIP_D = ORCHESTRATE.REQ_SHIP_D, REQ_CAN_D = ORCHESTRATE.REQ_CAN_D, PRMS_D = ORCHESTRATE.PRMS_D, REQ_DLVR_D = ORCHESTRATE.REQ_DLVR_D, SRCH_CRTR_1_T = ORCHESTRATE.SRCH_CRTR_1_T, CUST_PO_I = ORCHESTRATE.CUST_PO_I, ORD_D = ORCHESTRATE.ORD_D, ACT_T = ORCHESTRATE.ACT_T, SHIP_NODE_T = ORCHESTRATE.SHIP_NODE_T, SHIP_TO_I = ORCHESTRATE.SHIP_TO_I, RECV_NODE_T = ORCHESTRATE.RECV_NODE_T, NOTE_T = ORCHESTRATE.NOTE_T, CRTE_USER_I = ORCHESTRATE.CRTE_USER_I, CRTE_USER_N = ORCHESTRATE.CRTE_USER_N, MODF_D = ORCHESTRATE.MODF_D, VEND_N = ORCHESTRATE.VEND_N, CNTC_TELE_I = ORCHESTRATE.CNTC_TELE_I, VEND_TRM_T = ORCHESTRATE.VEND_TRM_T, VEND_COMM_METH_T = ORCHESTRATE.VEND_COMM_METH_T, GMS_VEND_I = ORCHESTRATE.GMS_VEND_I, VEND_NOTE_T = ORCHESTRATE.VEND_NOTE_T, VEND_ACTV_F = ORCHESTRATE.VEND_ACTV_F, VEND_IMP_F = ORCHESTRATE.VEND_IMP_F, FOB_TYPE_C = ORCHESTRATE.FOB_TYPE_C, PYMT_TYPE_C = ORCHESTRATE.PYMT_TYPE_C, FOB_CTRY_C = ORCHESTRATE.FOB_CTRY_C, FOB_ST_C = ORCHESTRATE.FOB_ST_C, FOB_CITY_N = ORCHESTRATE.FOB_CITY_N, FRT_TRM_C = ORCHESTRATE.FRT_TRM_C, FOB_ZIP_C = ORCHESTRATE.FOB_ZIP_C, VEND_CNTC_N = ORCHESTRATE.VEND_CNTC_N, VEND_CNTC_ADDR_1_T = ORCHESTRATE.VEND_CNTC_ADDR_1_T, VEND_CNTC_ADDR_2_T = ORCHESTRATE.VEND_CNTC_ADDR_2_T, VEND_CNTC_ADDR_3_T = ORCHESTRATE.VEND_CNTC_ADDR_3_T, VEND_CNTC_CITY_N = ORCHESTRATE.VEND_CNTC_CITY_N, VEND_CNTC_ST_N = ORCHESTRATE.VEND_CNTC_ST_N, VEND_CNTC_ZIP_C = ORCHESTRATE.VEND_CNTC_ZIP_C, VEND_CNTC_CTRY_N = ORCHESTRATE.VEND_CNTC_CTRY_N, CNTC_EMAIL_I = ORCHESTRATE.CNTC_EMAIL_I, VEND_CNTC_EMAIL_I = ORCHESTRATE.VEND_CNTC_EMAIL_I, VEND_CNTC_TELE_I = ORCHESTRATE.VEND_CNTC_TELE_I, BILL_TO_FRST_N = ORCHESTRATE.BILL_TO_FRST_N, BILL_TO_ADDR_1_T = ORCHESTRATE.BILL_TO_ADDR_1_T, BILL_TO_CITY_N = ORCHESTRATE.BILL_TO_CITY_N, BILL_TO_ST_N = ORCHESTRATE.BILL_TO_ST_N, BILL_TO_ZIP_C = ORCHESTRATE.BILL_TO_ZIP_C, BILL_TO_CTRY_N = ORCHESTRATE.BILL_TO_CTRY_N, SHIP_TO_CO_N = ORCHESTRATE.SHIP_TO_CO_N, SHIP_TO_ADDR_1_T = ORCHESTRATE.SHIP_TO_ADDR_1_T, SHIP_TO_CITY_N = ORCHESTRATE.SHIP_TO_CITY_N, SHIP_TO_ST_N = ORCHESTRATE.SHIP_TO_ST_N, SHIP_TO_ZIP_C = ORCHESTRATE.SHIP_TO_ZIP_C, SHIP_TO_CTRY_N = ORCHESTRATE.SHIP_TO_CTRY_N, SHIP_FROM_CO_N = ORCHESTRATE.SHIP_FROM_CO_N, SHIP_FROM_ADDR_1_T = ORCHESTRATE.SHIP_FROM_ADDR_1_T, SHIP_FROM_CITY_N = ORCHESTRATE.SHIP_FROM_CITY_N, SHIP_FROM_ST_N = ORCHESTRATE.SHIP_FROM_ST_N, SHIP_FROM_ZIP_C = ORCHESTRATE.SHIP_FROM_ZIP_C, SHIP_FROM_CTRY_N = ORCHESTRATE.SHIP_FROM_CTRY_N, IS_FORCE_RECV_F = ORCHESTRATE.IS_FORCE_RECV_F, ITEM_I = ORCHESTRATE.ITEM_I, ITEM_DESC_T = ORCHESTRATE.ITEM_DESC_T, UOM_T = ORCHESTRATE.UOM_T, AMZN_STD_INV_I = ORCHESTRATE.AMZN_STD_INV_I, DPCI_I = ORCHESTRATE.DPCI_I, VEND_STYL_I = ORCHESTRATE.VEND_STYL_I, UPC_C = ORCHESTRATE.UPC_C, TCBI_T = ORCHESTRATE.TCBI_T, CSPK_Q = ORCHESTRATE.CSPK_Q, ORD_Q = ORCHESTRATE.ORD_Q, RECV_Q = ORCHESTRATE.RECV_Q, FORCE_RECV_Q = ORCHESTRATE.FORCE_RECV_Q, PO_RDY_F = ORCHESTRATE.PO_RDY_F, TRF_1_I = ORCHESTRATE.TRF_1_I, TRF_2_I = ORCHESTRATE.TRF_2_I, TRF_3_I = ORCHESTRATE.TRF_3_I, TRF_4_I = ORCHESTRATE.TRF_4_I, TRF_5_I = ORCHESTRATE.TRF_5_I, ASRT_ITEM_F = ORCHESTRATE.ASRT_ITEM_F, KIT_ITEM_F = ORCHESTRATE.KIT_ITEM_F, ITEM_NOTE_T = ORCHESTRATE.ITEM_NOTE_T, MIN_ORD_Q = ORCHESTRATE.MIN_ORD_Q, PREP_C = ORCHESTRATE.PREP_C, PSLZ_F = ORCHESTRATE.PSLZ_F, CMT_D = ORCHESTRATE.CMT_D, ITEM_STAT_T = ORCHESTRATE.ITEM_STAT_T, ITEM_ACT_T = ORCHESTRATE.ITEM_ACT_T, BILL_TO_ADDR_2_T = ORCHESTRATE.BILL_TO_ADDR_2_T, SHIP_TO_ADDR_2_T = ORCHESTRATE.SHIP_TO_ADDR_2_T, SHIP_FROM_ADDR_2_T = ORCHESTRATE.SHIP_FROM_ADDR_2_T, TOT_RETL_A = ORCHESTRATE.TOT_RETL_A, REQ_DOC_N = ORCHESTRATE.REQ_DOC_N, REQ_DOC_T = ORCHESTRATE.REQ_DOC_T, VISA_1_T = ORCHESTRATE.VISA_1_T, VISA_2_T = ORCHESTRATE.VISA_2_T, VISA_3_T = ORCHESTRATE.VISA_3_T, VISA_4_T = ORCHESTRATE.VISA_4_T, VISA_5_T = ORCHESTRATE.VISA_5_T, COLR_T = ORCHESTRATE.COLR_T, SIZE_T = ORCHESTRATE.SIZE_T, LINE_STOT_A = ORCHESTRATE.LINE_STOT_A, LINE_TOT_A = ORCHESTRATE.LINE_TOT_A, UNIT_PRC_A = ORCHESTRATE.UNIT_PRC_A, PRC_UOM_T = ORCHESTRATE.PRC_UOM_T, RETL_PRC_A = ORCHESTRATE.RETL_PRC_A, ITEM_TOT_RETL_A = ORCHESTRATE.ITEM_TOT_RETL_A, SHIP_FROM_I = ORCHESTRATE.SHIP_FROM_I, EDI850_CPLY_F = ORCHESTRATE.EDI850_CPLY_F, EDI860_CPLY_F = ORCHESTRATE.EDI860_CPLY_F
WHERE
(ORD_I = ORCHESTRATE.ORD_I AND PRIM_LINE_I = ORCHESTRATE.PRIM_LINE_I)
These are my insert and update queries.
Autogenerated queries.
One of the records from peek:
PeekPurchaseOrderWErrors,1: sqlcode:1403 PRIM_LINE_I:1 REQ_SHIP_D:2008-09-01 REQ_CAN_D:2008-09-05 PRMS_D:2008-03-19 REQ_DLVR_D:2008-09-20 ORD_D:2008-03-05 SHIP_NODE_T:He MODF_D:2008-03-05 VEND_COMM_METH_T:0 VEND_CNTC_EMAIL_I:
Manohar.Chakravarthy@target.com IS_FORCE_RECV_F: ITEM_DESC_T:abc VEND_STYL_I: 0000013213. TCBI_T:N CMT_D:2008-09-01 ORD_I: 0009000311. PrimeLineNo: 00001. EPRS_C:Target.com DOC_TYPE_T:Purchase Order ORD_TYPE_T:TTR BYR_ORG_C:Target.com SELR_ORG_C: 0000116472. STAT_T:Draft ReqShipDate:09/01/2008 ReqCancelDate:09/05/2008 ReqDeliveryDate:09/20/2008 SRCH_CRTR_1_T: 0000000001. CUST_PO_I: 0000000012. OrderDate:03/05/2008 ACT_T:CREATE ShipNode:He SHIP_TO_I:WHSE_5 RECV_NODE_T: 000000002 CRTE_USER_I:TargetTTR CRTE_USER_N:TagetTTR Modifyts:03/05/2008 ORD_Q: 0000000003.0000 ITEM_ACT_T:CREATE ITEM_STAT_T:Draft Order Created PSLZ_F:Y RECV_Q: 0000000003.0000 ExtnIsForceRevieved: 0000000000.0000 AMZN_STD_INV_I:Y DPCI_I:N ExtnVendorStyleNo: 0000013213. ExtnTCBI:N CSPK_Q: 0000000012.0000 FORCE_RECV_Q: 0000000001.0000 TOT_RETL_A: 0000000001233.000000 PO_RDY_F:N TRF_1_I: 0000002222. TRF_2_I: TRF_3_I: TRF_4_I: TRF_5_I: ASRT_ITEM_F:N KIT_ITEM_F:Y MIN_ORD_Q: 0000000002.0000 PREP_C:Y VISA_1_T: 0000001233. VISA_2_T: VISA_3_T: VISA_4_T: VISA_5_T: COLR_T:green SIZE_T: 0000000045. REQ_DOC_N: REQ_DOC_T: ITEM_I: 0000000001. UOM_T:EACH ItemShortDesc:abc UPC_C:1.23457e+11 PRC_UOM_T:EACH UNIT_PRC_A: 000000100.000 RETL_PRC_A: 000000100.000 LINE_TOT_A: 000000100.000 CommittedDate:09/01/2008 ITEM_NOTE_T: ORD_STYP_T:Special HOT_PO_F:N RSV_PO_F:Y RXMT_T:None ITEM_TOT_RETL_A: 000001234.000 ExtnPromiseDate:03/19/2008 SHIP_FROM_I: 0000000021.0000 CNTC_EMAIL_I:
rayg@1908studios.com CNTC_TELE_I: 0003458445.0000 VEND_N:1908 STUDIOS VEND_TRM_T:term EDI860_CPLY_F:Y EDI850_CPLY_F:N GMS_VEND_I: 0000000012.0000 VEND_NOTE_T:This is reservePO VEND_ACTV_F:Y VEND_IMP_F:N PYMT_TYPE_C: FOB_TYPE_C: FOB_CTRY_C:US FOB_ST_C:WS FOB_CITY_N:New York FOB_ZIP_C: 0000023423.0000 FRT_TRM_C:Term VEND_CNTC_N:Manohar VEND_CNTC_ADDR_1_T:33 South VEND_CNTC_ADDR_2_T:Downtown VEND_CNTC_ADDR_3_T: VEND_CNTC_CITY_N:Minneapolis VEND_CNTC_ST_N:Minesotta VEND_CNTC_ZIP_C:4.35444e+09 VEND_CNTC_CTRY_N:mn ExtnVendorContactEmail:
Manohar.Chakravarthy@target.com VEND_CNTC_TELE_I: 0004343444. LINE_STOT_A: 000000010.000 NOTE_T:notes BILL_TO_FRST_N:Target Corporation BILL_TO_ADDR_1_T:33 South BILL_TO_ADDR_2_T:6th Street BILL_TO_CITY_N:MS CC-2325 BILL_TO_ZIP_C: 0000055402. BILL_TO_ST_N:Minneapolis BILL_TO_CTRY_N:MN SHIP_TO_CO_N:Savannah SHIP_TO_ADDR_1_T:756 Third St. SHIP_TO_ADDR_2_T:ABC SHIP_TO_CITY_N:New York SHIP_TO_ZIP_C: 0000023423.0000 SHIP_TO_ST_N:WS SHIP_TO_CTRY_N:US SHIP_FROM_CO_N:Amazon SHIP_FROM_ADDR_1_T:12 East SHIP_FROM_ADDR_2_T:Block SHIP_FROM_CITY_N:Houston SHIP_FROM_ZIP_C: 0000012321. SHIP_FROM_ST_N:WW SHIP_FROM_CTRY_N:US.
Let me know if find anything from the above.
Thanks,
Pavan