| want to add a field in oracle standard form [message #364740] |
Tue, 09 December 2008 21:39  |
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 field in oracle standard form [message #364774 is a reply to message #364740] |
Wed, 10 December 2008 00:37  |
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 |
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 |
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 #365236 is a reply to message #364740] |
Thu, 11 December 2008 03:15 |
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 #376301 is a reply to message #365256] |
Tue, 16 December 2008 20:35 |
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 |
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 |
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 #376464 is a reply to message #364740] |
Wed, 17 December 2008 07:41 |
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 |
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 #377975 is a reply to message #364740] |
Sat, 27 December 2008 04:35 |
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 |
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 #382622 is a reply to message #364740] |
Fri, 23 January 2009 04:23 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
