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

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

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

“AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations” recorded session

I presented “AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations” session at OATUG Form Online on 04/20/2020. Here is the recording for the session. AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations Presentation PDF Document

Categories EBS

Installing Oracle Developer Suite 10g on Windows 10 64 bit for EBS R12 Custom Forms & Reports Development

When installing the certified version of Oracle Developer Suite 10g (10.1.2.0.2) for custom forms/reports development in E-Business Release 12 on windows 10+64 bit client desktop, The command prompt shows up, then gracefully exists; the Oracle Universal Installer never shows up. You have tried changing the compatibility of the setup.exe to Windows XP and running as … Read more

Copying a concurrent program

We have common business requirement to customize the seeded reports/programs like Sales Order Acknowledgement, Invoice Print New Invoices, Invoice Print Selected Invoices, Autoinvoice Import Program etc., In this case, We don’t modify the existing concurrent program’s definition/concurrent program’s source PL/SQL procedure or report, but we will create a copy of the source procedure or report … Read more

What Is Machine Learning?

Machine learning is the subset of artificial intelligence (AI) that focuses on building systems that learn—or improve performance—based on the data they consume. Artificial intelligence is a broad term that refers to systems or machines that mimic human intelligence. Machine learning and AI are often discussed together, and the terms are sometimes used interchangeably, but … Read more

What is the Internet of Things (IOT)?

Simply put, this is the concept of basically connecting any device with an on and off switch to the Internet (and/or to each other). This includes everything from cellphones, coffee makers, washing machines, headphones, lamps, wearable devices and almost anything else you can think of.  This also applies to components of machines, for example a … Read more

Oracle EBS R12.2 Application Technology new features

Online Patching: One of the key Feature of R12.2 is the switch to online patching. This helps to reduce significantly the downtime traditionally needed for patching and related maintenance activities An edition is a private environment in which you can redefine database objects. With online patching, patches are applied to a separate edition while users … Read more

Categories EBS

My understanding about Blockchain Technology

Blockchain is a chain of blocks. It is a technology, not a currency like Bitcoin. Bitcoin has leveraged Blockchain technology. The Blockchain is a decentralized, distributed and incorruptible digital/electronic ledger. In the same way the internet facilitates direct exchange of information, Blockchain facilitates direct exchange of value between parties, without the need for a trusted … Read more