Oracle EBS Blog

ECC Menu Configuration Fix for Data Set Authorization Errors

Introduction: While accessing Oracle E-Business Suite Embedded Command Center (ECC), users may encounter the error “400 Bad Request: Current user not authorized to access data set” for specific ECC datasets…

Read More

Resolving JVM Startup Failures in Tomcat: Invalid Heap Size and Unsupported Class Version Errors

Introduction: Java-based middleware components such as Apache Tomcat and ORDS are highly dependent on correct JVM configuration. Misalignment between Java versions and heap settings can result in critical startup failures.…

Read More

Oracle ERP Cloud Period Close Procedures & Runbook Considerations

Introduction/ Issue:  Oracle ERP Cloud customers have a need to close their books every period, quarter and/or year.   This paper provides guidance on the period-end close procedures for Oracle Cloud…

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

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

Ship 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

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

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

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

R12 Oracle General Ledger Setup

r12-oracle-general-ledger-setup

Read More