Posts

Showing posts with the label forms

How to compile Oracle EBS Forms on Windows server?

Image
At first ensure that the forms you want to generate are not in use at the time you are generating them.  If they are in use when you generate the fmx files, the forms client session terminates. You can  follow this steps for compile operation. 1) Stop Oracle Forms Server. 2) Copy your new fmb file under the  $AU_TOP/forms/US path. 2) Change your directory to $AU_TOP/forms/US. 3) Use  ifcmp60 command to compile your fmd files and generate fmx files. Choose module_type parameter "FORM" . If you are compiling custom.pll, you must choose "LIBRARY" as a module_type parameter. Usage of userid parameter -->  userid=apps/**apps_password**@**instance_name** Example: Forms compile ifcmp60 module=APXVDMVD.fmb module_type=FORM userid=apps/apps@TEST custom.pll compile ifcmp60 module=custom.pll module_type=LIBRARY userid=apps/apps@DEV

How to get oracle EBS personalization lists?

Hi, If you need a personalization list for any module or screen in oracle EBS, you can use following scripts. List all the FORMS Personlizations select distinct a.form_name , a.enabled, c.USER_FORM_NAME, d.APPLICATION_NAME from FND_FORM_CUSTOM_RULES a,      FND_FORM b,      FND_FORM_TL c,      fnd_application_tl d where enabled = 'Y' and a.form_name = b.form_name and b.form_id = c.form_id and b.application_id = d.application_id order by application_name List all the OAF Personlizations SELECT PATH.PATH_DOCID PERZ_DOC_ID, jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_ID IS NULL) ORDER BY PERZ_DOC_PATH;