Forms :: FRM-40209 - Field Must Be Of Form XX-XX-XXX Coming Several Times

Oct 3, 2012

I have a form which has a Number field. I set it's Format Mask property to 9,99,99,99,99,999 so that I can format it comma separated and to restrict the user to enter decimal values. If the user enter any format other than this for example any decimal values, it is showing the message FRM-40209:Field must be of the form 9,99,99,99,99,999 which is fine. But when the user enters a decimal value and try to save the form it pop up this message several times.

I tried to catch this error in ON-ERROR trigger and display a message. But this is also pop up several times. I tried to raise form_trigger_failure also. This is also not working. I want this error message to come only once.

ADVERTISEMENT

Forms :: Focus Is Not Coming Onto The Form

Mar 31, 2010

The thing is i am generating a report in Excel through forms and excel template in 10g. After generating the Excel trough my code and Macros, i.e save excel, close excel and open excel.

After the excel report which got generated is opened the focus is not coming back to form, it keep on going busy and busy
I tried

form_exit,
go_block and also
Timer:DECLARE
timer_id Timer;
one_minute NUMBER(5) := 90000;
BEGIN
timer_id := CREATE_TIMER('Motor_Timer', one_minute, NO_REPEAT);
END;
etc and etc.

When i am using exit_form, the focus is coming back but the excel is not opening again.

View 2 Replies View Related

Number Field Coming As Blank But Length 1

Aug 12, 2013

column with datatype Number contains length 1.Its not null.Tried to trim then also length is 1 ....How to find what is the character there..?

View 1 Replies View Related

Forms :: EBS Form Text Field Enable

Jul 17, 2013

I am working on oracle ebs r12 and wants to enable text field (amount column in attachment) which is disable into form. How can i meet this requirement.

View 3 Replies View Related

Forms :: Adding 5 Mins To A Form Field In Library

Jun 24, 2013

I have a date field in my form (date.start_time) in which I want to reference in a library and add 5 mins to the time (since its in the lib I am coding this I need to use name_in ). My current code is:

copy(name_in('date.start_datetime')+5/24/60 , 'DATE.END_DATETIME')

However, this seems to be erroring.

View 2 Replies View Related

Forms :: Calling Form From Multi-record Field?

Apr 29, 2013

i have one multiple record field in frm....contain 5 field.....now i display the values...3 fields have values and two are empty...

the value of 1st field is A

2nd field is B

3rd field is C

i want if i click B it will open another form,

i want if i click c it will open another form,

View 9 Replies View Related

Forms :: FRM-40202 - Field Must Be Entered (after Standard Form Had Been Modified)

Apr 14, 2010

I got an error FRM-40202: Field must be entered. I did some modifications to Standard form by copying it. after that when I selected the first Email check box in the list and then selected the Email button which I created newly for that form.

View 1 Replies View Related

Forms :: Scroll Bar Coming In List Item

Dec 10, 2010

I have a list item with two values,0 and 1. However when i click on the list item scroll bar appears. My tester is saying for two items she doesn't need a scroll bar.

View 3 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

How To Use Trigger To Count A Field In A Form

May 16, 2007

I have a form that contains some data and I would like to count them in a new "Item text" ... I don't want to use the Item Text's property where we set the data type to number, database to No, Query all record to Yes and etc... I want to use the SQL statement code to count the records (using trigger)... I named the Item Text as Count_Records .

View 1 Replies View Related

SQL & PL/SQL :: Convert The Field Value Into Numeric Form?

Apr 27, 2010

I want to convert the field value into numeric form using the formula:

∑[((radix)^ position * alphvalue) mod PR]
where alphvalue A= 10, B = 11, C = 12, D = 13,E = 14............. S = 28, ...........Z = 35, radix = 36, PR= 731
The value of position is marked from right to left starting with 0.

For Example:
ASIN
Let PR = 731 (large prime number)

∑[((36)^3 * 10)mod 731) + ((36)^2 * 28)mod 731)+
((36)^1 * 18)mod 731) + ((36)^0 * 22)mod 731) ]
= 182+ 469 + 648 + 22
= 1321

is it possible that it pick the field value and convert it into numeric form.

View 34 Replies View Related

Application Express :: Numeric Field In Tabular Form

Mar 25, 2013

I am using APEX 4.1 and Oracle 10g XE.

I want to restrict 3 digits after decimal in tabular form. Only three or less than three digits should be allowed after decimal and should be stopped automatically.

e.g. 34.543

View 6 Replies View Related

Forms :: Update Field Based On Another Field Checkbox

May 3, 2013

I have a table where i need to update one field values based on another field of the same table , simply as it is.I have done this using one select all check box , on clicking that all check boxes of item_trans table will get selected , then i will un select some of check box and then using one button, i will update the value of the fields which are checked only.

I have put the sample code but when i am updating its taking long time and hanging.I am also attaching the form based on the test case provided.

