Venkanna Mittakanti

Oracle EBS – Application User Maintenance SQL Scripts

by

Here are the SQL Scripts to create application user, reset application user’s password and adding responsibility thru SQL Plus / Toad / SQL Developer. Connect as APPS to execute the scripts. Creating application user — creating application userDECLAREl_user_name VARCHAR2(100) := UPPER(‘VMITTAKANTI‘); — Usernamel_password VARCHAR2(30) := ‘Welcome1‘; — Passwordl_session_id INTEGER := USERENV(‘sessionid’);BEGINfnd_user_pkg.createuser (x_user_name => l_user_name,x_owner => … Read more

R12.2.10 – Country of Origin for On-hand Inventory

by

Most of the businesses have a requirement to capture Country Of Origin (COO) while receiving the goods and track the item’s on-hand by Country of Origin. This functionality isn’t available with Oracle EBS R12.2.9 & lower versions including EBS R12.1. Unfortunately there is no good custom solution also to implement this type of business requirement. … Read more

Categories EBS

Oracle Groundbreakers APAC Virtual Tour 2020

by

The Oracle Groundbreakers APAC Groundbreakers Tour will be virtual this year with presentations on Cloud, Database, Java, Applications, Hands-on Labs and more. The event will be held from October 19-30, 2020. Registration and agenda are live I will present two sessions for the event. Emerging Technologies – Overview of Robotics Process Automation and it’s use … Read more

Oracle Groundbreakers EMEA Virtual Tour

by

I’m speaking at Oracle Groundbreakers EMEA Virtual Tour. Please join me for a virtual session “Empowering Oracle EBS with Enterprise Command Centers Dashboards” on Oct’13th, 2020 at 3.00 PM CEST (8.00 am CST). Please register for the session at registration link for free. Oracle ACEs will be presenting on Cloud, Database, Analytics/Data Science, Oracle EBS, … Read more

OATUG Forum Live – December 6-9,2020

by

Oracle Applications and Technology Conference in Las Vegas – OATUG Forum Live Join OATUG’s first hybrid event this winter! OATUG Forum Live will deliver education and insights for the Oracle community this Dec. 6-9. Participate in-person in dazzling Las Vegas or via the Virtual Experience — whatever you choose, there’s great Oracle education and networking … Read more

Texas Louisiana OATUG and Dallas Oracle Users Group joint Oracle education event on 10/01/2020

by

Texas Louisiana OATUG and Dallas Oracle Users Group joint Oracle education and networking event on Oct’1st,2020! This event will be a virtual event with sessions ranging from database and development to Oracle E-Business Suite and Oracle ERP Cloud. You can download the agenda and register to attend the event now: https://www.oatug.org/tloatug/home

E-Business Suite Releases and support timelines

by

Oracle E-Business Suite 12.1 release will move into Oracle Sustaining Support in January 2022 and you will no longer receive new fixes, updates, or security patches. Release 12.1 premium support ends in Dec’2021. Sustaining Support poses a high risk for business-critical applications. Oracle and industry experts advise against running mission-critical applications on software that is … Read more

Categories EBS

Blockchain tables in Oracle Database 20c

by

Blockchain is a very popular and new data paradigm. Oracle makes it easy for applications to use Blockchain technology to help identify and prevent fraud. In Database 20c, new type of table called Blockchain table. This looks like normal table except as the rows are inserted into Blockchain Table, there are cryptographically chained together. This … Read more

Locks on the EBS object(s) and how to remove locks

by

Some times you get the error message as “The record cannot be reserved for update. It has already been reserved by another user” or “Could not reserve record(2 tries). Keep trying?” While querying/updating the Purchase Order/Sales Order/any other transaction/setup screen in the Oracle EBS or Oracle DB related custom applications. Generally you get this message … Read more

Single Shipment to the Order – Deliver available quantity and cancel unshipped lines/quantities automatically

by

Order processing in certain scenarios requires to deliver available quantity and cancel the remaining quantity and unshipped lines instead of creating the back order. This is very common requirement from some customers to send a single shipment for their orders. Currently there is no way to setup this in Oracle EBS R12.2.8 or prior versions, … Read more

Categories EBS