Oracle EBS Manufacturing
Hi, this post I will show how create an miscellaneous transaction with API Receipt INSERT INTO mtl_transactions_interface ( source_code --01 , source_line_id --02 , source_header_id --03 , process_flag --04 , transaction_mode --05 , validation_required --06 , inventory_item_id --07 , organization_id --08 , subinventory_code --09 , transaction_quantity --10 , transaction_uom --11 , primary_quantity --12 , transaction_date... Continuar Lendo →
This post I will show how create an employee with API Execute this command below DECLARE lc_employee_number per_all_people_f.employee_number%TYPE := '183096723'; ln_person_id per_all_people_f.person_id%TYPE ; ln_assignment_id per_all_assignments_f.assignment_id%TYPE; ln_object_ver_number per_all_assignments_f.object_version_number%TYPE; ln_asg_ovn NUMBER:=5; ld_per_effective_start_date per_all_people_f.effective_start_date%TYPE; ld_per_effective_end_date per_all_people_f.effective_end_date%TYPE:=NULL; lc_full_name per_all_people_f.full_name%TYPE; ln_per_comment_id per_all_people_f.comment_id%TYPE:=NULL; ln_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE; lc_assignment_number per_all_assignments_f.assignment_number%TYPE; lb_name_combination_warning BOOLEAN; lb_assign_payroll_warning BOOLEAN; lb_orig_hire_warning BOOLEAN; BEGIN HR_EMPLOYEE_API.create_employee (p_hire_date => TO_DATE('03/12/2011','DD/MM/YYYY'), p_business_group_id => FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID'),... Continuar Lendo →
This post I will show how to close and reopen the batch with an API. This batch order is win completed status. Execute this below command: DECLARE l_api_version NUMBER := 2.0; l_validation_level NUMBER default GME_COMMON_PVT.g_max_errors; l_message_count NUMBER; l_message_list VARCHAR2(500); l_return_status VARCHAR2(1); p_org_code VARCHAR2(10); p_batch_no VARCHAR2(10); p_batch_rec gme_batch_header%ROWTYPE; x_batch_rec gme_batch_header%ROWTYPE; xitem VARCHAR2(16); BEGIN FND_GLOBAL.apps_initialize(user_id => 1139,... Continuar Lendo →
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 →
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 →
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 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
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 →
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 →
Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren