Versions Compared

Old Version 1

changes.mady.by.user Karl Henselin

Saved on

compared with

New Version Current

changes.mady.by.user Ben Hoffman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Tip

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.

Tip

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
Code Block
languagebash
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

...