Home » Applications » Oracle Fusion Apps & E-Business Suite » want to add a field in oracle standard form (Oracle Apps 11i)
want to add a field in oracle standard form [message #364740] Tue, 09 December 2008 21:39 Go to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi all,
i want to add a field by name UEN which i already created as dff in ar-->customers-->standard-->customers form.

now i want to display that field as text field or drop down list field in ar-->customers-->standard-->enter/find customers form.

so please help me how to customizethe oracle standard form.
this is an urgent issue for me. so please help me
im using oracle apps 11i
thanks in advance.

[EDITED by LF: fixed topic title typo (was "filed"). Added product information]

[Updated on: Wed, 10 December 2008 00:23] by Moderator

Report message to a moderator

Re: want to add a filed in oracle standard form [message #364763 is a reply to message #364740] Wed, 10 December 2008 00:14 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Please have a look

http://myoracleappsblog.blogspot.com/2008/01/enabling-dff-in-oracle-standard-forms.html
Re: want to add a filed in oracle standard form [message #364770 is a reply to message #364763] Wed, 10 December 2008 00:34 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
the link which u have given is for creating dff.
i had already done that.
now i want to create a text filed in ar-->customer-->standard-->find customer form to search the values from that field.

Re: want to add a field in oracle standard form [message #364774 is a reply to message #364740] Wed, 10 December 2008 00:37 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Great.

Then, you call this function in your WHEN-NEW-FORM-INSTANCE trigger

FND_DESCR_FLEX.DEFINE(
Block => 'Name of the block',
Field => 'Filed Name', --DFF Will be attach to this field.
Appl_short_name => 'Application Short Name', 
Desc_flex_name => 'DFF Name',
Title => 'DFF Title');
Re: want to add a field in oracle standard form [message #365078 is a reply to message #364774] Wed, 10 December 2008 21:36 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
ok.
i must write that in form builder right. when i copy the .fmb file from apps to my pc .
im trying to open the form but im getting error some other forms and pll file are not there .im not getting where to place that related files in my pc.im new to forms so please help me from step1 how to do form customization.
im attaching the screen shots where i want to display the file and in form form builder what error im getting.
Re: want to add a field in oracle standard form [message #365082 is a reply to message #364740] Wed, 10 December 2008 21:56 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

I you have rights to copy the resource folder from the Application server, copy the resource folder and paste it in your local folder. And in the registry go to Forms_path and add your resource folder path.

If you dont want to copy resource folder, then
whatever files are missing you have to copy those file and paste it in your Forms_Installed_Path/bin folder.

resource folder will be /$AU_TOP/

let me know if you face any issues.




[Updated on: Wed, 10 December 2008 21:57]

Report message to a moderator

Re: want to add a field in oracle standard form [message #365083 is a reply to message #365082] Wed, 10 December 2008 22:08 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
im new to forms .
i dont know where this form_60 will be there im using windows not linux so please guide me how to do this.
Re: want to add a field in oracle standard form [message #365087 is a reply to message #364740] Wed, 10 December 2008 22:56 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Go Run,

HKEY_LOCAL_MACHINE ->
SOFTWARE ->
ORACLE ->
DevSuiteHome1
See in the right panel,you will get forms_path

Please confirm me your application server also Windows???

Thanks
Re: want to add a field in oracle standard form [message #365106 is a reply to message #365087] Thu, 11 December 2008 00:27 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
yes
my application server also windows.
i attached the file with screen shots which i need to do exactly.
Re: want to add a field in oracle standard form [message #365236 is a reply to message #364740] Thu, 11 December 2008 03:15 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

1. Open the corresponding in Form.
2. Use the code in When-New-Form-Instance
which i have given already.
3. Now the DFF will be enable in the UEN Text Item.
4. You need to write some code in FIND Button as well.
5. Compile the Form.
6. Move the fmb to AU_TOP/forms/US
7. Move the fmx to XX_TOP/forms/US

XX_TOP - What actual top the fmx located.

Thanks
Mano


Re: want to add a field in oracle standard form [message #365246 is a reply to message #365236] Thu, 11 December 2008 04:03 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
when i open the form (.fmb) file in form builder im getting error that some of the .fmb files are not supporting.
i attching the screen shot.
actual the form name is ARXCUDCI.fmb
please help me how to resolve it.
Re: want to add a field in oracle standard form [message #365256 is a reply to message #364740] Thu, 11 December 2008 04:18 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Right click on Forms shortcut

In the start in just refer the resource folder name..
  • Attachment: SS.pdf
    (Size: 294.43KB, Downloaded 714 times)
Re: want to add a field in oracle standard form [message #376301 is a reply to message #365256] Tue, 16 December 2008 20:35 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
i dont have resource folder in d:/oracle/uatora/8.0.6/forms60
but i have resouce folder in d:/oracle/uatappl/au/11.5.0/resource
in this folder it consists of .pll and .plx files.

and i dont find any forms_path in registry.
i attached the screen shots and please help me how to solve this issue.

im using virtual machine for oracle apps and windows not unix

please help me to solve this issue because its an urgent issue for me.

if i copy this path d:/oracle/uatappl/au/11.5.0/resource in form builder then also im getting the same error some files are not loaded.

Re: want to add a field in oracle standard form [message #376311 is a reply to message #364740] Tue, 16 December 2008 21:58 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi
If it is not there, you can create.

Go to regedit and right and go to the same path where you find forms60_mapping forms60_oam_frd and forms60_output.

Go to edit menu->new->string value

Give the name FORMS_PATH

After that mention your resource path in FORMS_PATH

Re: want to add a field in oracle standard form [message #376325 is a reply to message #376311] Tue, 16 December 2008 23:59 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
i didnt find any forms_path in registry but when i opened
ar-->customers-->standard-->find/enter customers-->window-->aboutoracle applications i found all the details of that form.


Oracle Applications
Copyright (c) 2004 Oracle Corporation,
Redwood Shores, California.
All Rights Reserved.

----------------------------------------
Login
----------------------------------------
Site : BCA UAT (24-Aug-2007 Clone Of Production)
Application : Oracle Receivables
Responsibility : Receivables 1
Security Group : Standard
User Name : NIITSUPPORT

----------------------------------------
Database Server
----------------------------------------
RDBMS : 10.2.0.3.0
Oracle Applications : 11.5.10.2
Machine : B1FMSDBDEV
User : APPS
Oracle SID : uat
System Date : 17-DEC-2008 11:05:20
Database Server PID : 2664
Session SID : 426
SERIAL# : 22210
AUDSID : 6816100
Database CPU Usage (in secs) : 0.79


----------------------------------------
Forms Server
----------------------------------------
Oracle Forms Version : 6.0.8.25.2
Application Object Library : 11.5.0
Machine : B1FMSAPPDEV
Forms User CPU (secs) : 0.390625
Forms System CPU (secs) : 0.578125
Forms Process ID : 2880:3608

----------------------------------------
Forms Server Environment Variables
----------------------------------------
AU_TOP : d:\oracle\uatappl\au\11.5.0
FDBDMCHK : [Unset]
FDFGCXDBG : [Unset]
FDSQLCHK : [Unset]
FDUDEBUG : [Unset]
FNDNAM : APPS
FND_TOP : d:\oracle\uatappl\fnd\11.5.0
FORMS60_APPSLIBS : APPCORE FNDSQF APPDAYPK APPFLDR GLCORE HR_GEN HR_SPEC ARXCOVER
FORMS60_CATCHTERM : 1
FORMS60_ERROR_DATETIME_FORMAT : [Unset]
FORMS60_ERROR_DATE_FORMAT : [Unset]
FORMS60_FORCE_MENU_MNEMONICS : 0
FORMS60_MAPPING : http://b1fmsappdev.bca.gov.sg:8000/OA_TEMP
FORMS60_MMAP : [Unset]
FORMS60_OUTPUT : d:\oracle\uatcomn\temp
FORMS60_OUTPUT_DATETIME_FORMAT : [Unset]
FORMS60_OUTPUT_DATE_FORMAT : [Unset]
FORMS60_PATH : d:\oracle\uatappl\au\11.5.0\resource;d:\oracle\uatappl\au\11.5.0\plsql
FORMS60_RESOURCE : [Unset]
FORMS60_TIMEOUT : 5
FORMS60_USER_DATETIME_FORMAT : DD-MON-RRRR HH24:MI:SS
FORMS60_USER_DATE_FORMAT : DD-MON-RRRR
FORMS60_USE_CBO : [Unset]
GWYUID : APPLSYSPUB/PUB
NLS_DATE_FORMAT : DD-MON-RR
NLS_DATE_LANGUAGE : AMERICAN
NLS_LANG : AMERICAN_AMERICA.US7ASCII
NLS_NUMERIC_CHARACTERS : .,
ORACLE_HOME : d:\oracle\uatora\8.0.6
ORACLE_PATH : [Unset]
ORA_NLS_CHARSET_CONVERSION : [Unset]
TNS_ADMIN : d:\oracle\uatora\8.0.6\net80\admin\uat_b1fmsappdev
TWO_TASK : uat

----------------------------------------
Current Form
----------------------------------------
Form Application : Oracle Receivables
Form Name : ARXCUDCI
Form Path : d:\oracle\uatappl\ar\11.5.0\forms\US\ARXCUDCI.fmx
Form Version : 11.5.501
Form Last Modified : $Date: 2004/12/06 14:32 $

----------------------------------------
Forms
----------------------------------------
APPSTAND : 11.5.33
ARXCUDCI : 11.5.501
FNDSCSGN : 11.5.115

----------------------------------------
Form Menus
----------------------------------------
FNDMENU : 11.5.49

----------------------------------------
Forms PL/SQL
----------------------------------------
APPCORE : 11.5.142
APPFLDR : 11.5.54
ARXOPROF : 11.5.4
ARXPLCOM : 11.5.68
CUSTOM : 11.5.5.1150.1
FNDSQF : 11.5.111
GHR : 11.5.150
GLOBE : 11.5.44.115103.4
GMS : 11.5.230.90.7
IGILUTIL2 : 11.5.97
IGILUTIL : 11.5.29
OPM : 11.5.33.115100.2
PQH_GEN : 11.5.118
PSA : 11.5.162
PSAC : 11.5.16
PSB : 11.5.24
VERT : 11.5.6


here i found the form_path when i save tht path in form builder start in still im gertting the error some of files are not loaded

Re: want to add a field in oracle standard form [message #376327 is a reply to message #376325] Wed, 17 December 2008 00:05 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
i found forms60_path in registry .
i copied the ARXCUDCI.fmb to my desktop
i set the forms60_path in start in of forms builder .
again i opened the file in form builder still im getting the error some of the files are not loaded so what shall i do now.
please help me.
  • Attachment: Document.pdf
    (Size: 67.12KB, Downloaded 646 times)

[Updated on: Wed, 17 December 2008 00:10]

Report message to a moderator

Re: want to add a field in oracle standard form [message #376367 is a reply to message #376327] Wed, 17 December 2008 02:25 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
i created a field.
while i run the form i got runtime error. im sending the screen shots please help me how to solve.
Re: want to add a field in oracle standard form [message #376464 is a reply to message #364740] Wed, 17 December 2008 07:41 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Did you solved the missing files problem?

You cannot run the Oracle Apps Forms in the forms 6i enviornment. You have to register the form in oracle apps.

please do the follwoing steps.
1. Move your fmb file (binary mode) into /$AU_TOP/forms/US folder.
2. Move your fmx file into /$XX_TOP/forms/US
(Here XX_TOP nothing but your application if it is HRMS
$PER_TOP like that)
3. Go to Oracle Apps
4. In the application developer responsiblity->form->give your exact form name.
5. Then, go to form function and create function and in the form tab select your form.
6. Attach this form function to any menu (you can find in system administrator -> security->responsibilities)
7. You can execute the form from that menu.

Let me know if you getting any error.

Re: want to add a field in oracle standard form [message #377841 is a reply to message #376464] Thu, 25 December 2008 21:14 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
I had created a field in ar-->customers-->standard-->find/enter customers in advanced tab

but when i click on find button im getting error as "invalid identifier"

please help me how to rectify that.i was stucked here.
do i need to do any changes in custom.pll
if yes please guide me.
i had attached the pdf file please see that and guide me

thanks in advance
radha
Re: want to add a field in oracle standard form [message #377866 is a reply to message #376464] Fri, 26 December 2008 00:04 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
ya i solved the missing files problem i created a field when i open orace apps and search through the field (uen) which i created im getting error.
please see the attched file. and solve my issue.

do i need to do any changes in custom.pll
Re: want to add a field in oracle standard form [message #377975 is a reply to message #364740] Sat, 27 December 2008 04:35 Go to previous messageGo to next message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
Hai you need to create dff or add one column to that form,
if you requirement is add a column to exiting dff then go to application developer responsibility -->flexfield-->Descriptive-->Segment-->Segments In this Segment you need to give you column name and enable the field and compile and save default it will effect on base form, if you are working from back let me , I am waiting for your replay
Re: want to add a field in oracle standard form [message #378155 is a reply to message #377975] Mon, 29 December 2008 03:06 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
i created a dff by name uen in ar-->customers-->standard-->customer-standard form
but now i want to create a field in ar-->customers-->standard-->find/enter customers-->advanced tab to search by the uen(dff) which i hav created.

so please help me how to do this.
Re: want to add a field in oracle standard form [message #378227 is a reply to message #364740] Mon, 29 December 2008 06:27 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Search in google fnd_descr_flex.define
Re: want to add a field in oracle standard form [message #378248 is a reply to message #378155] Mon, 29 December 2008 08:13 Go to previous messageGo to next message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
please send me scrrenshot for you requirement i couldn't under stand
Re: want to add a field in oracle standard form [message #378298 is a reply to message #378248] Mon, 29 December 2008 20:42 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
please see the attached file.
Re: want to add a field in oracle standard form [message #378299 is a reply to message #378248] Mon, 29 December 2008 20:44 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
please see the attached file.
Re: want to add a field in oracle standard form [message #378300 is a reply to message #378248] Mon, 29 December 2008 20:45 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
please see the attached file.
Re: want to add a field in oracle standard form [message #378302 is a reply to message #378248] Mon, 29 December 2008 20:48 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
hi,
please see the attached file.
this is the form

[Updated on: Mon, 29 December 2008 20:51]

Report message to a moderator

Re: want to add a field in oracle standard form [message #382175 is a reply to message #364740] Wed, 21 January 2009 04:24 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Did your problem got solved?
If No, then tell me, I will help you from the basic step....
Re: want to add a field in oracle standard form [message #382535 is a reply to message #382175] Thu, 22 January 2009 19:37 Go to previous messageGo to next message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
my problem was not solved please help me from basic step.
Re: want to add a field in oracle standard form [message #382622 is a reply to message #364740] Fri, 23 January 2009 04:23 Go to previous message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
First ask your team leaders, whether it will be OK if you change standard fmb?

If YES then open ARXCUDCI.FMB in form builder. open ORG_PER_DETAIL_SEARCH canvas and add a required text field there. I think that text field should be of property database Item = NO

1. Move customers form fmb file (binary mode) from /$AU_TOP/forms/US folder to your machine.
2. Customize the form as per your requirement.
3. take the backup of customers form in AU_TOP. put fmb which u customized in au_top and compile it with f60gen
2. Move your fmx file into /$AR_TOP/forms/US . take the backup of fmx first
Previous Topic: customer account number was changed
Next Topic: Order Management - Functional (Discounting)
Goto Forum:
  


Current Time: Thu Dec 08 00:35:39 CST 2016

Total time taken to generate the page: 0.16445 seconds