You are browsing the archive for Inventory.

6.0 Create Move Orders

 

  • Form Application: Inventory
  • Form Name: INVTOMAI
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVTOMAI.fmx

Move Orders are similar to ‘Subinventory Transfers’. Subinventory transfer is single step process, but move orders are two/three step process. Move Order Transfer is used to transfer within and across subinventories.

  • Step-1: Requestor requests the material by entering move order details
  • Step-2: Requestor’s manager approves the move order request (this is optional step, you can have move orders auto approved or configured through workflow approval process)
  • Step-3: Move order is transacted, confirming the material move. Onhand inventory is adjusted based on move.
Create Move Order - Oracle Inventory
Description
Move Orders are used to transfer or issue material. When it is for transfer we need to enter FROm and TO subinventory and location, if it is for move order issue then we need to enter GL a/c to which inventory must be charged.
For more detailed tutorial on how to create move order transfers visit us at http://oracleappscommunity.com/oracle/blog/2023/create-move-orders/

Navigation: Login to Oracle Apps -> Select Inventory responsibility -> Move Orders -> Move Orders.

  • Number: Enter the move order number or leave it blank for auto numbering
  • Description: Brief description of move order
  • Transaction Type: Select as Move Order Transfer
  • Source Subinventory: Select ‘From’ subinventory from which material should be withdrawn. Onhand must exist at this subinventory.
  • Source locator: If the item is locator control enter the source locator.
  • Destination subinventory: Enter the subinventory to which onhand should be  moved.
  • Destination locator: Enter the destination locator if the subinventory is locator controlled.
  • Date Required: Change the date required, default date will be current date.

Go to move order lines and enter additional information.

  • Item: Enter the item that should be moved/transacted.
  • Transaction Type: Defaulted from header, but can be changed at line level.
  • Date required: Defaulted from header, but can be changed at line level.
  • UOM: Enter the transaction Unit of measure
  • Primary Quantity: Enter the ‘quantity’ to be transacted.
  • Source subinventory/locator: Under ‘source’ tab change the default subinventory/locator if required.
  • Destination subinventory/locator: Under ‘destination’ tab change the default subinventory/locator information if required.
  • Project and Task: If the material transfer is belongs to a project, enter the project/transfer information.
  • Reason/Reference: Under ‘control’ tab enter the transaction reason and reference, this is optional.
Create Move Order

Create Move Order

Save the information entered, Click ‘Approve’ to approve the Move Order.

If Move Order approval workflow is setup and configured then it will go through the approval workflow, otherwise it will get auto approved.

Move Order status changed to ‘APPROVED’. Note down the move order number.

 

Oracle Process Manufacturing Inventory Tables

Oracle Process Manufacturing Inventory – List of database tables

  • BISOPM_ONHANDSALE_SUM
  • BIS_OPM_PROD_SUM
  • GMI_AUTO_ALLOCATION_BATCH
  • GMI_CATEGORY_SETS
  • GMI_CLOS_WAREHOUSES
  • GMI_DISCRETE_TRANSFERS
  • GMI_DISCRETE_TRANSFER_LINES
  • GMI_DISCRETE_TRANSFER_LOTS
  • GMI_ITEMS_XML_INTERFACE
  • GMI_ITEM_CATEGORIES
  • GMI_ITEM_CONV_AUDIT
  • GMI_ITEM_CONV_AUDIT_DETAILS
  • GMI_ITEM_ORGANIZATIONS
  • GMI_LOTS_CONV_XML_INTERFACE
  • GMI_LOTS_XML_INTERFACE
  • GMI_LOT_TRACE
  • GMI_MASSTRANS_CTL
  • GMI_MIGRATION_PARAMETERS
  • GMI_OBSOLETE_ITEM_COLUMNS
  • GMI_QUANTITY_XML_INTERFACE
  • GMI_SUBLOT_GENERATE
  • GMI_TRAN_TMP
  • IC_ADJS_JNL
  • IC_ALLC_CLS
  • IC_ALOT_PRM
  • IC_CLDR_DTL
  • IC_CLDR_HDR
  • IC_CLDR_HDR_B
  • IC_CLDR_HDR_TL
  • IC_COMD_CDS
  • IC_COST_CLS
  • IC_CRUL_CLS
  • IC_CTMS_CLS
  • IC_CYCL_ADT
  • IC_CYCL_DTL
  • IC_CYCL_ERR
  • IC_CYCL_HDR
  • IC_CYCL_MSC
  • IC_DECM_MST
  • IC_FRGT_CLS
  • IC_GLED_CLS
  • IC_INVN_CLS
  • IC_INVN_TYP
  • IC_ITEM_CDT
  • IC_ITEM_CNV
  • IC_ITEM_CPG
  • IC_ITEM_HIERARCHY
  • IC_ITEM_MST
  • IC_ITEM_MST_B
  • IC_ITEM_MST_B_MIG
  • IC_ITEM_MST_TL
  • IC_ITEM_WHS
  • IC_JRNL_MST
  • IC_LOCT_INV
  • IC_LOCT_MST
  • IC_LOTS_CPG
  • IC_LOTS_MST
  • IC_LOTS_MST_MIG
  • IC_LOTS_STS
  • IC_PERD_BAL
  • IC_PHYS_CNT
  • IC_PHYS_ERR
  • IC_PKGS_MST
  • IC_PLNT_INV
  • IC_PRCE_CLS
  • IC_PRCH_CLS
  • IC_PURG_PRM
  • IC_RANK_MST
  • IC_SALE_CLS
  • IC_SHIP_CLS
  • IC_STAT_RPT
  • IC_STOR_CLS
  • IC_SUMM_INV
  • IC_TAXN_ASC
  • IC_TAXN_CLS
  • IC_TEXT_HDR
  • IC_TEXT_TBL_TL
  • IC_TRAN_ARC
  • IC_TRAN_CMP
  • IC_TRAN_PND
  • IC_TXN_REQUEST_HEADERS
  • IC_TXN_REQUEST_LINES
  • IC_WHSE_INV
  • IC_WHSE_MST
  • IC_WHSE_REL
  • IC_WHSE_STS
  • IC_XFER_MST
  • IN_ADDR_MST
  • IN_CTRY_MST
  • IN_ITEM_MST
  • IN_REGN_MST
  • IN_STAT_CTL
  • IN_STAT_DTL
  • IN_STAT_HDR
  • IN_STAT_MSG
  • IN_TEXT_HDR
  • IN_TEXT_TBL_TL
  • IN_TOFD_MST
  • SY_WF_ITEM_ROLES