Category Archives: Material Requirement

Oracle Apps Inventory period closure monitoring scripts

To check if there is any unprocessed material select transaction_header_id                Txn_hdr_id,        mmtt.transaction_temp_id             Txn_tmp_id,        mmtt.inventory_item_id               Inv_Item_id,        revision                             Rev,        subinventory_code                    Subinv_code,        locator_id                           Loc_id,        mtlt.LOT_NUMBER                      Lot_Number,        msnt.fm_serial_number                FmSerial_Num,        msnt.to_serial_number                ToSerial_Num,        mmtt.transaction_quantity            Txn_qty,        mmtt.primary_quantity                Pri_qty,        transaction_uom                      Uom,        … Continue reading

Posted in Inventory Pending Transaction, Issues in Period close, Material Requirement, Pending Receiving, Pending WIP, Shipping transactions, Shop floor move, Uncosted, Unprocessed, WMS Transactions | Leave a comment

Oracle Apps Inventory period closure monitoring scripts

To check if there is any unprocessed material select transaction_header_id                Txn_hdr_id,        mmtt.transaction_temp_id             Txn_tmp_id,        mmtt.inventory_item_id               Inv_Item_id,        revision                             Rev,        subinventory_code                    Subinv_code,        locator_id                           Loc_id,        mtlt.LOT_NUMBER                      Lot_Number,        msnt.fm_serial_number                FmSerial_Num,        msnt.to_serial_number                ToSerial_Num,        mmtt.transaction_quantity            Txn_qty,        mmtt.primary_quantity                … Continue reading

Posted in Inventory Pending Transaction, Issues in Period close, Material Requirement, Pending Receiving, Pending WIP, Shipping transactions, Shop floor move, Uncosted, Unprocessed, WMS Transactions | Leave a comment

Oracle Apps Work In Process (WIP) Material Download

Entire details of Oracle apps WIP work in process are explained with screen shots. Following topics are covered in the download: WIP Accounting Class Setup WIP Assign Shop Floor Status Training WIP Attach a Document to a Discrete Job Training … Continue reading

Posted in Assembly, Discrete Job, manufacturing, Material Requirement, Move Transactions, Resource, Shop Floor, WIP Setups | Leave a comment