Oracle APEX Techno-Functional Consultant - Contract

Role: Oracle APEX Techno-Functional Consultant

Experience: 5+ Years

Type: Contract

Mode: Remote

Duration: 1 year

Role Overview

We are seeking a highly skilled Oracle APEX Techno-Functional Consultant to architect,

build, and maintain enterprise low-code applications. This role requires a hybrid profile capable

of handling complex technical development alongside functional requirements gathering.

You will lead key initiatives to extend Oracle E-Business Suite (EBS) functionality using Oracle

APEX, automate seamless data exchanges with Google Workspace REST APIs, and build

interactive External Pages & Reporting modules for internal and third-party stakeholders.

Oracle EBS Integration & Extension

● Design and deploy APEX extensions to bridge gaps in Oracle EBS (R12.1/R12.2) core

modules (Financials, SCM, HRMS).

● Build secure single sign-on (SSO) integrations between EBS and APEX using EBS FND

authentication, Web ADI alternatives, or custom APEX plugins.

● Ensure transaction integrity across Oracle EBS database schemes, custom schemas (XX

custom schemas), and public APIs/interfaces.

Google Workspace API Integrations

● Architect bidirectional RESTful API web service integrations using Oracle APEX

APEX_WEB_SERVICE and PL/SQL libraries.

● Automate workflows involving Google Drive (file generation and upload), Google Sheets

(data synchronization), Google Calendar, and Gmail API.

● Manage OAuth 2.0 authentication flows and token storage securely within Oracle APEX

environments.

External Pages & Enterprise Reporting

● Build responsive, public-facing, or third-party accessible APEX pages with fine-grained

role-based access control (RBAC).

● Design reporting interfaces utilizing APEX Interactive Reports (IR), Interactive Grids (IG),

and APEX Office Print (AOP) or JasperReports for pixel-perfect PDF/Excel output.

● Embed modern UI/UX practices using Universal Theme, Custom CSS, JavaScript,

dynamic actions, and AJAX processes for web pages.

Functional & Stakeholder Management

● Gather end-user requirements, translate business needs into technical specifications

(BRD/MD070), and lead functional discussions.

● Map enterprise business processes within Oracle EBS to modern APEX user interfaces to

streamline daily operational workflows.

Skills:

5+ years of hands-on experience building APEX applications (v20.x–23.x+). Expertise in Dynamic Actions, APEX APIs, REST Data Sources, and Universal Theme modification.

In-depth understanding of Oracle EBS architecture, standard tables/views, open interfaces, concurrent managers, and custom schema extension (XX_ standards).

Advanced PL/SQL (Packages, Triggers, Views, Pipelines), SQL Performance Tuning, and ORDS (Oracle REST Data Services) configuration.

Hands-on experience with OAuth 2.0, REST APIs (JSON/XML parsing via APEX_JSON), JavaScript (jQuery/vanilla), CSS3, and HTML5.

Proven experience connecting Oracle DB/APEX to Google Workspace RESTful services.