Wednesday, August 6, 2014

FNDLOAD command to download/upload Oracle forms personalization

FNDLOAD command to download/upload form personalization






FNDLOAD commands to download form personalization-
FNDLOAD <login>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <file_name.ldt> FND_FORM_CUSTOM_RULES form_name=<form_name>

e.g.
FNDLOAD apps/pNUWdFy2 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCMST_MSCFNSCW.ldt FND_FORM_CUSTOM_RULES form_name=MSCFNSCW

FNDLOAD commands to upload form personlization-

FNDLOAD <login>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <file_name.ldt>
e.g.
FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCMST_MSCFNSCW.ldt


Below is the list of tables that are populated when any Forms Personalization is done:

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST

Path of PLL file:

/pacdcfinapp/cifadb/cifadbappl/au/11.5.0/resource

3 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
    Replies
    1. Stop posting your shit everywhere.

      Delete
    2. Hi Anonymous, Don't write nonsense here.

      Administrator: Please remove Anonymous comments.

      Thanks,

      Ramakrishnan

      Delete