Oracle EBS Manufacturing
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 →
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 →
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 →
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 →
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 →
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 →
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 →
Como é comum entre os clientes, precisar fazer carga de categorias para o Sistema, a Oracle tem um processo que importa as categorias via script. Para efetuar essa carga deve-se alimentar a tabela mtl_item_categories_interface, segue abaixo o script para fazer isso. Processo de Criar uma categoria vinculada ao item: INSERT INTO mtl_item_categories_interface (inventory_item_id, organization_id, transaction_type,... Continuar Lendo →
Olá pessoal, dentro do EBS, existem alguns tipos de planejamento, MRP/MPS - Estoque de Segurança - Mínimo e Máximo e Kanban. Hoje irei mostrar o tipos de origem dentro do planejamento kanban. Os tipos de origem que o Oracle EBS proporciona são os seguintes: Interorg. Fornecedor. Intraorg. Produção. Interorg -> Ao solicitar reposição do item... Continuar Lendo →
Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren