Mapping Name : Load into Order Fact / SIL_OrderFact Target Table : w_order_f Failed with : ORA-00001: unique constraint (XXDBD_OBAW.W_ORDER_F_U1) violated Index Name : W_ORDER_F_U1 Index Columns : datasource_num_id and integration_id
Issue : 1) On 23rd December 2013, an order has been created and a line (1.1) with ENTERED status. Order Header_ID # 6282500. 2) Subsequently, ETL ran and the record got entered into warehouse 3) On 6th Jan 2014, same order line was deleted and created a new line (2.1) under the same order header_id # 6282500 4) Since the order line (1.1) already exists in warehouse, new line (2.1) insertion is failing due to unique constraint as the new line (2.1) contains the same header_id/integration_id and datasource_num_id. Attached session log provides more details.
Similar to the above, there are few more records which got deleted in ORACLE ebiz but inserted into warehouse table w_orderitem_f. Can you please suggest a solution to identify the invalid records (the deleted ones in ebiz tables oe_order_headrs_all, oe_order_lines_all) in w_orderitem_f table?