Hi, this post I will show the API to create deliveries. DECLARE l_operation VARCHAR2 (30) := 'Autocreate Delivery '; x_return_status VARCHAR2 (1); x_msg_data VARCHAR2 (2000); x_msg_count VARCHAR2 (2000); p_api_version_number NUMBER; init_msg_list VARCHAR2 (30); x_msg_details VARCHAR2 (3000); x_msg_summary VARCHAR2 (3000); l_line_rows WSH_UTIL_CORE.ID_TAB_TYPE; l_del_rows WSH_UTIL_CORE.ID_TAB_TYPE; i NUMBER :=1; BEGIN x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; FND_GLOBAL.APPS_INITIALIZE (user_id => 1139, resp_id... Continuar Lendo →
Fazer backorder de várias linhas via API
Nesse post irei deixar uma API para fazer backorder em alto volume. DECLARE l_return_status VARCHAR2 (100); l_msg_count NUMBER; l_msg_data VARCHAR2 (2000); l_msg_index NUMBER; l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_org_id NUMBER := &org_id; l_move_order_line_id NUMBER := &mo_line_id; BEGIN SELECT user_id INTO l_user_id FROM fnd_user WHERE user_name = 'PRAWILNSON'; SELECT responsibility_id, application_id INTO l_resp_id, l_appl_id FROM... 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 →
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 →
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 →
Create Pick Slip
This post I show many methods of create a pick slip on Oracle EBS. Lauch pick realease make on screen in shipping transactions; Release Sales Orders make on forms; Release Sales Orders make by concurrent requests 1 The first method is make this move inside on shipping transactions: 2 Second method is create rules and... Continuar Lendo →
Order Management Prepayment Setup
In this article I will demonstrate one more functionality of Oracle. Within the Order Management module it is possible to make pre-payments before even generating the final invoice for the product. Suppose a customer makes a purchase of a product and half of the production is necessary to 20% down. Within OM it is possible... Continuar Lendo →
Order Management Row Changes
In this article I will demonstrate functionality within Order Management to make changes to more than one line. There are cases and many where you need to make changes to several or all order management lines. This can give a whole work. The example below has 1088 rows. Suppose you need to change the schedule... 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 →
Split Lines in Delivery Transactions
In this post I will show that there is the possibility of split lines in the sales orders deliveries. In the images below it shows how the process is done. Order Management -> Shipping -> Transactions Right click inside the record you want to do the split, then in the Split line option. Put the... Continuar Lendo →