There is a setting called a loss rate within the item master record that can be used to determine a loss percentage for the item. Ex without setup the item: Demand de qtde 10 para 10-jan-2019 Supply de qtde 10 para 10-jan-2019 With setup Item to 0.5 = 50% loss. Demand of quantity 10 para... Continuar Lendo →
Dias Fixo de Suprimento MRP/ASCP
Neste post irei mostrar uma funcionalidade que serve para agrupar as demandas e fornecer um registro só de suprimento. Essa funcionalidade pode ser útil para evitar milhares de registros de suprimento que o sistema sugere facilitando assim a compra de uma máteria prima. Esse setup vai depender se o fornecedor tem a capacidade ou não... Continuar Lendo →
Working with MRP / ASCP Demand Time Fence
Sales order and manual demands are considered, and forecasting demands may or may not be produced, so the planner can decide whether, it depends the configurations that are put into the item setup. Ex: I have demands from two sources. Sales Orders and Forecast TESTE_FABRICAR -> Ordem de Venda -> 15-JAN-2019 TESTE_FABRICAR -> Previsão ->... Continuar Lendo →
Working with MRP / ASCP Planning Time Fence
In this post I will sho how we can control our production plan with some settings within the item setup. If our plan has demand entry at sales orders or manual demand. This demand is the demand date is 11-11-2018, however for manufacture the item it takes 150 days (calendar of the inventory organization). No... Continuar Lendo →
Schedule Ship Date x Schedule Arrival Date
There are many option on this setup that be considered to determinate th source and delivery destiny. Internal Determinated froo warehouse and internal customer organization. External Determinated from customer address. Region Determinated from setup of customer region Zone Determinated from setup customer zone. The example that we will simulate it's based on internal time transit.... Continuar Lendo →
Itens Genealogy with Serie/Lot and Inventory Positions
Hi, this post I show one functionality for control about all itens transactions based on lot and serie. A lot of companys have stock and material control audits, for this, the Oracle create an option when the user find using many filtrers the item moves. When enter the screen, there are parameters that can aid... Continuar Lendo →
API Create Reservations
In This Post I want to show how create a reservations using API Oracle Some times it's necessary to use API for work with integrations. The script below can be used for create a reservation. DECLARE l_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_new_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_new_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; x_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2 (2) := FND_API.G_TRUE;... Continuar Lendo →
Restricting Subinventory for Transfers
In this post I will show the functionality that can be useful for controlling the traffic of material from one location to another. Within Oracle you can make item transfers from one sub-inventory to another. After the source subinventory and destination subinventory and the source list will appear all active subinventors that allow transfers. But... Continuar Lendo →
Setup Returnable Item
In this article I will show that to make a return within the Order Management it is necessary to make a setup inside the Master Items. The example below shows the message when you try to record a return in Order Management. In this case it is necessary to make the setup below in the... Continuar Lendo →
Create Exceptions Sets
In this post I will shw how to create an exception set, and assign it to an item and simulate two examples. The Oracle Planning Module there are exceptions for you to control your production plan, but it allows you to make exceptions records as you need them. Shortage Exceptions After did this registration you... Continuar Lendo →