--tables with insert statement
create table item_trans (trans_item varchar2(12),trans_qty number,trans_act_qty number)

insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE1',40,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE2',20,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE3',20,NULL);

--i want to set the value of trans_Act_qty as trans_qty

--i create one dummy or test block to keep the select all check box. for that table test script is

CREATE TABLE TEST
(
C VARCHAR2(2000 BYTE),
B NUMBER,
A NUMBER
);

insert into test (C,B,A) values ('A',1,1);

--code written in select all check box which is created on test.block.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
:M_END_YN := :M_END_ALL;
[code].......

--code written in M_END_YN ( actual check boxes where i will uncheck).

IF :M_END_YN = 'N' THEN
:M_END_ALL := 'N';
END IF;

--code written on button to update those values which are checked.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
IF :M_END_YN = 'Y' THEN
[code]......

View 5 Replies View Related

Created Registration Form With Input Field Of Email Address

May 30, 2011

i have created a registration form with an input field of email address. now i want if a new user register, it should automatically receive a confirmation mail.

i have done some coding but i am unable to define what to write on place of highlighted text.

public void sendConfEmail(){
try{
Properties props = null;
if (props == null) {
props = System.getProperties();
}
props.put("mail.smtp.host", "<server host name>");
Session session = Session.getInstance(props, null);
[code]..

View 4 Replies View Related

Application Express :: How To Create A Display Field In Tabular Form

Oct 1, 2012

I am stuck at point.

using apex 4.1, created tabular form for inserting values from customer with a simple query

table name : customer
select
USER_ID ,
USERNAME,
PASSWORD,
STATUS,
PRODUCT_ID
from CUSTOMER

I WANT TO FETCH THE NAME OF PRODUCT FROM ANOTHER TABLE NAME PRODUCT_NAME, I WANT THAT WITH TABULAR FORM COULMN OF PRODUCT NAME IS ALSO DISPLAYED, HOW I DID THAT ? JUST WANT TO ADD COLUMN FROM ANOTHER TABLE IN TABULAR FORM.

WHEN I ADD TABLE NAME IN FIRST QUERY IT IS NOT WORKING GIVING ERROR ABOUT NOT JOINING THE TABLE

View 2 Replies View Related

Application Express :: File Browse Field In Manual Tabular Form?

Oct 26, 2012

I am using Oracle APEX 4.0. I want to create a tabular form with one column as File Browse field.I've created form using APEX_ITEM and file browse item using pure HTML tags as we do not have any such item in APEX_ITEM. So these fields are appearing now but how do I save uploaded files in APEX_APPLICATION_FILES and then in my table?

View 3 Replies View Related

Application Express :: Dynamic Action For A Text Field In Tabular Form?

Sep 13, 2012

for a text field of a, wizzard generated, tabular form i created a dynamic action when lost focus. using a jquery selector to bind the da to the item in every row when the event fires some jscript and pl/sql code is executed. this all works like charm for existing rows.

but how can i bind the da to the field for newly added rows?a sc of the definition of the da can be found here [URL]...

View 2 Replies View Related

Application Express :: Change Form Text Field Label Using Javascript

Oct 22, 2013

I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA. 

View 3 Replies View Related

Application Express :: Number Mask Format With Tabular Form (Text Field)

Aug 24, 2012

By default number that "starts" with a leading zero with decimals - zero is removed. 0.49 => .49

I'm adding for e.g. the mask "FM990D0999". 0.49 => 0.49

Ok this is fixed.But if I have an integer without decimal. 1 => 1.0

If I change the mask to FM990D9999 1=> 1.

I would like to have a zero leading when it's 0.49 but also no decimal when it's an integer => 1

APEX 4.0 with 11g

View 2 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Forms :: 2 Different Form To Pass Values From One Form To Another

Mar 11, 2010

is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.

View 1 Replies View Related

Application Express :: Unable To Set Default Date Value For Tabular Form DB Date Field?

Dec 3, 2012

Version : 4.1.1, I have a tabular form on a DB table. One of the columns is a date field. When the user hits the "add Row" button on the tabular form, I want the Date field to be defaulted to sysdate. Here is what I have tried so far,

1. Created a "hidden" item P1_SYSDATE and populated the default value with sysdate. After this, under the DB tabular report date field, I used default type - Item/application on this page and entered P1_sYSDATE

2. Instead of populating the default value of the P1_SYSDATE hidden item, I created a before regions process and added

:P1_SYSDATE := sysdate

and added P1_SYSDATE to default type of the tabular date field with default type as "ITem/application on this page.

I get the error

ORA-01790: expression must have same datatype as corresponding expression

I tried to_Char(sysdate,'dd-mon-yyyy') and then converting it back to to_date. still no luck.

View 1 Replies View Related

Forms :: Any Way To Load A Form Within A Form

May 21, 2010

I have a requirement, is there any way i can achieve the following User Interface using oracle forms

Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.

The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.

View 2 Replies View Related

ADVERTISEMENT