EBS Object Types - Java Stored Procedures

collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.

Object Type Identification

  • Files with the extension .java are included if they are in the loadjava folder

EBS Load Java Root Source Directory on Project Properties tab defaults to loadjava, but you can update if you are keeping Java Stored Procedures in different folder.

File Extensions 

.javaJava programming language source files.
.classCompiled java files.
.jarJava archive files.
.zipCompressed java files.

Object Type

Java Stored ProceduresJAVA_SP

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type


Target LocationTARGET_LOCATIONPath to where the file should be deployed to.$<PROD_TOP>/
ForceFORCEConfiguration file used to download/upload data.TRUE
Java ClasspathCLASSPATHSpecifies the current language of the session.$CLASSPATHAny valid language name using the OLAP DML syntax.
DB User PropertyDB_USER_PROPERTYProperty Name for Database User NameFDEBS_DB_USER  (i.e. APPS)Any FlexDeploy property containing the user name
DB User PasswordDB_PW_PROPERTYProperty Name for Database PasswordFDEBS_DB_PASSWORD

Any FlexDeploy property containing the user name.

Be sure to mark any custom properties as encrypted such that the password does not appear in clear text on the screen or in the execution logs.

Target File PermissionFILE_PERMISSIONSPermissions to apply to the file after it is deployedDefaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

NameCodeDescriptionDefault Value
Java Stored Procedure Root Source Directory
FDEBS_LOAD_JAVA_ROOT_SOURCE_DIRSub-directory within project's SCM source path which contains Java files.loadjava
Java Stored Procedure Root Destination DirectoryFDEBS_LOAD_JAVA_ROOT_DESTINATION_DIRSub-directory within project's deploy path to contain Java files.$JAVA_TOP
OAF Java ClasspathFDEBS_JAVA_CLASSPATHLocation of user-defined classes and packages.
File PermissionsFILE_PERMISSIONSPermissions to apply to the file after it is deployed

Sample Build Commands 

N/A - Build commands not supported for this type.

Sample Deploy Commands 

Java file
cp "$SOURCE_FILE" "$JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/";
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@"$AD_APPS_JDBC_URL" $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.class -force -v -r -t 
Class file
cp "$SOURCE_FILE" "$JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/";
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@"$AD_APPS_JDBC_URL" $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.class -force -v -r -t 

Jar File
cp "$SOURCE_FILE" "$JAVA_TOP/loadjava/";
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@"$AD_APPS_JDBC_URL" $JAVA_TOP/loadjava/Dependency.jar -force -v -r -t 
Zip File
cp "$SOURCE_FILE" "$JAVA_TOP/loadjava/";
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@"$AD_APPS_JDBC_URL" $JAVA_TOP/loadjava/Dependency.zip -force -v -r -t 
The following macros are not currently supported in the footer:
  • style