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 →
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 →
Oracle E-Business Suite 12.2.8 now Avaiable
Oracle announced the Oracle release 12.2.8.... Link to post. https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1228-now-available Link to PDF http://www.oracle.com/us/products/applications/ebs-2018-innovations-5119373.pdf
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 →
Pick Slip with full quantity in stock
In this post I will show you how to configure within the system the option to make the pick slip only with the full amount of the items in the sales order. Example: Sales order with an item X with quantity 4. Quantity in stock: 2. In the normal Oracle configuration process at the time... Continuar Lendo →
Copy of Bills and Routings
In this article I will show how to make a copy of a bills or routings. Usually the business area have the situation of opening a new branch, in this new subsidiary probably productive, will have or create new structures, or have the option to make copies of existing structures. To facilitate the work use... 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 →
Query for Pick/Delivery Materials
This post I will show a query that will help on control of material output and sales orders issue. Pick Slip Move Order Transaction Ship Confirm SELECT hp.party_name cliente, ooha.cust_po_number po_cliente, ooha.order_number ordem_venda, (SELECT customer_line_number FROM oe_order_lines_all oola WHERE oola.header_id = ooha.header_id AND oola.line_Id = wsh.source_line_id ) linha_po_cliente, source_line_number linha, mib.segment1 item, mib.description descricao_item, wsh.date_scheduled... Continuar Lendo →
Comparison of ASCP Plan Exceptions
In this article I will demonstrate functionality that assists in research and decision making about changes in the production plane. One of the big problems companies have with regard to planning is whether their production plan X capacity are aligned with the productive reality. Today, to know if your production plan is coherent, one of... Continuar Lendo →