EBS Object Types - Java Stored Procedures

A 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

Name	Description
.java	Java programming language source files.
.class	Compiled java files.
.jar	Java archive files.
.zip	Compressed java files.

Object Type

Name	Code
Java Stored Procedures	`JAVA_SP`

Object Type Attributes

Name	Code	Description	Default Value	Supported Values
Source	`SOURCE`	Object Source Location Type	SCM	SCM
Target Location	`TARGET_LOCATION`	Path to where the file should be deployed to.	$<PROD_TOP>/
Force	`FORCE`	Configuration file used to download/upload data.	`TRUE`
Java Classpath	`CLASSPATH`	Specifies the current language of the session.	$CLASSPATH	Any valid language name using the OLAP DML syntax.
DB User Property	`DB_USER_PROPERTY`	Property Name for Database Username	FDEBS_DB_USER (i.e. APPS)	Any FlexDeploy property containing the username
DB User Password	`DB_PW_PROPERTY`	Property Name for Database Password	FDEBS_DB_PASSWORD	Any FlexDeploy property containing the username. 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 Permission	`FILE_PERMISSIONS`	Permissions to apply to the file after it is deployed	Defaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

Name	Code	Description	Default Value
Java Stored Procedure Root Source Directory	`FDEBS_LOAD_JAVA_ROOT_SOURCE_DIR`	Sub-directory within project's SCM source path which contains Java files.	loadjava
Java Stored Procedure Root Destination Directory	`FDEBS_LOAD_JAVA_ROOT_DESTINATION_DIR`	Sub-directory within project's deploy path to contain Java files.	$JAVA_TOP
OAF Java Classpath	`FDEBS_JAVA_CLASSPATH`	Location of user-defined classes and packages.
File Permissions	`FILE_PERMISSIONS`	Permissions 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