[oracleerp] Re: FNDLOAD scripts
- From: <rakesh.chathli@xxxxxxxxxxxxx>
- To: <oracleerp@xxxxxxxxxxxxx>
- Date: Fri, 30 Nov 2007 15:28:46 +0530
Thanks Manu for sharing this.
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx
[mailto:oracleerp-bounce@xxxxxxxxxxxxx] On Behalf Of
manu.sharma@xxxxxxxxxxxxx
Sent: Friday, November 30, 2007 3:21 PM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: FNDLOAD scripts
Hi All,
Some more Oracle FNDLOAD Script Examples.........
--- Attachment Setup data/ Attachments
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afattach.lct XX_CUSTOM_ORACLE_ATTACMENT.ldt
FND_ATTACHMENT_FUNCTIONS APPLICATION_SHORT_NAME="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afattach.lct XX_CUSTOM_ORACLE_ATTACMENT.ldt
More options: afattach.lct - Attachment Setup data
FND_ATTACHMENT_FUNCTIONS
Sub-Entities
FND_ATTACHMENT_BLOCKS
FND_ATTACHMENT_BLOCK_ENTITIES
FND_DOC_CATEGORY_USAGES
Download Parameters
APPLICATION_SHORT_NAME
FUNCTION_NAME
FUNCTION_TYPE
FND_DOCUMENT_ENTITIES
Download Parameters
DATA_OBJECT_CODE
FND_DOCUMENT_CATEGORIES
Download Parameters
CATEGORY_NAME
FND_DOCUMENT_DATATYPES
--- FND dictionary (tables used by ALERT and Flexfields etc)
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afdict.lct XX_CUSTOM_ORACLE_TABLE.ldt
FND_TABLE APPLICATION_SHORT_NAME="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afdict.lct XX_CUSTOM_ORACLE_TABLE.ldt
More options: afdict.lct - AOL Data Dictionary
FND_TABLE
Sub-Entities
FND_COLUMN
FND_INDEX
FND_INDEX_COLUMN
FND_PRIMARY_KEY
FND_PRIMARY_KEY_COLUMN
FND_FOREIGN_KEY
FND_FOREIGN_KEY_COLUMN
Download Parameters
APPLICATION_SHORT_NAME
TABLE_NAME
FND_VIEW
Sub-Entities
FND_VIEW_COLUMN
Download Parameters
APPLICATION_SHORT_NAME
VIEW_NAME
FND_SEQUENCE
Download Parameters
APPLICATION_SHORT_NAME
SEQUENCE_NAME
--- Document sequences
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afsncat.lct XX_CUSTOM_ORACLE_SEQ.ldt
FND_DOC_SEQUENCE_CATEGORIES APP_SHORT_NAME ="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afsncat.lct XX_CUSTOM_ORACLE_SEQ.ldt
More options: afsncat.lct - Sequential Numbers
FND_DOC_SEQUENCE_CATEGORIES
Download Paraemeters
APP_SHORT_NAME
--- Multi-lang/currency/territory
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afnls.lct XX_CUSTOM_ORACLE_CURRENCY.ldt
FND_CURRENCY CURR_CODE ="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afnls.lct XX_CUSTOM_ORACLE_CURRENCY.ldt
More options: afnls.lct - Multi-lang/currency/territory
FND_CURRENCY
* NLS Upload only
Download Parameters
CURR_CODE
FND_LANGUAGE
* NLS Upload only
Download Parameters
LANG_CODE
FND_TERRITORY
* NLS Upload only
Download Parameters
TERR_CODE
--- Concurrent Program Schedules
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpsch.lct XX_CUSTOM_ORACLE_SCHEDULE.ldt
SCHEDULE APPLICATION_SHORT_NAME ="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afcpsch.lct XX_CUSTOM_ORACLE_SCHEDULE.ldt
More options: afcpsch.lct - Concurrent Program Schedules
SCHEDULE
* NLS Upload only
Download Parameters
RELEASE_CLASS_NAME
APPLICATION_SHORT_NAME
--- Concurrent Program Printers
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprnt.lct XX_CUSTOM_ORACLE_PRINTER.ldt
PRINTER PRINTER_NAME ="XX"
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afcpprnt.lct XX_CUSTOM_ORACLE_PRINTER.ldt
More options: afcpprnt.lct - Concurrent Program Printers
PRINTER
* NLS Upload only
Download Parameters
PRINTER_NAME
Regards,
Manu Sharma
Team Leader - ESG (Enterprise Solutions Group)
Birlasoft
H - 9, Sector - 63, Noida - 201306, India
Ph: +91 120 662 9000 (9302); Fax: +91 120 662 9484
IPLC: 4222; M: +91 98105 74529
manu.sharma@xxxxxxxxxxxxx
________________________________________________________
www.birlasoft.com
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx
[mailto:oracleerp-bounce@xxxxxxxxxxxxx] On Behalf Of
rakesh.chathli@xxxxxxxxxxxxx
Sent: Friday, November 30, 2007 1:01 PM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] FNDLOAD scripts
Hi Guys
www.oracle.anilpassi.com <http://www.oracle.anilpassi.com/> is an
excellent blog. It has loads of oracle apps specific information.
Yesterday I had submitted information about creating suppliers in R12.
Today I came across following scripts which you all might already have
or might need.
Regards
Rakesh
Oracle FNDLOAD Script Examples
PDF
<http://oracle.anilpassi.com/index2.php?option=com_content&do_pdf=1&id=1
9>
| Print |
<http://oracle.anilpassi.com/index2.php?option=com_content&task=view&id=
19&pop=1&page=0&Itemid=37>
E-mail
<http://oracle.anilpassi.com/index2.php?option=com_content&task=emailfor
m&id=19&itemid=37>
Written by Anil Passi
Sunday, 27 August 2006
In this article I wish to give real working examples of Oracle's FNDLOAD
utility.
Besides that, I have included some useful notes on FNDLOAD utility
I have used FNDLOAD successfully in past for several different
entities/data types within Oracle 11i for almost all my previous
clients, ever since this utility became available.
Some of the examples in this FNDLOAD article include:-
FNDLOAD to transfer Request Groups
FNDLOAD for moving Concurrent Programs
FNDLOAD to download and upload Forms Personalizations ( or
Personalisations depending on where you are located )
To FNDLOAD Web ADI, visit the link Web ADI FNDLOAD
<http://oracle.anilpassi.com/fndload-for-oracle-web-adi.html>
Use FNDLOAD for transferring value set definitions.
-->Please note that when transferring Key Flex Fields and Descriptive
flex fields the respective value sets against each segment will be
extracted and loaded automatically.
Also, FNDLOAD can be used to migrate Key FlexFields, Descriptive
Flexfields, Responsibilities and almost every other FND entity.
Please note that the text written down here could get wrapped in the
browser.
Hence you may have to use \ to continue the single line command on Unix,
in case you find the lines wrapping
In my case I am ensuring that $CLIENT_APPS_PWD has the apps password
before running the scripts
------------------------------------------------------------------------
------------------
##To FNDLOAD Request groups
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpreqg.lct XX_MY_REPORT_GROUP_NAME.ldt
REQUEST_GROUP REQUEST_GROUP_NAME="XX_MY_REPORT_GROUP_NAME"
APPLICATION_SHORT_NAME="XXGMS"
##Note that
##---------
## <> will be your Application Shortname where request group is
registered
## XX_MY_REPORT_GROUP_NAME
Will be the name of your request group
## ##To upload this Request Group in other environment after having
transferred the ldt file
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afcpreqg.lct
------------------------------------------------------------------------
------------------
##To FNDLOAD Concurrent Programs
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct
XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt PROGRAM
APPLICATION_SHORT_NAME="XXGMS"
CONCURRENT_PROGRAM_NAME="XX_CUSTOM_ORACLE_INTERFACE_PROG"
##Note that
##---------
## XXGMS will be your custom GMS Application Shortname where concurrent
program is registered
## XX_CUSTOM_ORACLE_INTERFACE_PROG
Will be the name of your request group
## XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt is the file where concurrent
program definition will be extracted
## ##To upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afcpprog.lct
XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt
------------------------------------------------------------------------
------------------
##To FNDLOAD Oracle Descriptive Flexfields
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt
DESC_FLEX APPLICATION_SHORT_NAME=PO
DESCRIPTIVE_FLEXFIELD_NAME='PO_REQUISITION_HEADERS'
##Note that
##---------
## PO is the Application Shortname against which descriptive flexfield
against PO Headers is registered
## PO_REQUISITION_HEADERS
is the name of Descriptive Flexfield against PO Requisition Headers
## Use the SQL below to find the name of DFF, rather than logging into
the screen (ooops via jinitiator)
########----->SELECT
########----->application_id, DESCRIPTIVE_FLEXFIELD_NAME,
application_table_name
########----->FROM
########-----> fnd_descriptive_flexs_vl
########----->WHERE
########-----> APPLICATION_TABLE_NAME like '%' || upper('&tab_name') ||
'%'
########----->ORDER BY APPLICATION_TABLE_NAME
########----->/
## To upload into another environment
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt
## OK another example for DFF against FND_LOOKUPS
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct XX_FND_COMMON_LOOKUPS_DFF.ldt
DESC_FLEX APPLICATION_SHORT_NAME=FND
DESCRIPTIVE_FLEXFIELD_NAME='FND_COMMON_LOOKUPS'
## OK another example for DFF against Project Accounting Expenditure
Types
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct
XX_PA_EXPENDITURE_TYPES_DESC_FLEX_DFF.ldt DESC_FLEX
APPLICATION_SHORT_NAME=PA
DESCRIPTIVE_FLEXFIELD_NAME='PA_EXPENDITURE_TYPES_DESC_FLEX'
------------------------------------------------------------------------
------------------
##To FNDLOAD Oracle Menus
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt MENU
MENU_NAME="ICX_POR_SSP_HOME"
##Note that
##---------
## Oracle Menus are not attached to applications. Hence no need to
include application short name
## ICX_POR_SSP_HOME is the menu name. This can be validated via below
SQL
## select user_menu_name from fnd_menus_vl where menu_name =
'ICX_POR_SSP_HOME' ;
## Also note that we do not pass in the User_menu_name in this example
## OK, now to upload this file
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt
------------------------------------------------------------------------
----------------------------------------------------
## Well, now for FND Messages to download a single message
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct \
XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt FND_NEW_MESSAGES
APPLICATION_SHORT_NAME='ICX' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP
## Or you may as well download all the messages within an application
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct \
XX_ALL_GMS_MESSAGES_00.ldt FND_NEW_MESSAGES
APPLICATION_SHORT_NAME='XXGMS'
## now to upload using FNDLOAD
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt
------------------------------------------------------------------------
----------------------------------------------------
## Now it's the turn of Lookup values. Again, its not a rocket science
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD aflvmlu.lct
XX_TRX_BATCH_STATUS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='XXGMS'
LOOKUP_TYPE="XX_TRX_BATCH_STATUS"
## Note that
## XX_TRX_BATCH_STATUS is the name of FND Lookup Type in this example
## This will download all the lookup codes within the defined lookup
## To upload
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD aflvmlu.lct
XX_TRX_BATCH_STATUS.ldt
------------------------------------------------------------------------
----------------------------------------------------
## You can also move the User definitions from FND_USER
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afscursp.lct ./XX_FND_USER_PASSI.ldt FND_USER
USER_NAME='ANILPASSI'
#Do not worry about your password being extracted, it will be encrypted
as below in ldt file
#BEGIN FND_USER "ANILPASSI"
# OWNER = "PASSIA"
# LAST_UPDATE_DATE = "2005/10/19"
# ENCRYPTED_USER_PASSWORD =
"ZGE45A8A9BE5CF4339596C625B99CAEDF136C34FEA244DC7A"
# SESSION_NUMBER = "0"
To upload the FND_USER using FNDLOAD command use
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/afscursp.lct ./XX_FND_USER_PASSI.ldt
Notes for using FNDLOAD against FND_USER:-
1. After uploading using FNDLOAD, user will be promoted to change their
password again during their next signon attempt.
2. All the responsibilities will be extracted by FNDLOAD alongwith User
Definition in FND_USER
3. In the Target Environment , make sure that you have done FNDLOAD for
new responsibilities prior to running FNDLOAD on users.
------------------------------------------------------------------------
----------------------------------------------------
## Now lets have a look at the profile option using oracle's FNDLOAD
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afscprof.lct POR_ENABLE_REQ_HEADER_CUST.ldt
PROFILE PROFILE_NAME="POR_ENABLE_REQ_HEADER_CUST"
APPLICATION_SHORT_NAME="ICX"
## Note that
## POR_ENABLE_REQ_HEADER_CUST is the short name of profile option
## We aren't passing the user profile option name in this case. Validate
using ...
########----->select application_id, PROFILE_OPTION_NAME || '==>' ||
profile_option_id || '==>' ||
########----->USER_PROFILE_OPTION_NAME
########----->from FND_PROFILE_OPTIONS_VL
########----->where PROFILE_OPTION_NAME like '%' ||
upper('&profile_option_name') || '%'
########----->order by PROFILE_OPTION_NAME
########----->/
## Now to upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afscprof.lct POR_ENABLE_REQ_HEADER_CUST.ldt
------------------------------------------------------------------------
----------------------------------------------------
## Now for the request sets that contain the stages and links for
underlying concurrent programs
## For this you will be firstly required to download the request set
definition.
## Next you will be required to download the Sets Linkage definition
## Well, lets be clear here, the above sequence is more important while
uploading
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET.ldt
REQ_SET REQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET_LINK.ldt
REQ_SET_LINKS REQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"
## Note that FNDRSSUB4610101 can be found by doing an examine on the
########----->select request_set_name from fnd_request_sets_vl
########----->where user_request_set_name = 'User visible name for the
request set here'
## Now for uploading the request set, execute the below commands
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET_LINK.ldt
------------------------------------------------------------------------
----------------------------------------------------
## Now for the responsibility
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$FND_TOP/patch/115/import/afscursp.lct XX_PERSON_RESPY.ldt
FND_RESPONSIBILITY RESP_KEY="XX_PERSON_RESPY"
## note that XX_PERSON_RESPY is the responsibility key
## Now to upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$FND_TOP/patch/115/import/afscursp.lct XX_PERSON_RESPY.ldt
------------------------------------------------------------------------
----------------------------------------------------
## OK, now for the forms personalizations
## For the forms personalizations, I have given three examples as below.
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt
FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt
FND_FORM_CUSTOM_RULES function_name="HZ_ARXCUDCI_STD"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt
FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"
## Note that the function name above is the function short name as seen
in the Function Definition Screen
## Now to upload the forms personalizations that are defined against
these forms functions....
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt
------------------------------------------------------------------------
----------------------------------------------------
Notes :
1. Give special attention when downloading Menus or Responsibilities.
In case your client has several developers modifying Responsibilities
and Menus, then be ultra carefull. Not being carefull will mean that
untested Forms and Functions will become available in your clients
Production environment besides your tested forms, functions and menus.
2. Be very careful when downloading flexfields that reference value sets
with independent values for GL Segment Codes.
By doing so, you will download and extract all the test data in GL Codes
that might not be applicable for production.
3. There are several variations possible for FNDLOAD, for example you
can restrict the download and uploads to specific segments within
Descriptive Flex Fields. Please amend the above examples as desired for
applying appropriate filterations.
4. The list of examples by no mean cover all possible FNDLOAD entities.
5. FNDLOAD is very reliable and stable, if used properly. This happens
to by one of my favourite Oracle utilities.
4. Last but not the least, please test your FNDLOAD properly, so as to
ensure that you do not get any unexpected data. In past I have noticed
undesired results when the Lookup gets modified manually directly on
production, and then the FNDLOAD is run for similar changes. If
possible, try to follow a good practice of modifying FNDLOADable data
only by FNDLOAD on production environment.
5. As the name suggests, FNDLOAD is useful for FND Related objects.
However in any implementation, you will be required to migrate the
Setups in Financials and Oracle HRMS from one environment to another.
For this you can use iSetup. "Oracle iSetup".
Some of the things that can be migrated using Oracle iSetup are
GL Set of Books, HR Organization Structures, HRMS Employees, Profile
Options Setup, Suppliers, Customers, Tax Codes
& Tax Rates, Financials Setup, Accounting Calendars, Chart of Accounts,
GL Currencies.
************************************************************************
******************************************************
"This message and any attachments are solely for the intended recipient
and may contain Birlasoft confidential or privileged information. If you
are not the intended recipient,any disclosure,copying, use, or
distribution of the information included in this message and any
attachments is
prohibited. If you have received this communication in error, please
notify us by reply e-mail(administrator@xxxxxxxxxxxxx) immediately and
permanently delete this message and any attachments. Thank you."
************************************************************************
************************************************************************
************************
************************************************************************
******************************************************
"This message and any attachments are solely for the intended recipient
and may contain Birlasoft confidential or privileged information. If you
are not the intended recipient,any disclosure,copying, use, or
distribution of the information included in this message and any
attachments is
prohibited. If you have received this communication in error, please
notify us by reply e-mail(administrator@xxxxxxxxxxxxx) immediately and
permanently delete this message and any attachments. Thank you."
************************************************************************
************************************************************************
************************
******************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may
contain Birlasoft confidential or privileged information. If you are not the
intended recipient,any disclosure,copying, use, or distribution of the
information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us
by reply e-mail(administrator@xxxxxxxxxxxxx) immediately and permanently delete
this message and any attachments. Thank you."
************************************************************************************************************************************************************************
Other related posts:
