EBS

AP: Create Accounting Completed In Warning with Offsets Error

Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attempting to run the Create…

Read More

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 More

Multi-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 More

Resolving 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 More

Resolving 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 More

oacore_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 More

Removing 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 More

View 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 More

Concurrent 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 More

Shipment 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 More