EBS Deployment Objects

EBS Deployment Objects: EBS Deployment Components Are Mainly come under below Categories.

A developer works on a Business requirement and the outcome will be typically comprising of any of the below components.

Component	Description/Comments
RDF Reports	Oracle Report files , Generally Consists of .rdf files , .rtf,.xml files
Host Programs	.sh files- which need to be moved to Unix Top and Execute the commands to Establish the softlink
PL/SQL	DB Components need to be compiled in the data base adhering to the dependencies
OAF	Oracle Application Framework – Generally Consists of java and xml files- Java file to be compiled and xml files to be Imported to DB
AOL Objects	Application Object Library consists of below items and gets deployed via the FNDLOAD commands 1.       Concurrent Programs 2.       Value Sets 3.       Lookups 4.       DFF’s 5.       Profile Options 6.       FND Messages 7.       Alerts 8.       Menu 9.       Form Functions
Oracle Forms	Oracle Forms , Consists of .FMB files and gets compiled using a FNDLOAD commend and generates .fmx files
Workflow	Oracle Workflow , a .wft file Need to get uploaded using WFLOAD commands

1.       Deployment of oracle Reports/XML Pub Reports

Deployable components:

Object	Description	Steps for manual Deployment
RDF files	Report Definition Files	Copy the file to a Unix Directory
RTF Files	Report Template Files	Use a XDO Import command to upload- See below
DB Files	Data Base Objects	Compile in DB
LDT Files	AOL Objects definition files	Use FNDLOAD command to upload
ADhoc Scripts	PLSQL/Unix	Depending on the scenario , at time need to execute some ad hoc plsql scripts or unix  Scripts

Typically, a developer will generate the ldt files from Dev instance and load the same to code repo along with other files. Please see the below commands to upload/Download the same.

 Concurrent Program-- -----------------------------FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 Data Definition and Associated Template--- ----------------------------------------------------------FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CODE'

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt

 DATA_TEMPLATE (Data Source .xml file)--- ----------------------------------------------------------java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

 RTF TEMPLATE (Report Layout .rtf file)--- -------------------------------------------------------java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

2.       Pl/sql adhoc Script to Attach the Concurrent Program to a Responsibility.

Developer have to provide the below Input Parameters to execute this Script.

DECLARE

  l_program_short_name  VARCHAR2 (200);

  l_program_application VARCHAR2 (200);

  l_request_group       VARCHAR2 (200);

  l_group_application   VARCHAR2 (200);

  l_check               VARCHAR2 (2);

  --

BEGIN

  --

  l_program_short_name  := 'XX_ORACLEAPPS_CP';

  l_program_application := 'CUSTOM Custom';

  l_request_group       := 'System Administrator Reports';

  l_group_application   := 'Application Object Library';

  --

  --Calling API to assign concurrent program to a reqest group

  --

   apps.fnd_program.add_to_group (program_short_name  => l_program_short_name,

                                  program_application => l_program_application,

                                  request_group       => l_request_group,

                                  group_application   => l_group_application                           

                                 ); 

  --

  COMMIT;