You are browsing the archive for Oracle Inventory.

by oracleguru

7.0 Enter Safety Stock Manually

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

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

Safety Stocks are buffer inventory that is kept for any fluctuation in demand/supply. Safety Stocks also include the demand during lead-time to make/buy an item. Safety stocks can be system generated or manually entered. In this tutorial you will see how to enter ‘Safety Stock’ manually in Oracle Inventory module.

Navigation: Inventory responsibility -> Planning -> Safety Stocks

  • Enter the search criteria to search existing safety stocks and click ‘FIND’ or
  • Click ‘NEW’ to add safety stock to an item
  • Enter ‘Item Number’ to which safety stock should be added
  • Enter ‘Effective Date’ from which it is active
  • Enter the safety stock ‘quantity’
  • Click ‘Save’ to save the safety stock details entered

MRP / Supply Chain Planning can consider safety stock quantity in addition to demand quantity while suggesting planned order quantity.

Enter Safety Stock Manually

Enter Safety Stock Manually

 

 

 

 

 

 

 

Tags: , , , , , No Comments »

by oracleguru

5.3 Item Supply Demand Query

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

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

Item Supply Demand screen is very popular screen to query supply/demand information in the near future. It shows current onhand of any item queried then displays the supply demand information sorted by supply/demand date along with projected on-hand information.

Navigation: Login to Oracle Apps -> Select Inventory responsibility -> On-hand, Availability -> Item Supply/Demand

  • Item: Enter the item number to be queried. Only one can use be entered.
  • Cut-off date: Optionally enter cut-off date upto which you would like to view the supply/demand information.
  • UOM: Enter UOM code into which you would like to see the quantity
  • Include: Select ATP/Non-ATP subinventories.
  • Click ‘FIND’

Output shows the Item, UOM, current on-hand, date, supply/demand type, supply/deamand identifier, quantity (supply/demand), Projected available quantity.

Item Supply Demand

Item Supply Demand

Tags: , , , , 1 Comment »

by oracleguru

Move Order Issue

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

  • 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 not only used like ‘subinventory transfers’ to move between two subinventories, but thy can be used to issue material to a GL account similar to account Issue or account alias issue. MOVE ORDER TRANSFER transaction is used to transfer material. MOVE ORDER ISSUE transaction is used to issue material to a GL a/c

Move Order Issue - Oracle Inventory
Description
Move Orders can be used for move or issue material. In this tutorial you will learn how to use Move Orders to issue material against a GL charge a/c.
For more details visit http://oracleappscommunity.com/oracle/blog/2068/move-order-issue/

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 Issue
  • 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 A/c: Enter the GL account to be charged
  • 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.
  • Account: Enter account to be used to charge the material issued for this line.
  • 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. Next step will be to issue the material (transact move order).

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

  1. Enter the ‘Move Order From’ and ‘Move Order To’ numbers to search.
  2. Click ‘Find’
  3. Select the move order lines by checking left hand side check box
  4. Click ‘Allocate’ if not allocated already. Allocation will reserve the onhand quantity to the move order.
  5. Click ‘View/Update allocations’ to change allocation/reservation details.
  6. Click ‘Transact’ to executes the transaction.
  7. Click ‘OK’ once ‘Transaction Complete’ message appears.
Transact Move Order
Transact Move Order

 

 

Tags: , , , , , , 1 Comment »