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 MoreMulti-Node EBS with DMZ Setup
Many of you have asked about the best storage options for a multi-node EBS setup involving a DMZ server with a public load balancer. Here are some insights and best…
Read MoreResolving ORA-20001: Synonym Does Not Point to an Editioning View in ADOP Phase of Oracle EBS
Introduction During the ADOP (Online Patching) process of Oracle E-Business Suite (EBS), you might encounter the following error message while running Autoconfig as part of adop phase=prepare: ORA-20001: Synonym does…
Read MoreResolving Port Conflicts During ADOP Validation in Oracle E-Business Suite
Introduction: The ADOP (Autonomous Database Operations) process is a crucial component of the Oracle E-Business Suite (EBS) used during patching, cloning, and upgrades. During the validation phase of ADOP, a series of…
Read Moreoacore_server1- failed to startup with javax.naming.NameNotFoundException Error
DESCRIPTION: Getting oacore_server1- failed to startup Error when starting EBS R12.2.5 after clone. CAUSES: oaea_server1 is not registered in cloned Weblogic console. SOLUTION: Add the datasource of oaea_server1 in Weblogic…
Read MoreRemoving node name in EBS R12.2
DESCRIPTION: After EBS Test Clone EBS Prod URL Redirecting to EBS Test URL. CAUSES: EBSTEST Node Name is Added into EBS PROD’s Node table. SOLUTION: Remove the EBSTEST Node name…
Read MoreView Output/Log returns “Authentication Failed/File server could not identify source file ” error Concurrent Program – R12.1.3
In Oracle E-Business Suite R12.1.3, when you try to view a report output/log, the following two errors are displayed: File server could not identify source file. or Authentication failed. In…
Read MoreConcurrent Program Failure with Error “FDPSTP failed due to ORA-20100”
User Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with Below Error. Oracle Database 19c (Multitenant) and EBS Application is 12.2.10 running…
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 More