FNDLOAD utility for Oracle Apps

-

FNDLOAD utility for Oracle Apps

FNDLOAD is a great Oracle utility to migrate data from one instance to another. It can be used with several different entities/data types within Oracle e-Business Suite. 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 Personalization
  • FNDLOAD for Data Definition
FNDLOAD can be used to migrate Key FlexFields, Descriptive Flexfields, Responsibilities and almost every other FND entity.

Usage of FNDLOAD utility:

FNDLOAD Request groups:

Download:
FNDLOAD apps/$apps_PWD O Y DOWNLOAD FND_TOP/patch/115/import/afcpreqg.lct
XX_REQ_GRP.ldt REQUEST_GROUP
REQUEST_GROUP_NAME="XX_REPORT_GROUP_SRT_NAME" APPLICATION_SHORT_NAME="XXGMS"

 Upload:
FNDLOAD apps/$apps_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct

FNDLOAD Concurrent Programs:

 Download:
FNDLOAD apps/$apps_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
XX_CONC_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXGMS"
CONCURRENT_PROGRAM_NAME="XX_CONC_PROG_SRT_NAME"

Upload:
FNDLOAD apps/$apps_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
XX_CONC_PROG.ldt

FNDLOAD Descriptive Flexfields:

 Download:
$FND_TOP/bin/FNDLOAD apps/$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'

Use the SQL below to find the name of DFF:
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

 Upload:
$FND_TOP/bin/FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct
XX_PO_REQ_HEADERS_DFF.ldt

Another example for DFF against FND_LOOKUPS:
FNDLOAD apps/$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'

DFF against Project Accounting Expenditure Types
FNDLOAD apps/$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'

FNDLOAD Oracle Menus:

 Download:
FNDLOAD apps/$apps_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
ICX_POR_SSP_HOME.ldt MENU MENU_NAME="ICX_POR_SSP_HOME"

Upload:
$FND_TOP/bin/FNDLOAD apps/$apps_PWD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt

FNDLOAD Request Sets:
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.

 Download Definition:
FNDLOAD apps/$apps_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct
XX_GL_REQ_SET.ldt REQ_SET REQUEST_SET_NAME="FNDRSSUB4610101"

Download set linkage:
FNDLOAD apps/$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"

select request_set_name
 from fnd_request_sets_vl
where user_request_set_name = 'User visible name for the request set here'

Upload:
FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct
XX_GL_MY_INTERFACE_SET.ldt

FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct
XX_GL_MY_INTERFACE_SET_LINK.ldt

FNDLOAD Responsibilities:

 Download:
FNDLOAD apps/$apps_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct
XX_RESPY.ldt FND_RESPONSIBILITY RESP_KEY="XX_PERSON_RESPY"

 Upload:
FNDLOAD apps/$apps_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct
XX_PERSON_RESPY.ldt

FNDLOAD Form Personalization:

Download:
FNDLOAD apps/$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/$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/$apps_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
XX_AP_APXVDMVD.ldt FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"

Upload:
FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt
FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct
XX_HZ_ARXCUDCI_STD.ldt
FNDLOAD apps/$apps_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt

FNDLOAD XDO Data Definition:

 Download:
FNDLOAD apps/$apps_PWD 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXBOM_MULTILVL_BOM_RPT_XDO.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXDJO" DATA_SOURCE_CODE="XXBOM_MULTILVL_BOM_RPT" TMPL_APP_SHORT_NAME="XXBOM" TEMPLATE_CODE="XXBOM_MULTILVL_BOM_RPT"

Upload:
FNDLOAD apps/$apps_PWD 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXBOM_MULTILVL_BOM_RPT_XDO.ldt

Some points of FNDLOAD utility:

 1. Attention for downloading Menus or Responsibilities. In case your client has several developers modifying Responsibilities and Menus, then be ultra careful. Not being careful 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. 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.
Location: India

Comments

Post a Comment

Popular posts from this blog

XML Publisher Request Fails Due to Output Post Processing Issue

-
OPP Log file: To obtain the OPP log file, follow the bellow steps: §   Select the System Administrator responsibility. §   Navigate to Concurrent à Manager à Administer. §   Select the Output Post Processor Service. §   Select the Processes button. §   Select Manager Log. Issues: BI Publisher concurrent request completed with warning due to a timeout caused by the Output Post Processor (OPP).  Given bellow the possible common errors may occur due to OPP issue: Issue 1. OPP No Response : +------------- 1) PUBLISH -------------+ The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status. Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. +--------------------------------------+ Issue 2.   OPP Process Timeout : +------------- 1) PUBLISH -------------+ The concurrent ma
Read more

Conditionally mandatory parameters of concurrent program

-
Image
Conditionally mandatory parameters of concurrent program Overview of  Conditionally mandatory parameters: Oracle Application does not support conditionally mandatory parameters . But sometime business requires conditionally mandatory parameters. So we need to achieve the same functionality using some workaround so that the program will be submitted with proper parameters. Requirement of  Conditionally mandatory parameters : We have customized report wherein there is a mandatory parameter 'Print of New' can have either of two values 1) Yes, 2) No at the time of submission of concurrent program.                          If user has selected 'Yes' as a parameter and has not entered any value in the parameter Transaction number low or Transaction number High then parameters for the printing original date Low and printing original date High should be made mandatory. In all other case parameters printing original date Low and printing original date
Read more

Oracle Database Connection to TOAD

-
Issues of Oracle Database Connection to TOAD Connections to Oracle database via TNS are bit of a painful until you get all the components in the TNS configured correctly. We generally get different types of errors when we try to connect the DB using TOAD.  Usually we get Host, Port & Service Name in the TNS Entry but SID is excluded from it. But if we supply the SID information instead of service name it gets connected easily. If we get the SID for the database we can easily connect to the DB using TOAD. Solution of Oracle Database Connection by TOAD: We can connect to any database instance using TOAD by the following steps: 1.        Connect to the database using SQL*Plus as below Ø   User Name:  ORACLE_USER Ø   Password: ORACLE_password1 Ø   Host String: 156.14.200.90:1542/VISSVC(host:port/Service Name) Ø   Or conn  ORACLE_USER / ORACLE_password1@156.14.200.90:1542/ORAVISSVC (Conn user/password@host:portNumber/ServiceName) 2.        Execute the following
Read more