Neste post irei demonstrar a API para criar previsões que podem ser usadas no MRP e no ASCP Posteriormente. DECLARE t_forecast_interface_tab MRP_FORECAST_INTERFACE_PK.t_forecast_interface; t_forecast_designator_tab MRP_FORECAST_INTERFACE_PK.t_forecast_designator; var_bool BOOLEAN; BEGIN t_forecast_interface_tab (1).inventory_item_id := 3921; t_forecast_interface_tab (1).forecast_designator := 'SK-FORECST'; t_forecast_interface_tab (1).organization_id := 207; t_forecast_interface_tab (2).forecast_date := TO_DATE ('19-FEB-2019'); t_forecast_interface_tab (1).bucket_type := 2; t_forecast_interface_tab (1).quantity := 100; t_forecast_interface_tab (1).process_status :=... Continuar Lendo →
Criação automática de ordens MRP/ASCP
Nest post irei demonstrar como configurar no sistema a opção de criar automaticamente as ordens que são criadas na bancada do MRP/ASCP. Na bancada abaixo mostra vários registro com várias datas. Na opção convencional o planejador vai a bancada e decide o que vai criar de ordens. Porém pode-se configurar para gerar as ordens automaticamente.... Continuar Lendo →
Working with shrinkage rate MRP / ASCP
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 →
Charge x Capacity with Resource Efficiency Restriction
In this post I will show one of the functionalities with MRP and ASCP. Inside a shop floor we have several processes going on at the same time, and from a planning point of view, one of the main problems is charge and capacity control. Within the various configurations that are required, it is possible... Continuar Lendo →
Audit Report
In this article I'll show you a report that might be helpful to the company that wants to update your data. The company over the years, grows as needed and consequently your database tends to grow as well. One of the big problems is that the process of controlling this growth is sometimes left out.... Continuar Lendo →
Using the UseUp Date ECO-MRP
In this article I will demonstrate a functionality of the Engineering module that integrates directly with MRP, this is the UseUp date functionality in the engineering module, it is nothing more than a date that Oracle suggests will be the end of the demand required for a particular item. Suppose you want to disable an... Continuar Lendo →
Slipt MRP supply lines
This post I will demonstrate how to split MRP supply lines based on rules by vendor. If you have a component that can be purchased from multiple vendors, manufactured in several steps, or transferred from other inventory organizations, Oracle has the ability to record these rules as needed. Using the example of buying an item... Continuar Lendo →