How You Report Material Transactions

The Report Material Transactions task enables a production operator to report materials for the work order operation. You can issue materials from inventory to the work order operation and return the issued materials back to inventory.

You can report a material transaction on the Report Material Transactions page. You can access this page from either of the following pages:

  • On the Review Dispatch List page, click the Report Material Transactions icon for the work order operation. This link is enabled if a role assigned to you has the Report Material Transactions (WIP_REPORT_MATERIAL_TRANSACTIONS_PRIV) privilege associated to it.

  • On the Work Execution Overview page, in Tasks pane, click the Report Material Transactions link. Select the work order and work order operation.

The material transactions can also be imported through the Material Transaction Web Service or through the predefined XLSM templates.

Tip: The autotransact operations aren't shown in the dispatch list. Hence, the materials for the auto transact operations are reported by accessing the Report Material Transactions page from the Work Execution Overview page.
Caution: In a contract manufacturing plant, you must not report material transactions for the contract manufacturer owned components.

Dual units of measure is supported in material transactions. If you want to issue an item with dual units of measure, you can specify both the quantities in both the primary and secondary unit of measures.

Issuing Materials to the Work Order Operation

On the Report Material Transactions page, the materials are issued to the work order by specifying the transaction type as Issue. You can control the issuing of the materials using the Show Components option. The Show Components option is defaulted based on the setting of the Default Transaction Mode plant parameter. However, you can edit the Show Components option as per your requirement.

  • When the Show Components option is set to All: All the material requirements as defined on the work order for the operation with Push supply type are defaulted. This mode is ideally used when all the required materials are issued at once and there are minimal or no changes to the material requirements. The defaulted material requirements are sorted by the material control status and shown in the following order:

    1. Lot and serial controlled components

    2. Serial controlled components only

    3. Lot controlled components only

    4. Components with no serial or lot control

    Within a particular material control status, the components are ordered by Inventory_item_id. Also, based on whether the Default Transaction Quantity plant parameter is set to material or both, the materials are defaulted with required quantity. The ad hoc materials, that's the materials not defined as required in the work order operation can be manually entered using the Add action.

    Note: For a supplier operation, the component that's defaulted, represents Original Equipment Manufacturer-supplied component associated to the supplier operation with the supply type as "Push".
  • When the Show Components option is set to Manually entered: The material requirements as defined on the work order for the operation aren't defaulted. You can enter the required materials manually. This mode is ideally used when only few of the required materials are issued at once.

You can enter the transact quantity, serial number, and lot number for the material based on the material control setup. The subinventory and locator are defaulted based on setup at work order or plant level. However, you can edit the Subinventory and Locator fields. The material transactions can also be reported by using a scanner. You can scan multiple serial numbers by scanning the component number once. You can optionally scan component serial attributes for components that are serial controlled at issue. Serial attributes if configured can be entered or updated for components which are serial controlled. For lot controlled components, it's possible to view lot attributes which have been entered in Oracle Inventory.

For the serial tracked manufacturing, in which the production is tracked using the serial numbers, the materials are issued with reference to the item serial number. For all the components, whether serial controlled, lot controlled, or uncontrolled, the issued quantities are tracked at the serial level.

If Additional Manual Material Issue is set to Do not allow, the operator can't manually issue additional materials that aren't defined in the work order with push supply type, or manually issue quantities greater than those specified in the work order.

If the Basis is set up as Fixed, then the materials appear only during the first transaction of the work order operation. Fixed components can be issued only once, and when issued, they won't appear again. The application will check whether there's any net issue against a material with Basis attribute as Fixed, which won't show as it has already been issued.

For manufacturing plants which are enabled to track inventory by the country of origin, operators can optionally specify the country of origin from the list of countries. When the country of origin is specified, the on hand balances for the country are updated. If the country of origin isn't specified, the on hand inventory tracked without the country of origin will be updated. When the required balances aren't available, negative balances are created if the organization allows negative balances.

You can perform discrete and process manufacturing transactions without providing the country of origin for specific items or items assigned to a specific category even when the organization mandates otherwise. You can define an attribute tracking exception for the country of origin at the item or item-category level using the Configure Inventory Attribute Exceptions setup task for Inventory Management.

Returning Materials to Inventory

On the Report Material Transactions page, the materials issued to the work order are returned to inventory by specifying the transaction type as Return. You can control the returning of the materials using the Show components option. The Show components option is defaulted based on the setting of the Default Transaction Mode plant parameter. However, you can edit the Show components option as per your requirement.

  • When the Show components option is set to All: All the materials issued to the work order for the operation with Push supply type are defaulted.

  • When the Show components option is set to Manually entered: The material requirements as defined on the work order for the operation aren't defaulted and you can enter the required materials manually.

For the serial-tracked manufacturing, in which the production is tracked using the serial numbers, the materials are returned in reference to the item serial number.

When the Restrict lot numbers during return plant parameter is enabled, you can select and return only those lot numbers that have been issued from the lot numbers list at the work order operation. However, you can return any lot numbers though the same lot hasn't been issued in the following conditions

  • if Restrict lot numbers during return plant parameter is NOT enabled

  • if you have the Allow unrestricted return to lot numbers privilege when Restrict lot numbers during return plant parameter is enabled

Note: The material return for component at given operation can now be done only after the last issue of the component at the operation.
Note: If you have enabled Electronic Signatures and Electronic Records, you can submit the material transaction for approval. An E-Signature page opens where you can view the status of the approval process of the material transaction.

Negative Issue and Negative Return

If the quantity is negative and the transaction type is Issue, then it's a negative issue transaction. If the quantity is negative and the transaction type is Return, then it's a negative return transaction.

Items with a negative quantity and a Push supply type are transacted using negative issue transaction. The negative issue transaction removes the item from the assembly and issues it back to the stores. If the item is lot or serial controlled, you must specify details.

Items transacted with a negative issue transaction type can be returned back to the assembly through a negative return transaction. If the item is lot or serial controlled, you must specify details.

In addition to the negative quantity items specified in the work order, users can also transact ad hoc items with negative quantity through negative issue transactions. For a Rework work order, the defective item is removed using a negative issue transaction, and the replacement for that item is done using issue transaction.

If Enable Genealogy Tracking is set for the items, and the Rework work order is serial tracked, then the details of the assembly serial and component serials that are issued to the rework work order are posted to genealogy.

For material with Dynamic at inventory receipt serial generation, the Component Serial Number list of values will continue to show serial numbers which were previously issued to the manufacturing plant. However, you can also perform a negative material issue with a serial number which was previously issued to a different manufacturing plant. You can also enter a new serial number.

For material with serial generation setup at work order issue, you have the option to perform the negative material issue without a serial number, which you can configure by selecting the plant parameter Allow negative issue without serial number entry.