WMS Material status with Oracle Apps R12

Tuesday, November 13, 2012 by Ajay Atre



WMS Material status with Oracle Apps R12
Material Status control restricts the movement and usage of portions of on-hand inventory. Using material status control enables you to control whether you can pick or ship an internal order or sales order, or issue material for a work order. You can also specify whether material needs to be quarantined until you inspect it.
You assign material statuses at four levels:
·         subinventory,
·         locator,
·         lot, and
·         serial.
You assign subinventory and locator statuses in the subinventory and locator windows. The location status applies to the material in the location and not the location itself. To assign a material status to a lot or serial, you must first enable the item attributes Lot Status Enabled and Serial Status enabled on the item in the Item Master. You can also optionally assign a default lot or serial status to an item on the Item Master. When you receive the item, the system automatically assigns the default lot or serial status to the item. The lot or serial status remains the same through all inventory transactions including organization transfers. If necessary, you can change the material status at receipt, or use the material workbench or mobile status update page to modify the material status. 

You can track material status at the Subinventory, Locator, Lot, or On-hand balance levels.
 To enable the On-hand Material Status tracking option, run the Activate On-hand Level Material Status Tracking concurrent request (explained below).

Material status is not directly assigned to material; it is associated to serial/lot/subinventory/locator. And then material assigned to serial/lot/subinventory/locator. When the material status assigned to subinventory or locator

Material Status Transactions
A material status is a combination of transactions and planning actions that you choose to disallow in a particular circumstance.
When you set up transaction types, you determine whether some transactions can be restricted by material status. The transactions for which you enable status control in the Transactions Types window appear in the Material Status Definition window. If you do not enable status control for a transaction type, then the transaction type is always allowed.

You can also assign the planning attributes Allow Reservations, Include in ATP, and Nettable to the material statuses that you create. When you transact an item, the system checks all of the material statuses. If the system finds a status that disallows the transaction, whether at the serial, lot, locator, or subinventory level, then the transaction fails.

The following table provides examples of material statuses that you might set up for your organization. In this example, each status either allows or disallows certain transactions. For example, the material status of Active allows all transactions and disallows no transactions. Conversely, the material status of Immature allows picking and shipping for internal customer orders, but disallows these transactions for external customer orders.
Status
Active
Hold
Immature
Almost Mature
Disallowed
Nothing
Picking, shipping, and production
Picking and shipping for external customers
Shipping for customer
Allowed
Everything
Subinventory transfers
Picking and shipping for internal customers
Picking for customer
Item attribute with status controlled.


Defining transaction types as status enabled
Warehouse Manager: Navigation- Setup/Transaction setup/transaction type
In this setup you can decide if the transaction type is status controlled or not.

Material status control
You can use existing material statuses or have a custom defined status
For example I have defined custom status ORA_QC_HOLD for which restricting customer sales order shipping.


Now enabling the onhand level material status by which I can apply above created status on the LPN.


Enabling Onhand Material Status
Activate Onhand Level Material Status Tracking


Check the inventory org parameter you can see the default status


#1- Change LOT status using lots screen
Inventory : Navigation - onhand, availability/lots
Click on the lots screen under onhand, availability. You will see default status as Active.

If you click on the blue record indicator (highlighted above) you can change the lot status of the lot from there.


#2- Change Subinventory/locator status
Inventory : Navigation - setup/subinventory


#3- Change LPN status using material workbench
For example see LPN LPN368A having status as Active

Now changing it to ORA_QC_HOLD


Status is changed please note the disallowed status with our custom status.

Check the transaction

As the status of the lpn was disallowing the sales order issue so above message pops up.


Now set the lpn status back to active and try shipping the order with the same lpn





As material status active allows all the transaction so now we see no issues while shipping the order.


This explains the WMS Material status and flow.

Thanks,
Ajay


Filed under , having

4 comments:

Irfan said...

Hai ajay
Thanks for post
can u explain why wehave two refrence contract no while making standard po from contract agreement

Thanks
Irfan

Manis Ibu said...

BAGAIMANA SAYA MENDAPATKAN PINJAMAN SAYA
Saya Abdullah Nofia yang tinggal di Papua, saya di sini untuk memberi kesaksian seorang Lender Pinjaman yang baik yang menunjukkan cahaya kepada saya setelah ditipu 3 kali berbeda di Internet oleh beberapa pemberi pinjaman yang tidak lain adalah palsu,
Mereka semua berjanji untuk memberi saya pinjaman setelah membuat saya membayar banyak kepada mereka sebagai biaya yang tidak menghasilkan apa-apa dan sebesar tidak ada hasil positif. saya kehilangan uang hasil kerja keras saya dan itu sangat membuat frustrasi.

Suatu hari ketika menelusuri internet saya menemukan kesaksian seorang wanita yang juga ditipu dan akhirnya dikaitkan dengan perusahaan pinjaman yang sah, ONE BILLION RISING FUND  dan di mana dia akhirnya mendapatkan pinjamannya, saya memutuskan untuk menghubungi dia dan menjelaskan tekanan keuangan saya. kepadanya dan jika dia bisa membantu saya untuk berbicara dengan perusahaan,

 Saya kemudian menceritakan kepada mereka kisah saya tentang bagaimana saya ditipu oleh 3 pemberi pinjaman yang berbeda yang tidak melakukan apa pun selain merampok uang saya. Saya menjelaskan kepada perusahaan melalui surat dan semua yang mereka katakan kepada saya adalah untuk tidak menangis lagi karena saya akan mendapatkan pinjaman saya di perusahaan mereka dan saya juga telah membuat pilihan yang tepat dengan menghubungi mereka. Saya mengisi formulir permohonan pinjaman dan melanjutkan dengan semua yang diperlukan dari saya dan saya terkejut, saya diberi pinjaman sebesar Rp 200 juta oleh perusahaan besar ini, ONE BILLION RISING FUND, semua berkat JAMES (direktur transfer), seorang yang takut akan Tuhan. pria dan mentor dan di sini saya hari ini bahagia karena perusahaan ini telah memberi saya pinjaman jadi saya bersumpah pada diri sendiri bahwa saya akan terus bersaksi tentang pekerjaan baik mereka dalam hidup saya tentang bagaimana saya mendapatkan pinjaman saya.
 Jika Anda mencari cara mendapatkan pinjaman, silakan hubungi

NAMA ::ONE BILLION RISING FUNDGmail ::: onebillionrisingfund@gmail.com

                                          HUBUNGI SAYA

Namaku ::::::::: Abdullah Nofia
Gmail::::::::::::::abdullahnofia@gmail.com
Instagram::::::::Abdullah_Nofia
Facebook:::::::::Abdullah Nofia

Bijaksanalah saat Anda mencari pinjaman online

semoga harimu menyenangkan

Unknown said...

Fanduel - Casino, Games, Games, Casino, Poker - FilmFileEurope.com
Fanduel Casino, Games, 노리터 주소 Casino, Poker. This page contains an Overview about the casino 배트맨토토 games, the games, 뱃 플릭스 how to play, 롤 대리 bonuses, and 홀짝사이트 샤오미

Unknown said...

How to Make Money With an Online Betting Website | Work4Life
This can also 아이 벳 25 be done by putting a bet on 토 찾사 a sportsbook or 벳 인포 스포츠 토토 분석 벳피스트 other หาเงินออนไลน์ gambling site. It's important that you never 다 파벳 모바일 bet on who will win.

Post a Comment