EBS Object Types - Application Object Library (AOL)

A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.

1 Object Type Identification
2 File Extensions
3 Object Type
4 Object Type Attributes
5 Related Project Properties
6 Sample Build Commands
7 Sample Deploy Commands
8 Examples

Object Type Identification

Files with extensions .ldt, .ildt are included regardless of location
The file content is also analyzed by the populate process to determine the type

File Extensions

Name	Description

Name	Description
.ldt	Loader Data files containing entity definitions, parent-child relationships, input parameters and data.

Object Type

Name	Code

Name	Code
Application Object Library (AOL)	`AOL`

Object Type Attributes

Name	Code	Description	Default Value	Supported Values

Name	Code	Description	Default Value	Supported Values
Source	`SOURCE`	Object Source Location Type	SCM (populating from SCM) EBS (manual creation)	SCM \| EBS
App Short Name	`APP_SHORT_NAME`	Application Short Name	Project Property FDEBS_APPLICATION_SHORT_NAME is the default. If that is unset, the default is the root folder name from SCM
Type	`TYPE`	AOL Object Type	PROGRAM (derived when populating from SCM)	ALR_ALERTS \| AME_ACTION_USAGES \| AME_APPROVAL_GROUP_CONFIG \| AME_APPROVAL_GROUPS \| AME_ATTRIBUTE_USAGES \| AME_ATTRIBUTES \| AME_CALLING_APPS \| AME_CONDITIONS \| AME_RULES \| DESC_FLEX \| FND_ATTACHMENT_FUNCTIONS \| FND_CURRENCY \| FND_DOC_SEQUENCE_CATEGORIES \| FND_FOLDERS \| FND_FORM_CUSTOM_RULES \| FND_LANGUAGE \| FND_LOOKUP_TYPE \| FND_NEW_MESSAGES \| FND_PRINTER \| FND_RESPONSIBILITY \| FND_SEQUENCE \| FND_TABLE \| FND_TERRITORY \| FND_USER \| FND_VIEW \| FORM \| FUNCTION \| GRANT \| INTEGRATION_REPOSITORY \| JTF_GRID_DATASOURCES \| KEY_FLEX \| MENU \| MENU_ENTRY \| OTHER \| PRINTER \| PRINTER_STYLE \| PROFILE \| PROGRAM \| QUEUE \| REQ_SET \| REQ_SET_LINKS \| REQUEST_GROUP \| REQUEST_GROUP_ENTRY \| SCHEDULE \| VALUE_ROLLUP_GROUP \| VALUE_SECURITY_RULE \| VALUE_SET \| VALUE_SET_VALUE \| WF_ROLE \| XDO_DS_DEFINITIONS
Name	`NAME`	AOL Object Name	`<File Name> (**without path/extension)`
Target Location	`TARGET_LOCATION`	Path to where the file should be deployed to.	$<PROD_TOP>/patch/115/import/
Control File	`CONTROL_FILE`	Configuration file used to download/upload data.	$FND_TOP/patch/115/import/afcpprog.lct
NLS Language	`NLS_LANG`	Specifies the current language of the session.	AMERICAN_AMERICA.US7ASCII	Any valid language name using the OLAP DML syntax.
Upload Mode	`UPLOAD_MODE`	NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS.	REPLACE	REPLACE \| NLS
Custom Mode	`CUSTOM_MODE`	To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE.	FORCE	NONE \| FORCE
Additional Parameters	`ADDITIONAL_PARAMS`	Optional parameters to supply to the FNDLOAD command.
Target File Permissions	`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

Name	Code	Description	Default Value
AOL Root Destination Directory	`FDEBS_AOL_ROOT_DESTINATION_DIR`	Target directory for AOL objects.	$<PROD_TOP>/patch/115/import
File Permissions	`FDEBS_FILE_PERMISSIONS`	Target File Permission. Will be set to target file after deployment using chmod. eg: 755

Sample Build Commands

FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct "$SOURCE_FILE" PROGRAM APPLICATION_SHORT_NAME=XXHR CONCURRENT_PROGRAM_NAME=XXHRCP01

Sample Deploy Commands

cp $SOURCE_FILE $XXHR_TOP/patch/115/import/;
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct "$XXHR_TOP/patch/115/import/XXHR_Second_CP.ldt" - UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE ;

Examples

Request group name is actual name and not code. Unit Name is Code instead of Name. This is due to how FNDLOAD command works.