Posts tagged “ebs reporting”

Find an IP address and geolocation of EBS clients’ logins

By Alexander Pavlik|October 8th, 2021|

Introduction 1 Setup 1.1 Choosing a geolocation API 1.2 Configuring http requests from Oracle Database 1.2.1 Create a new Access Control Entry (ACE) 1.2.2 Obtain the geolocation API website certificate 1.2.3 Import the certificate into an Oracle Wallet 2 Create a geolocation function 3 [...]

SROATUG: Worlds fastest EBS reporting introduces templates, pivots and drill-downs

By Geoff Skerrett|September 2nd, 2021|

Blitz Report™ - Pivot tables, Excel templates with charts and graphs We are excited to be introducing new features in Blitz Report that really help make EBS reporting easier, faster and more efficient. Blitz Report users can define a pivot tables for an existing report [...]

ECO Conference

By Beth Skerrett|September 2nd, 2021|

ECO Conference is hosted by the Virginia Oracle Users Group, the Eastern States Oracle Applications & Technology Users Group, the former Hampton Roads Oracle Users Group, and the Southeastern Oracle Users Group. The collaboration targets both technical and functional Oracle users, including managers, directors, DBAs, [...]

NYOUG: Running Oracle EBS on Cloud? Beware of this overlooked performance metric

By Beth Skerrett|August 31st, 2021|

Running EBS on Cloud? Beware of this overlooked performance metric Database systems running on modern hardware are no longer constrained by I/O or memory shortage as both of these historic performance bottlenecks have been addressed by hardware technology advancements. The biggest constraint to system performance [...]

AUSOUG: Running EBS on Cloud? Be aware of this overlooked performance metric!

By Geoff Skerrett|August 31st, 2021|

Running EBS on Cloud? Be aware of this overlooked performance metric! Andy Haack will lead this session and review one of the most overlooked performance metrics that will help your team get the best results when running Oracle EBS in the cloud. Registration is [...]

UKOUG 2021. Together

By Artem Nesterko|August 31st, 2021|

UKOUG together 2021 is one of the largest events in the UK since 2020. The conference will be held at the Kia Oval, London on 29 and 30 November, bringing both Applications and Technology communities together, under one roof. Come and visit our Enginatics booth [...]

Simplifying DBA tasks with Blitz Report

By Alexander Pavlik|January 11th, 2021|

I am an EBS Apps DBA. When I talk with other DBA.s, it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a [...]

Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases

By Alexander Pavlik|September 19th, 2020|

Introduction 1 Install Oracle Database Gateway for ODBC 1.1 Reference 1.2 Download Gateway Installer 1.3 Install Gateway 1.4 Create a Gateway Environment File 2 Install the unixODBC Driver Manager on the Gateway Server 3 Configure Connection to a Vertica Database 3.1 Importing a Vertica [...]