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.

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.
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 

cp "$SOURCE_FILE" "$JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/";
javac -Xlint:none  -classpath $CLASSPATH "$JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.java";
loadjava -u $FDEBS_DB_USER/$FDEBS_DB_PASSWORD@"$AD_APPS_JDBC_URL" $JAVA_TOP/xxt/oracle/apps/ak/xxperson/schema/server/xxPersonDetailsEOImpl.class -force