Skip to main content

Oracle EBS R12 FNDLOAD Commands Example

By

 FNDLOAD Commands:


1) Concurrent Program Download:

FNDLOAD apps/<<AppsPassword>> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <<XX_LDT_FILE_NAME>>.ldt PROGRAM APPLICATION_SHORT_NAME="<<XXCUSTAPP>>" CONCURRENT_PROGRAM_NAME="<<CONC_PROG_SHORT_NAME>>"


2) Concurrent Program Upload:

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


3) Request SET Download

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <<XX_LDT_FILE_NAME>>.ldt REQ_SET REQUEST_SET_NAME='<<REQSET_INTERNAL_NAME>>'


3) Request Set Links Download:

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <<XX_LDT_FILE_NAME>>.ldt REQ_SET_LINKS REQUEST_SET_NAME='<<REQSET_INTERNAL_NAME>>'


4) Alert Download:

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct <<XX_LDT_FILE_NAME>>.ldt ALR_ALERTS APPLICATION_SHORT_NAME="<<XXCUSTAPP>>" ALERT_NAME="<<Alert Display Name>>"


5) Message Download

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct <<XX_LDT_FILE_NAME>>.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="<<XXCUSTAPP>>" MESSAGE_NAME="<<MESSAGE_NAME>>"


6) Concurrent Program Assignment to Request Group Download

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <<XX_LDT_FILE_NAME>>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="<<REQUEST_GROUP_NAME>>" APPLICATION_SHORT_NAME="<<REQ_GROUP_APPLICATION>>" UNIT_NAME="<<CONC_PROG_SHORT_NAME>>" 


7) Concurrent Program Assignment to Request Group Upload

FNDLOAD apps/<<AppsPassword>> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <<XX_LDT_FILE_NAME>>.ldt


8) Value Set Download

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <<XX_LDT_FILE_NAME>>.ldt VALUE_SET FLEX_VALUE_SET_NAME="<<VALUE_SET_NAME>>"


9) Value Set Upload

FNDLOAD apps/<<apps_password>> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct <<XX_LDT_FILE_NAME>>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 


10) DFF Download

FNDLOAD apps/<<AppsPassword>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <<XX_LDT_FILE_NAME>>.ldt DESC_FLEX APPLICATION_SHORT_NAME=<<APPLICATION_SHORT_NAME>> DESCRIPTIVE_FLEXFIELD_NAME='<<DFF_NAME_INTERNAL>>' 


11) DFF Upload

FNDLOAD apps/<<AppsPassword>> 0 Y UPLOAD $FND_TOP/patch/115/import/ afffload.lct  <<XX_LDT_FILE_NAME>>.ldt -WARNING=YES UPLOAD_MODE=REPLACE -CUSTOM_MODE=FORCE


12) System Profile Download
-- ---------
FNDLOAD apps/<<AppsPassword>>O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"

13) System Profile Upload

FNDLOAD apps/<<AppsPassword>>0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

14) Form Download

FNDLOAD apps/<<AppsPassword>> O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <file_name.ldt> FORM APPLICATION_SHORT_NAME=”CUST” FORM_NAME=”CUSTFRMNAME”

15) Form Upload
FNDLOAD apps/<apps_pass>0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <file_name.ldt>

16) Function Download
FNDLOAD apps/<apps_pass>O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <file_name.ldt>  FUNCTION FUNC_APP_SHORT_NAME=”CUST” FUNCTION_NAME=”CUSTFUNNAME”

17) Function Upload
FNDLOAD apps/<apps_pass>O Y UPLOAD $FND_TOP:patch/115/import/afsload.lct <file_name.ldt>

18) Menu Download
FNDLOAD apps/<apps_pass>O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <file_name.ldt>   MENU MENU_NAME=”CUSTMENUNAME”

19) Menu Upload 
FNDLOAD apps/<apps_pass>0 Y UPLOAD $FND_TOP/115/import/afsload.lct <file_name.ldt>

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Use of Who Columns in Oracle APPS table

By
Oracle APPS : WHO COLUMNS WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. Steps required to Track WHO Information in our form   1. ALTER the table by adding WHO columns in the table.   2. Open TEMPLATE.fmb in form Builder.   3. Perform all the pre‐requisites to develop a form.   4. Include all the WHO columns in the Data Block with NULL Canvas.   5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers       at Block Level.   6. Save and Compile the Form.   7. Perform all the pre‐requisites to register the form Note: 1. WHO Columns need not register with the table registration option.           2. Table registration will be done only for KFF and DFF col...
Post a Comment
Read more

Oracle APPS Create Responsibility and User in Oracle EBS

By
How to create Responsibility and User in Oracle EBS How to Create a Responsibility? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then Responsibility then Define Step 4: Enter the Data in the opened Window. Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table. How to Create a User? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then User then Define Step 4: Enter the Data in the opened Window. Note: Above Information of User is stored in FND_USER Table. User Responsibilities stored in FND_USER_RESP_GROUPS Table.
2 comments
Read more

Setup steps for Drop Shipments in Oracle EBS

By
  Oracle Order Entry and Oracle Purchasing integrate to provide drop shipments. Drop shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently have the items in inventory, or because it's more cost-effective for the supplier to ship the item to the customer directly SETUP A) Associate drop shipments with a receiving location. B) Drop shipments support a Destination Type of Expense or Inventory only. C) We can handle returns of drop shipments using standard Order Entry/Shipping or Purchasing functionality. There are different ways you may want to handle returns depending on whether the customer returned the item to you or directly to the supplier. We have to consider the following setup: 1- Inventory Setup  Inventory Setup : (Define and Maintain The Item) The drop ship inventory organization, item and subinventory must be setup prior to creating any drop ship orders. All drop ship ...
3 comments
Read more