Oracle Method - Part 2 | Integrate Oracle E-Business Suite Release 12.2 With Oracle APEX

Oracle Method - Part 2

EBS Schema Preparation

Note

I didn't strictly follow the naming as suggested by Oracle. I really don't like the "underscore" in name.
In most of the EBS environment, a custom schema has already created for company-specific customization. This custom schema can be used for APEX, or as suggested by Oracle, create another one specific for APEX to use.

Create custom schema in EBS for APEX (if you don't want to reuse any existing one):


  CREATE USER XXAPEX IDENTIFIED BY XXAPEX DEFAULT TABLESPACE SYSAUX;
  
  GRANT CREATE CLUSTER TO XXAPEX;
  GRANT CREATE DIMENSION TO XXAPEX;
  GRANT CREATE INDEXTYPE TO XXAPEX;
  GRANT CREATE JOB TO XXAPEX;
  GRANT CREATE MATERIALIZED VIEW TO XXAPEX;
  GRANT CREATE OPERATOR TO XXAPEX;
  GRANT CREATE PROCEDURE TO XXAPEX;
  GRANT CREATE SESSION TO XXAPEX;
  GRANT CREATE SYNONYM TO XXAPEX;
  GRANT CREATE TABLE TO XXAPEX;
  GRANT CREATE TRIGGER TO XXAPEX;
  GRANT CREATE TYPE TO XXAPEX;
  GRANT CREATE VIEW TO XXAPEX;

In App server, source the RUN profile and run %AD_TOP%\patch\115\sql\ADAPEXSCHREG.sql <schema> to register this schema. You can run this script for existing custom schema that it simply creates extra grants for APEX use:

C:\oracle\VIS>EBSapps.cmd RUN

E-Business Suite Environment Information
----------------------------------------
RUN File System : C:\oracle\VIS\fs1\EBSapps\appl
PATCH File System : C:\oracle\VIS\fs2\EBSapps\appl
Non-Editioned File System : C:\oracle\VIS\fs_ne

DB Host: demo.symbolthree.com Service/SID: VIS

C:\oracle\VIS>cd %AD_TOP%\patch\115\sql

C:\oracle\VIS\fs1\EBSapps\appl\ad\12.0.0\patch\115\sql>sqlplus apps/<passwd> @ADAPEXSCHREG.sql XXAPEX

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jan 31 23:55:07 2026
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

The name of the schema to be registered must be passed as the first
parameter to this script. If not passed, you will be prompted for this
first required parameter.

Begin Registration of XXAPEX schema in EBS .....

Need to connect as EBS_SYSTEM user to perform the initial registration of the schema in EBS ...

Enter EBS_SYSTEM password: (EBS_SYSTEM password)
Connected.
Validating the existence of the schema XXAPEX in database ...
PL/SQL procedure successfully completed.

Schema XXAPEX must be enabled with editions in EBS Release 12.2 or later. Enabling the schema ...
User altered.
Need to connect to APPS user to complete the registration of the schema in EBS ...

Enter APPS username : apps
Enter APPS password: (apps password)
Connected.

Registering the schema XXAPEX in fnd_oracle_userid ...
PL/SQL procedure successfully completed.
Granting privilege to execute fnd_apex package code for Schema XXAPEX ...
Grant succeeded.
Registration of XXAPEX schema in EBS is completed successfully.
Commit complete.
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
C:\oracle\VIS\fs1\EBSapps\appl\ad\12.0.0\patch\115\sql>

This script grants this schema to use FND_APEX package, which have the authentication and authorization functions, in there they use the APEX_UTIL and APEX_CUSTOM_AUTH public packages from APEX installation.

| Table of Content | Next |

| Home | Repositories | Blog |

© 2026 by Christopher Ho. All Rights Reserved