Create OPM Batch – New Materials Operations-Activities-Routings-Resources-Transactions on OPM

This post I will show a API to create Operations, Activities, Generic Resources and Routings on OPM. Create OPM Batch DECLARE l_api_version NUMBER := 2.0; l_validation_level NUMBER DEFAULT GME_COMMON_PVT.G_MAX_ERRORS; p_init_msg_list BOOLEAN DEFAULT FALSE; P_batch_type NUMBER := 0; p_batch_qty NUMBER := 5; l_batch_header gme_batch_header%ROWTYPE; x_batch_header gme_batch_header%ROWTYPE; l_message_count NUMBER; l_message_list VARCHAR2 (500); l_return_status VARCHAR2 (1); l_msg_index_out NUMBER;... Continuar Lendo →

Auto Create deliveries – API

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 →

Criar Ordens de Movimentações via API

Neste post irei mostrar API para criar ordens de movimentações Cabeçalho e Linha. DECLARE l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2 (2) := FND_API.G_TRUE; l_return_values VARCHAR2 (2) := FND_API.G_FALSE; l_commit VARCHAR2 (2) := FND_API.G_FALSE; x_return_status VARCHAR2 (2); x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (255); -- WHO columns l_user_id NUMBER := -1; l_resp_id NUMBER := -1; l_application_id... Continuar Lendo →

API para criar cliente – perfil e conta

Neste post irei mostrar uma API para criar o cadastro do cliente. DECLARE custAcccountRec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; custProfileRec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; custOrgRec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; custPartyRec HZ_PARTY_V2PUB.PARTY_REC_TYPE; x_cust_account_id NUMBER; x_account_number VARCHAR2 (30); x_party_id NUMBER; x_party_number VARCHAR2 (30); x_profile_id NUMBER; x_return_status VARCHAR2 (3); x_msg_count NUMBER; x_msg_data VARCHAR2 (3000); l_collector_id NUMBER; BEGIN DBMS_OUTPUT.PUT_LINE ('In createCustomer Procedure.'); mo_global.init ('AR'); fnd_global.apps_initialize (user_id => 26801, resp_id... Continuar Lendo →

Criar Transações de Transferência no INV

Neste post irei mostrar como criar uma transação no INV e depois processá-la automaticamente. INSERT INTO mtl_transactions_interface (transaction_header_id, source_code, source_line_id, source_header_id, process_flag, transaction_mode, last_update_date, last_updated_by, creation_date, created_by, organization_id, transaction_quantity, transaction_uom, transaction_date, transaction_type_id, inventory_item_id, subinventory_code) VALUES (12345, --TRANSACTION_HEADER_ID, 'Teste', --SOURCE_CODE 83, --SOURCE_LINE_ID, 83, --SOURCE_HEADER_ID, 1, --PROCESS_FLAG, 3, --TRANSACTION_MODE, SYSDATE, --LAST_UPDATE_DATE , 26801, --LAST_UPDATED_BY , SYSDATE, --CREATION_DATE... Continuar Lendo →

API to create Receipt on Oracle Receivables

This post I will show a API to create a receipt on oracle Receivables. DECLARE l_error_description VARCHAR2 (2000) := NULL; l_ar_receipt_succ_count NUMBER:= 0; l_ar_receipt_err_count NUMBER:= 0; l_ar_receipt_tot_count NUMBER:= 0; l_msg_index_num NUMBER:= 1; l_msg_count NUMBER; l_data_txt VARCHAR2(1000); l_msg_data VARCHAR2(1000); l_apl_return_status VARCHAR2 (1); l_apl_msg_count NUMBER; l_apl_msg_data VARCHAR2 (240); l_org_id NUMBER; l_gl_date_count NUMBER; l_functional_currency fnd_currencies.currency_code%TYPE; l_conv_type gl_daily_conversion_types.conversion_type%TYPE; l_conv_rate... Continuar Lendo →

Oracle FNDLOAD scripts

Segue abaixo os exemplos de fndload tanto para upload quanto para download de arquivos do EBS. 1. Lookups -- ------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 2. Concurrent Program -- ----------------------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM" FNDLOAD... Continuar Lendo →

API para Criar Previsões

Neste post irei demonstrar a API para criar previsões que podem ser usadas no MRP e no ASCP Posteriormente. DECLARE t_forecast_interface_tab MRP_FORECAST_INTERFACE_PK.t_forecast_interface; t_forecast_designator_tab MRP_FORECAST_INTERFACE_PK.t_forecast_designator; var_bool BOOLEAN; BEGIN t_forecast_interface_tab (1).inventory_item_id := 3921; t_forecast_interface_tab (1).forecast_designator := 'SK-FORECST'; t_forecast_interface_tab (1).organization_id := 207; t_forecast_interface_tab (2).forecast_date := TO_DATE ('19-FEB-2019'); t_forecast_interface_tab (1).bucket_type := 2; t_forecast_interface_tab (1).quantity := 100; t_forecast_interface_tab (1).process_status :=... 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 →

Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