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 |
|
Object Type Attributes
Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
Source |
| Object Source Location Type | SCM | SCM |
Target Location |
| Path to where the file should be deployed to. | $<PROD_TOP>/ |
|
Force |
| Configuration file used to download/upload data. |
|
|
Java Classpath |
| Specifies the current language of the session. | $CLASSPATH | Any valid language name using the OLAP DML syntax. |
DB User Property |
| Property Name for Database Username | FDEBS_DB_USER (i.e. APPS) | Any FlexDeploy property containing the username |
DB User Password |
| 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 |
| 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 |
| Sub-directory within project's SCM source path which contains Java files. | loadjava |
Java Stored Procedure Root Destination Directory |
| Sub-directory within project's deploy path to contain Java files. | $JAVA_TOP |
OAF Java Classpath |
| Location of user-defined classes and packages. |
|
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
- style