Work Order-less Completion
Can you please share if anyone has imported Work Order-less Completions through import program.
I have developed program to insert data into mtl_transactions_interface and tried importing both using the Transaction Import, but getting the following error message
"Error occured while defaulting for the Work Order-less Completion Entity 28989222."
Here is the data in the table after failed...
Insert into EXPORT_TABLE (TRANSACTION_INTERFACE_ID,TRANSACTION_HEADER_ID,SOURCE_CODE,SOURCE_LINE_ID,SOURCE_HEADER_ID,PROCESS_FLAG,VALIDATION_REQUIRED,TRANSACTION_MODE,LOCK_FLAG,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,INVENTORY_ITEM_ID,ITEM_SEGMENT1,ITEM_SEGMENT2,ITEM_SEGMENT3,ITEM_SEGMENT4,ITEM_SEGMENT5,ITEM_SEGMENT6,ITEM_SEGMENT7,ITEM_SEGMENT8,ITEM_SEGMENT9,ITEM_SEGMENT10,ITEM_SEGMENT11,ITEM_SEGMENT12,ITEM_SEGMENT13,ITEM_SEGMENT14,ITEM_SEGMENT15,ITEM_SEGMENT16,ITEM_SEGMENT17,ITEM_SEGMENT18,ITEM_SEGMENT19,ITEM_SEGMENT20,REVISION,ORGANIZATION_ID,TRANSACTION_QUANTITY,PRIMARY_QUANTITY,TRANSACTION_UOM,TRANSACTION_DATE,ACCT_PERIOD_ID,SUBINVENTORY_CODE,LOCATOR_ID,LOC_SEGMENT1,LOC_SEGMENT2,LOC_SEGMENT3,LOC_SEGMENT4,LOC_SEGMENT5,LOC_SEGMENT6,LOC_SEGMENT7,LOC_SEGMENT8,LOC_SEGMENT9,LOC_SEGMENT10,LOC_SEGMENT11,LOC_SEGMENT12,LOC_SEGMENT13,LOC_SEGMENT14,LOC_SEGMENT15,LOC_SEGMENT16,LOC_SEGMENT17,LOC_SEGMENT18,LOC_SEGMENT19,LOC_SEGMENT20,TRANSACTION_SOURCE_ID,DSP_SEGMENT1,DSP_SEGMENT2,DSP_SEGMENT3,DSP_SEGMENT4,DSP_SEGMENT5,DSP_SEGMENT6,DSP_SEGMENT7,DSP_SEGMENT8,DSP_SEGMENT9,DSP_SEGMENT10,DSP_SEGMENT11,DSP_SEGMENT12,DSP_SEGMENT13,DSP_SEGMENT14,DSP_SEGMENT15,DSP_SEGMENT16,DSP_SEGMENT17,DSP_SEGMENT18,DSP_SEGMENT19,DSP_SEGMENT20,DSP_SEGMENT21,DSP_SEGMENT22,DSP_SEGMENT23,DSP_SEGMENT24,DSP_SEGMENT25,DSP_SEGMENT26,DSP_SEGMENT27,DSP_SEGMENT28,DSP_SEGMENT29,DSP_SEGMENT30,TRANSACTION_SOURCE_NAME,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,TRANSACTION_TYPE_ID,REASON_ID,TRANSACTION_REFERENCE,TRANSACTION_COST,DISTRIBUTION_ACCOUNT_ID,DST_SEGMENT1,DST_SEGMENT2,DST_SEGMENT3,DST_SEGMENT4,DST_SEGMENT5,DST_SEGMENT6,DST_SEGMENT7,DST_SEGMENT8,DST_SEGMENT9,DST_SEGMENT10,DST_SEGMENT11,DST_SEGMENT12,DST_SEGMENT13,DST_SEGMENT14,DST_SEGMENT15,DST_SEGMENT16,DST_SEGMENT17,DST_SEGMENT18,DST_SEGMENT19,DST_SEGMENT20,DST_SEGMENT21,DST_SEGMENT22,DST_SEGMENT23,DST_SEGMENT24,DST_SEGMENT25,DST_SEGMENT26,DST_SEGMENT27,DST_SEGMENT28,DST_SEGMENT29,DST_SEGMENT30,REQUISITION_LINE_ID,CURRENCY_CODE,CURRENCY_CONVERSION_DATE,CURRENCY_CONVERSION_TYPE,CURRENCY_CONVERSION_RATE,USSGL_TRANSACTION_CODE,WIP_ENTITY_TYPE,SCHEDULE_ID,EMPLOYEE_CODE,DEPARTMENT_ID,SCHEDULE_UPDATE_CODE,SETUP_TEARDOWN_CODE,PRIMARY_SWITCH,MRP_CODE,OPERATION_SEQ_NUM,REPETITIVE_LINE_ID,PICKING_LINE_ID,TRX_SOURCE_LINE_ID,TRX_SOURCE_DELIVERY_ID,DEMAND_ID,CUSTOMER_SHIP_ID,LINE_ITEM_NUM,RECEIVING_DOCUMENT,RCV_TRANSACTION_ID,SHIP_TO_LOCATION_ID,ENCUMBRANCE_ACCOUNT,ENCUMBRANCE_AMOUNT,VENDOR_LOT_NUMBER,TRANSFER_SUBINVENTORY,TRANSFER_ORGANIZATION,TRANSFER_LOCATOR,XFER_LOC_SEGMENT1,XFER_LOC_SEGMENT2,XFER_LOC_SEGMENT3,XFER_LOC_SEGMENT4,XFER_LOC_SEGMENT5,XFER_LOC_SEGMENT6,XFER_LOC_SEGMENT7,XFER_LOC_SEGMENT8,XFER_LOC_SEGMENT9,XFER_LOC_SEGMENT10,XFER_LOC_SEGMENT11,XFER_LOC_SEGMENT12,XFER_LOC_SEGMENT13,XFER_LOC_SEGMENT14,XFER_LOC_SEGMENT15,XFER_LOC_SEGMENT16,XFER_LOC_SEGMENT17,XFER_LOC_SEGMENT18,XFER_LOC_SEGMENT19,XFER_LOC_SEGMENT20,SHIPMENT_NUMBER,TRANSPORTATION_COST,TRANSPORTATION_ACCOUNT,TRANSFER_COST,FREIGHT_CODE,CONTAINERS,WAYBILL_AIRBILL,EXPECTED_ARRIVAL_DATE,NEW_AVERAGE_COST,VALUE_CHANGE,PERCENTAGE_CHANGE,DEMAND_SOURCE_HEADER_ID,DEMAND_SOURCE_LINE,DEMAND_SOURCE_DELIVERY,NEGATIVE_REQ_FLAG,ERROR_EXPLANATION,SHIPPABLE_FLAG,ERROR_CODE,REQUIRED_FLAG,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,REQUISITION_DISTRIBUTION_ID,MOVEMENT_ID,RESERVATION_QUANTITY,SHIPPED_QUANTITY,INVENTORY_ITEM,LOCATOR_NAME,TASK_ID,TO_TASK_ID,SOURCE_TASK_ID,PROJECT_ID,TO_PROJECT_ID,SOURCE_PROJECT_ID,PA_EXPENDITURE_ORG_ID,EXPENDITURE_TYPE,FINAL_COMPLETION_FLAG,TRANSFER_PERCENTAGE,TRANSACTION_SEQUENCE_ID,MATERIAL_ACCOUNT,MATERIAL_OVERHEAD_ACCOUNT,RESOURCE_ACCOUNT,OUTSIDE_PROCESSING_ACCOUNT,OVERHEAD_ACCOUNT,BOM_REVISION,ROUTING_REVISION,BOM_REVISION_DATE,ROUTING_REVISION_DATE,ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR,ACCOUNTING_CLASS,DEMAND_CLASS,PARENT_ID,SUBSTITUTION_TYPE_ID,SUBSTITUTION_ITEM_ID,SCHEDULE_GROUP,BUILD_SEQUENCE,SCHEDULE_NUMBER,SCHEDULED_FLAG,FLOW_SCHEDULE,COST_GROUP_ID,KANBAN_CARD_ID,QA_COLLECTION_ID,OVERCOMPLETION_TRANSACTION_QTY,OVERCOMPLETION_PRIMARY_QTY,OVERCOMPLETION_TRANSACTION_ID,END_ITEM_UNIT_NUMBER,SCHEDULED_PAYBACK_DATE,ORG_COST_GROUP_ID,COST_TYPE_ID,TRANSFER_COST_GROUP_ID,LPN_ID,TRANSFER_LPN_ID,CONTENT_LPN_ID,XML_DOCUMENT_ID,ORGANIZATION_TYPE,TRANSFER_ORGANIZATION_TYPE,OWNING_ORGANIZATION_ID,OWNING_TP_TYPE,XFR_OWNING_ORGANIZATION_ID,TRANSFER_OWNING_TP_TYPE,PLANNING_ORGANIZATION_ID,PLANNING_TP_TYPE,XFR_PLANNING_ORGANIZATION_ID,TRANSFER_PLANNING_TP_TYPE,SECONDARY_UOM_CODE,SECONDARY_TRANSACTION_QUANTITY,REPRESENTATIVE_LOT_NUMBER,TRANSACTION_BATCH_ID,TRANSACTION_BATCH_SEQ,REBUILD_ITEM_ID,REBUILD_SERIAL_NUMBER,REBUILD_ACTIVITY_ID,REBUILD_JOB_NAME,MOVE_TRANSACTION_ID,COMPLETION_TRANSACTION_ID,WIP_SUPPLY_TYPE,RELIEVE_RESERVATIONS_FLAG,RELIEVE_HIGH_LEVEL_RSV_FLAG,TRANSFER_PRICE,SOURCE_LOT_NUMBER,MATERIAL_EXPENSE_ACCOUNT) values (28989222,28991375,'LAX Test',-999991,-999991,3,1,3,2,to_date('26-MAY-13','DD-MON-RR'),1000066,to_date('24-MAY-13','DD-MON-RR'),1008762,15025239,13208924,401,32321,to_date('26-MAY-13','DD-MON-RR'),52909,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,1,'EA',to_date('26-APR-13','DD-MON-RR'),null,'T',12671,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,31,44,null,'LOADED BY LAXMAN ON 24-MAY-13',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,-1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'Error occured while defaulting for the Work Order-less Completion Entity 28989222.',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'717102',2,'Y',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28989230,1,null,null,null,null,null,28989230,null,null,null,null,null,null);