Secondary UOM, The secondary unit of measure. If the item is under dual unit of measure control, the secondary unit of measure and the secondary quantity populate automatically. 

Qty, Quantity of this transaction in terms of the UOM.

Date, Transaction date

Item Description, Inventory item description

Error Explanation, detailed explanation of error

Lot/Serial (Used if transaction is associated with a Lot or Serial number)

Submit, When checked and saved the erred transaction line will be resubmitted. If the line is not in error it can not be resubmitted using the Submit check box but will have to be resubmitted through a sqlplus script. All erred transactions can be selected to be resubmitted by clicking on 'Tools' resubmit all.

Item, Inventory item referenced by the line item.

Transaction Qty, Quantity of this transaction.

Transaction UOM, Unit of measure used in the transaction.

Transaction Type, Displays the transaction type.

Secondary Quantity, Transaction quantity in secondary unit of measure if the item is under dual of unit of measure control.

Secondary UOM, Secondary unit of measure if the item is under dual of unit of measure control.

Overcompletion Transactions, Overcompletion quantity .

Transaction Date, Date the transaction was entered for processing.

Transaction Header Id, Line item's header ID used to group transactions in concurrent manager.

Transaction Temp Id, Transaction line identifier used to join to lot or serial table when under these controls.

Transaction Mode, Method used to process the line item, such as concurrent processing.

Process flag, indicates whether the row has been processed by the concurrent manager. The process flag codes are:

1 = Pending

2 = Running

3 = Error

Transaction Status, Status of the transaction: Select Pending or Suggested. Pending indicates transactions that are ready to be allocated. Suggested indicates transactions that have been detailed and are ready to be transacted.

Error Code, Code describing the error on the last attempt to process the line item.

Error Explanation, Full explanation of the error that occurred when attempting to process the line item

Revision, Revision of the inventory item referenced by the line item.

Org Code, Organization code of the organization referenced by the line item.

Subinventory, Subinventory referenced by the line item.

Locator, Locator referenced by the line item.

Transfer Subinv, Destination subinventory.

Transfer Org Code, Organization code of the destination organization.

Transfer Location, Destination location.

Owning Party, Owning Party identifier

Planning Org, Planning Party identifier

Supplier, supplier name

Cartonized LPN, Sequential LPN Id generated by cartonization - used by WMS only

Lot Number, Lot number

Lot Expiration Date, Lot expiration date

Serial Number, Serial Number

Transaction Action, The transaction action

Transaction Source Type, Source type of the transaction, such as WIP Job or Schedule

Source, Source of the transaction, such as account number or Job name

Distribution Account, Distribution account for the line item

Transaction Cost, Cost to process the transaction

Transaction Reference, Reference text describing the transaction

Reason Name, The transaction reason.

Shipment Number, Shipment number for the line item

Transfer Cost, Cost to process the transfer

Transportation Cost, Cost to physically transfer the material, such as freight carrier charges

Transportation Account, General ledger distribution account that collects the costs associated with using the freight carrier for the transfer

Freight Code, Freight carrier for the transaction

Containers, Number of containers in which the material is stored for the transfer

Waybill Airbill, The waybill or airbill number for the transfer

Expected Arrival Date, Date you expect to receive the material at the destination organization

Line Code, Request ID assigned by the concurrent manager to the line item

Employee Code, Employee who entered the transaction

Operation Seq Num, Number associated with the job or schedule referenced by the line item

Department Code, Oracle Work in Process department code for the line item

Transaction Source Line ID, Oracle Work in Process line description for the item

Transaction Source Delivery ID, Line item detail identifier of the demand source

Encumbrance Amount, Amount encumbered, reserved against funds, when the purchase order or requisition was approved

New Average Cost, Recalculated average unit cost for the item

Cost Group ID, Cost group identifier

Value Change, Amount used to increment the current inventory value.

Percentage Change, Percentage used to update the item cost.

Location Code, Ship-to location

Source Project Number, The source project number

Source Task Number, The source task number

Project Number, The project number

Task Number, The task number

To Project Number, The to project number

To Task Number, The to task number

Expenditure Type, The expenditure type

Expenditure Org, The expenditure organization

In the Pending Transactions window either check the transaction's Resubmit check box to resubmit one record or chose Resubmit All from the Tools Menu and selectively deselect individual transaction you do not want to resubmit, save your work. Transactions can also be resubmitted via the following SQL statement:

Update MTL_MATERIAL_TRANSACTIONS_TEMP

Set PROCESS_FLAG = 'Y',

LOCK_FLAG = 'N',

TRANSACTION_MODE = 3,

ERROR_CODE = NULL

Where TRANSACTION_HEADER_ID = '& TRANSACTION_HEADER_ID';