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

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

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

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

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