FNDLOAD the complete

What FNDLOAD can be done?
These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules


Some sample examples:

1.MENU:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct menu.ldt
MENU MENU_NAME=BOM_NAV

FUNCTION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
function.ldt FUNCTION FUNCTION_NAME=INV_INVTTMTX

FORM:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form.ldt
FORM FORM_NAME=${shortname}

PERSONALIZATION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
formpersonalization.ldt FND_FORM_CUSTOM_RULES function_name=${shortname}

Upload
FNDLOAD apps/apps  0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPO_PURCHASEORDER.ldt 


PRINTER:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct
printer.ldt STYLE PRINTER_STYLE_NAME=${shortname}

CONCURRENT:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
concprog.ldt PROGRAM CONCURRENT_PROGRAM_NAME=${shortname}

LOOKUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct
lookup.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE=${shortname}

RESPONSIBILITY:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afscursp.lct
responsible.ldt FND_RESPONSIBILITY RESP_KEY="${respkey}"

DESCFLEX:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
${shortname}_flex.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=${shortname}

KEYFLEX:
FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
keyflex.ldt KEY_FLEX
P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL: CVR_ALL:SEG_ALL'
APPLICATION_SHORT_NAME=${appshortname} ID_FLEX_CODE=MCAT
P_STRUCTURE_CODE=${shortname}

VALUE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
valset.ldt VALUE_SET FLEX_VALUE_SET_NAME=${shortname}

PROFILE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct
profile.ldt PROFILE PROFILE_NAME=${shortname}

MESSAGE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
message.ldt FND_NEW_MESSAGES MESSAGE_NAME=${shortname}

REQUEST GROUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
reqgrp.ldt REQUEST_GROUP REQUEST_GROUP_NAME=${shortname}

REQUEST SET:
OAUG Forum at COLLABORATE 08 Page 6
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct
rqstset.ldt REQ_SET APPLICATION_SHORT_NAME="FND"
REQUEST_SET_NAME=${shortname}

WEBADI:
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct
XX_C_O_F_T.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="XX_C_O_F_T"

Blob:
With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained

Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data

References:
Note: 274667.1 FNDLOAD Commands to Download Different Seed Data Types.
Note: 287417.1 Parameters Of Different Configuration Files To Download And Upload Seed Data Types.
Note: 256573.1 How To Download/Upload Descriptive Flexfield With Name $SRS$
EBS Release 11.5.10.2+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.0.4+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.1.3 : Oracle Applications System Administrator's Guide - Configuration
Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code, Brad Simmons and Donna Campbell,
Los Alamos National Laboratory document
Tips About FNDLOAD [ID 735338.1]
Is It Possible To Use FNDLOAD To Migrate Configurations Or Data To Another Instance? [ID 1316916.1]
How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1

Move the Concurrent Program ,data defination etc using FNDLOAD

1.Concurrent Program

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAP_UTILITY_PAYABLE.ldt PROGRAM APPLICATION_SHORT_NAME=XXARG CONCURRENT_PROGRAM_NAME=XXAP_UTILITY_PAYABLE

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAP_UTILITY_PAYABLE.ldt – CUSTOM_MODE=FORCE
==================================================================================
2.Template and data defination :

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXAP_UTILITY_PAYABLE_tmp.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXARG DATA_SOURCE_CODE=XXAP_UTILITY_PAYABLE


FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXAP_UTILITY_PAYABLE_tmp.ldt
=================================

Can not login to Applications : oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.

No user able to connect: 

oracle.apps.fnd.framework.OAException: Could not load application module

'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.

## Detail 0 ##

oracle.apps.fnd.framework.OAException: Application: FND, Message Name:

FND_NO_TRANSACTION_ID.

===========CAUSE =============

Due to tablespace one of the tablespace full 

=======SOLUTION =================

Increase the tablespace and retry ....

Ref: 737960.1
        

Purge Concurrent Request and/or Manager Data Running long after clone

cause
=======
When the purge program is run it will be executed from one of the concurrent processing nodes, it will try to delete the request log and output files. The complete paths to these files are stored in FND_CONCURRENT_REQUESTS table under columns LOGFILE_NAME and OUTFILE_NAME , the node where they are physically stored will be indicated in columns LOGFILE_NODE_NAME and OUTFILE_NODE_NAME.
The purge program will try to delete these log and output files from the node where it is running, it is mandatory that OS files can be accessed and deleted from the nodes where the concurrent managers are running.
The node retaining the out/log files doesn't exist anymore in the architecture, but the purge program uses this node name to delete the files from your system. If the program can not access these files it will have issues .


Need to check :

1.select count(*) from fnd_concurrent_requests

2.select LOGFILE_NODE_NAME, OUTFILE_NODE_NAME, count(*) from fnd_concurrent_requests
group by LOGFILE_NODE_NAME, OUTFILE_NODE_NAME

3.select node_name , SUPPORT_CP , SUPPORT_FORMS , SUPPORT_WEB,SUPPORT_ADMIN, STATUS
from fnd_nodes

4.select CONCURRENT_QUEUE_NAME , MAX_PROCESSES , RUNNING_PROCESSES ,
TARGET_NODE , NODE_NAME , NODE_NAME2 , ENABLED_FLAG , CONTROL_CODE
from FND_CONCURRENT_QUEUES
/

SELECT trigger_name , status FROM user_triggers WHERE table_name = 'FND_NODES' 

5- What is the result of the unix commands from the concurrent manager node :

uname -a
hostname
domainname

==============SOLUTION ================================

create table FND_RUN_REQUESTS_bk1 as select * from FND_RUN_REQUESTS  126
create table FND_CONCURRENT_REQUESTS_bk1 as select * from FND_CONCURRENT_REQUESTS   (rows =4964  )
create table FND_CONCURRENT_PROCESSES_bk1 as select * from FND_CONCURRENT_PROCESSES  (rows=1073 )


delete  FND_RUN_REQUESTS WHERE parent_request_id
in (select request_id from FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'OLDNODE' or upper(OUTFILE_NODE_NAME) = 'OLDNODE');


delete FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'OLDNODE' or
upper(OUTFILE_NODE_NAME) = 'OLDNODE';