Delete the concurrent programs
Delete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concurrent program needs…
Read MoreShipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (32767); l_changedattributetabtype wsh_delivery_details_pub.changedattributetabtype; BEGIN fnd_global.APPS_INITIALIZE (0, 21676, 385); — Provide user_id, resp_id and…
Read MoreShip Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_version NUMBER := 1.0; p_init_msg_list VARCHAR2(30); –Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15); p_delivery_id NUMBER:= p_delivery_id_s; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER:=p_trip_id;…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreExcessive MMON Trace Files Generation in DB Trace File Location
DESCRIPTION: The size MMON trace files gets increased which is causing trace file Location Overflow. CAUSE: Trace files generation with message “AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1”. Regarding…
Read MoreTroubleshooting Support Connectivity Issues in OEM 13.5
Troubleshooting My Oracle Support Connectivity Issues in Oracle Enterprise Manager (13.5) Introduction: Greetings! This blog is all about my oracle support connectivity issue in Oracle Enterprise Manager and is your go-to…
Read MoreOracle EBS – Archive the file with Script
By using the bleow script, we can archive the file from specific folder to back up folder in the server location. # =============================================================================+ export ora_login=$1 export ora_userid=$2 export login_name=$3…
Read MoreSERVICE CONTRACT – Oracle External Table
This is the sample script to create the oracle external table to access the data from the file. prompt prompt creating TABLE XX_SC_EXT ….. CREATE TABLE “XX”.”XX_SC_EXT” (…
Read MoreDeploying plugin on OEM
Deploying plugin on Oracle Enterprise Manager (OEM 13c) Introduction Greetings! This blog is all about deploying Oracle E-business suite (EBS) plugins on OEM and is your go-to guide for…
Read More