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.

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
.ldt	Loader Data files containing entity definitions, parent-child relationships, input parameters and data.

Object Type

Name	Code
Application Object Library (AOL)	AOL

Object Type Attributes

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
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.