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 User Name	FDEBS_DB_USER (i.e. APPS)	Any FlexDeploy property containing the user name
DB User Password	DB_PW_PROPERTY	Property Name for Database Password	FDEBS_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 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