APEX2EBS ‐ Installation - symbolthree/apex2ebs GitHub Wiki

Add TNS entries

• Edit C:\app\Administrator\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora and add another entry for PDB:

  FREEPDB1 =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = FREEPDB1)
      )
    )
  

• add another TNS entry for the EBS database. Make sure you can connect to the DB using user APPS.

Create database user APEX2EBS. This user will be used for the workspace schema.

• Using SYS to start SQL*Plus

sqlplus / as sysdba
alter session set container=FREEPDB1;
@1-SYSDBA-CREATE_USER.sql

Create tables, views, fuctions and packages

• Using APEX2EBS to start SQL*Plus

sqlplus APEX2EBS/APEX2EBS@FREEPDB1

@2-APEX2EBS.ddl
@3-A2E_LANG_MAPPING_DATA.sql
@4-4-A2E_FUNCTIONS.sql
@6-APEX2EBS_PKG.pks
@5-APEX2EBS_PKG.pkb
Warning: Package Body created with compilation errors.

• This error is expected since the database link is not created yet. It will be created on-the-fly using setup.

Create APEX2EBS workspace

• Log on to APEX using Workspace INTERNAL, user ADMIN.

• Create Create Workspace

  • Workspace name = APEX2EBS
  • (Leave other blank) -> (Next)
  • Re-use Existing schema = Yes
  • Schema Name = APEX2EBS -> (Next)
  • Administrator User APEXADMIN, password Temp1234, any valid Email -> (Next) -> (Create Workspace)

• Logout and Log on again, using Workspace APEX2EBS and user APEXADMIN. You will be asked to set a new password.

• App Builder -> Import.

• Drag and drop 7-APEX2EBS_CORE.sql -> keep all default options (Next) -> keep all default options (Next) -> (Install Application) -> (Run Application)

• Use TNS Entry = Yes, Network Alias = (EBS Database TNS Name), Schema password = (APPS password) -> (Create DB Link and Configuration) -> (Login Page)

• Use any EBS user which has System Administrator responsbililty. Select this responsibility.