Enginatics Blog

Oracle Supply Chain Hub that takes simplicity to another level

By Glen Whelan|March 23rd, 2020|

Objective: Inventory supply chain planning optimization Audience: IT consultants, Sales & Operations Planning, Buyers and Customer Service teams Supply Chain Hub overview 1 Items / Indented Bill of Materials 2 Supply / Demand drill-down capability 3 Running Blitz Reports from the Hub 4 Item [...]

How to track master data changes using Oracle EBS Audit function and Blitz Report™

By Glen Whelan|March 21st, 2020|

Tracking master data changes via standard EBS Audit functionality 1 Audit Concurrent Requests and Industry Template 2 The standard audit report 3 Reporting performance improvement 4 Summary Tracking master data changes via standard EBS Audit functionality Audience: Master data, Support Consultants, and Operational teams. [...]

How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP)

By Glen Whelan|March 17th, 2020|

The Planners Workbench limitations 1 Adding Blitz Report to the Planner Workbench (optional) 2 Launching Blitz Report from the Planner Workbench (PWB) 3 Viewing the Excel report output 4 Launching Blitz Report from the standard menu 5 Summary The Planners Workbench (PWB) is the [...]

How to optimize Order Management form exports in Oracle EBS

By Glen Whelan|March 16th, 2020|

Exporting Order Organizer efficiently in Oracle Order Management 1 Adding Blitz Report to the Order Organizer form menu (Optional) 2 Launching Blitz Report from within Order Organizer 3 Viewing the Excel report output 4 Launching Blitz Report from the standard menu (if not executing [...]

Oracle Enterprise Command Center Framework upgrade to V3

By Alexander Pavlik|October 9th, 2019|

Introduction 1 References 2 Requirements 2.1 Supported OS versions 2.2 Required OS resources 3 Perform backups 3.1 Shutdown ECC 3.2 Compress ECC installation directory 3.3 Export Oracle Enterprise Command Center Framework Schema 3.4 Startup ECC 4 Run upgrade script 4.1 Verify the upgrade 5 [...]

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9

By Alexander Pavlik|August 30th, 2019|

Enginatics always stays up to date with the latest technology. So right after the availability of Oracle E-Business Suite 12.2.9 was announced, our team was eager to upgrade our EBS Demo 12.2.8 instance to the latest release, so anyone can test Blitz Report™ on [...]

Hyperlinks in Blitz Report™

By Artem Nesterko|August 17th, 2019|

Hyperlinks can be embedded in Blitz Report excel output files using the syntax: HYPERLINK("URL to the location", "alternate text") Here is an example: select hp.party_number, 'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name, hp.party_type from hz_parties hp where hp.url is not [...]

Migration to Java Web Start in Oracle EBS 12.2 instance

By Alexander Pavlik|June 28th, 2019|

Oracle recommends Oracle E-Business Suite customers to migrate from Java Plug-In to Java Web Start technology. Java Web Start allows to run EBS forms in browsers that ended support for the Netscape Plug-in Application Programming Interface. In this post we will share our experience on [...]

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8

By Alexander Pavlik|June 3rd, 2019|

Updated article version 1 Introduction 2 References 3 Operating System configuration 3.1 Supported OS versions 3.2 Required OS resources 3.3 Firewall settings 3.4 Cloud firewall configuration 3.5 Network configuration 3.6 Create OS users and groups 3.7 Install additional OS packages 4 Download and install [...]

Securing sensitive data with Oracle VPD

By Artem Nesterko|May 14th, 2019|

What is VPD? 1 Why VPD? 1.1 Scalability 1.2 Simplicity 1.3 Security 2 How does VPD work? 3 Securing HR data 3.1 Example 1: Row Level VPD 3.2 Example 2: Column Level VPD 3.3 Securing data while using Blitz Report 4 Which data to [...]

Previous 7 8910 Next