Hi, this post I will show how to configure intransit lead times for the ASCP to see the ship_date.... Order Management Super User -> Shipping – Setup -> Freight Carriers, Cost Types -> Freight Carriers Order Management Super User -> Shipping – Setup -> Region and Zones -> Region and Zones Criar Zones e Locations... Continuar Lendo →
Create an employee with API
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 →
Criar requisições de compra/interna via interface
Olá, segue abaixo um exemplo de código para criar requisição de compra/interna. INSERT INTO po_requisitions_interface_all (interface_source_code, source_type_code, requisition_type, destination_type_code, item_segment1, item_description, quantity, authorization_status, preparer_id, autosource_flag, uom_code, destination_organization_id, destination_subinventory, deliver_to_location_id, deliver_to_requestor_id, need_by_date, gl_date, charge_account_id, accrual_account_id, variance_account_id, org_id, suggested_vendor_id, suggested_vendor_site_id, unit_price, creation_date, created_by, last_update_date, last_updated_by) VALUES ('INV', 'VENDOR', 'PURCHASE', 'INVENTORY', '887788', 'Teste importação de item', 1, 'INCOMPLETE',... Continuar Lendo →
API para submeter para aprovação a OC
Nesse post irei mostrar uma API para submeter para aprovação uma ordem de compra via API. Crie uma Ordem de Compra 2. Rode o script abaixo DECLARE v_item_key VARCHAR2 (100); l_result NUMBER; lv_request_id NUMBER; v_phase VARCHAR2(4000); v_status VARCHAR2(4000); v_dev_phase VARCHAR2(4000); v_dev_status VARCHAR2(4000); v_message VARCHAR2(4000); CURSOR c_po_details IS SELECT pha.po_header_id, pha.org_id, pha.segment1, pha.agent_id, pdt.document_subtype, pdt.document_type_code, pha.authorization_status... 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 →
Alterar/Fechar/Cancelar Linhas de Compra
Olá pessoal, caso você queira fazer mudanças dentro de uma OC, a Oracle disponibiliza API e packages que podem lhe ajudar nesse trabalho. Hoje irei repassar o código para fazer modificações dentro de uma OC. --- Cancelar uma Linha de OC DECLARE l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_result NUMBER; l_api_errors po_api_errors_rec_type; l_revision_num NUMBER; v_shipment_number... Continuar Lendo →