Forms :: Entering Multiple Data In A Form Containing 4 Blocks

Jul 18, 2011

I have 4 blocks in my form which is basically used for travel booking for the employees in a company within India

1) Header block :- contains info abt the person who is booking the tickets for number of employees. Here i have given booking no a primary key.

2) Employee Detail :- Here the basic info of an employee is entered. Here i have taken booking number as a foreign key and then given emp_cd & booking number as a composite primary key.

3) Travel Detail :- Here the travel detail of individual employee will be entered wherein a unique trv_no will b generated 4 every single travel. Again i have taken foreign key as bkng_no frm 1st blck and emp_cd frm 2nd blck and tkn a composite primary key which comprises of bk_no,emp_cd and trv_no. this is used to maintain the uniqueness for single travel.

4) Vehicle Hotel Details :- This block is placed on different canvas for same form.It is meant for Other details in which details regarding hotel,vehicle etc booking aftr reaching the destination is entered. In this block thrs no primary key, but i hv taken the composite primary key of 3rd block as a foreign key since thr will be multiple entries for this one entire travel.

At every level there will be multiple entries for each corresponding entered record. I am able to enter one single record properly i.e. for 1 emp i am able to enter multiple travel details and his other requirements but asi try to enter more then one employee info, his travel details, other requirements i face an error stating foreign key constraint violated.Parent key not found for 3 rd level block.

How can i get the desired o/p wherein all the multiple records for every single subsequent record are stored correctly taking all the constraints in to consideration.

View 8 Replies


ADVERTISEMENT

Forms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message

Jan 15, 2013

I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".

I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.

View 2 Replies View Related

Forms :: Looping Multiple Records In Blocks

Jul 31, 2012

I have two blocks, both are multi record block. 1st block is control block and second is database block. Both the blocks have same fields(Example: Location,Location_name,Location_Type). In the first block(Control Block) I have check box. My goal is when I check the checkbox and click on add button all the records which are selected in first block should go to second block.

View 3 Replies View Related

Forms :: Entering Data In List Of Value

Apr 3, 2011

I have created a list of value , If I do not slect any of the values then I would like to enter data in that column .

how I can do this .

View 2 Replies View Related

Forms :: Export Two Data Blocks To Excel

Feb 19, 2011

We are having two data blocks as Earnings and Deductions. We need to export this to an excel in single sheet parallel [ imagine your payslip format ].

if we use normal text_io we are not able to get the result we want. so we have tried using a package called export2excel. we achieved what we want. The form is working perfectly in client server concept. When we move the same form to our Unix application server, it is not working.

View 1 Replies View Related

Forms :: Unable To Fetch Data Using Control-blocks

Dec 24, 2010

I have created two non base table text items(from date, to date) and if values are not entered from front end i.e. null then hadrcoded in pre_query trigger to default values.But even i enter values dynamically from front end and when ever i press fetch button ,it is taking default values i.e. it is not accepting values what i have entered.

View 6 Replies View Related

File Size (7680000 Blocks) Exceeds Maximum Of 4194303 Blocks

Sep 9, 2012

While increasing the tablespace i am getting below error. How to handle this

SQL> set lin 300
SQL> col TABLESPACE_NAME for a25
SQL> col FILE_NAME for a65
SQL> select TABLESPACE_NAME,FILE_ID,FILE_NAME,AUTOEXTENSIBLE,sum(BYTES/1024/1024) MB
2 from dba_data_files where TABLESPACE_NAME='SYSAUX' group by TABLESPACE_NAME,FILE_ID,FILE_NAME,AUTOEXTENSIBLE order by sum(BYTES/1024/1024) DESC,file_name;

TABLESPACE_NAME FILE_ID FILE_NAME AUT MB
------------------------- ---------- ----------------------------------------------------------------- --- ----------
SYSAUX 3 /ora2/oradata/dbname/sysaux_01.dbf NO 300

SQL> Alter database datafile 3 RESIZE 60000M;
Alter database datafile 3 RESIZE 60000M
*
ERROR at line 1: ORA-01144: File size (7680000 blocks) exceeds maximum of 4194303 block

View 3 Replies View Related

How To Take Data When Entering Range Of Dates

Oct 8, 2009

how can i write query to take data from DB, if im entering range of dates :

for example between 20-aug-2009 and 1-aug-2009.

But query must be like, if i enter 21-aug-2009 and second date should the start of the month.

for example if i enter second date like 2-jul-2009, first date should start form begining of that month?

View 1 Replies View Related

Forms :: Inserting Multiple Records In Table Through Tabular Form

Apr 1, 2012

i have a master-detail form.

detail block is tabular.

when-button-pressed trigger iam inserting records in another table.i write

insert into ONHAND_QTY_LOCATION(sno,matid,matcode,description,partno,onhand_qty,location)
values (:ship_dtl.slno,
:ship_dtl.mat_id,
:ship_dtl.mat_code,
:ship_dtl.description,
:ship_dtl.part_no,
:ship_dtl.rec_qty,
:ship_mstr.place_from)

it is inserting only one record in onhand_qty_location table that too the last record.

i want all the records which iam entering in detail block should get entered in onhand_qty_location table.

View 8 Replies View Related

Forms :: Master Detail Form Storing Multiple Records

Aug 13, 2013

I am new to the Oracle Forms.

I need a Master Detail oracle form for Oracle EBS.

The form should use only one table.

I need the form should look like User Form in EBS.

I created 2 data blocks and designed. When I run the form and key in some data, I notice multiple records stored.

like

Empno Ename Sal Comm
101 null null null
null John 2300 500

Empno is in Master Block.

And remaining are in Detail block. How to remove the duplicate records so that my required output should be like

Empno Ename Sal Comm
101 John 2300 500

View 5 Replies View Related

Forms :: Default Mode While Entering?

May 25, 2010

Is there any property that can be set at design time or dynamically altered during runtime about the default mode in which a form opens? I have created a new FORM in Forms 6i and it opens in the Enter-Query mode. I do not want to open it in the Enter-Query mode. This is because I will be doing my own execute_query on some click of a button in the form. How do I alter this Enter-Query mode in which the form opens?

View 2 Replies View Related

Forms :: Not Entering Into A Block (non-database)?

Jun 1, 2012

I am using a block the problem is I am unable to fetch the data into the block when I have entered the execute_query even tried with the pre-block trigger but not getting the message which is in pre-block how to over come with this..struggling since two days but unable to resolve it

View 2 Replies View Related

Forms :: First Form Clear Previous Data And Then Populate Data From Table

May 7, 2012

when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below

go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........

View 26 Replies View Related

Fast Way To Retrieve All Data Blocks

Apr 19, 2012

I am interested about the fast way to access all data in physical block. what is the quick way to bring data blocks using the rowid, I found this script but soon as I can have faster access:

select * from table_name t
WHERE ROWID between 'AAAUaOAAEAAHkJiAAA' and 'AAAUaOAAEAAHkJiAA8';
where 'AAAUaOAAEAAHkJiAAA' is the last element in the block and 'AAAUaOAAEAAHkJiAA8' is the first one

my question is can retrieve all the data in one block more quick than this query.

View 5 Replies View Related

Server Administration :: Contention On Data Blocks?

Oct 22, 2010

We are suffering from very bad application response for last few days, when i try to check and drill down, where the actual contention is? I came to know that there may be contention on data blocks, which may be a prime reason for degraded performance. Herewith i'm pasting my actual stats of gathered from v$waitstat. I gone through some of asktom docs and find that there may be a problem with freelist or segment space management. My data tablespace is segment space management = Manual.

My main question is

1) Should i need to increase freelist value (Right now my value is 1)

2) Or i have to move on segment space management = auto

SQL> select * from v$waitstat;

CLASS COUNT TIME
------------------ ---------- ----------
data block 2022 4052
sort block 0 0
save undo block 0 0
segment header 1 1
save undo header 0 0
free list 0 0
extent map 0 0
1st level bmb 0 0
2nd level bmb 0 0
3rd level bmb 0 0
bitmap block 0 0
bitmap index block 0 0
file header block 0 0
unused 0 0
system undo header 0 0
system undo block 0 0
undo header 6 0
undo block 0 0
18 rows selected.

View 1 Replies View Related

Server Administration :: Continuously Changing Data Blocks?

Jan 10, 2011

If the data blocks in the buffer continuously get updated such that they never reach the Least used list of LRU,then when will they be written to disk?

View 19 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

Forms :: Database Blocks - Saving Record

Oct 2, 2010

i am using form6i & oracle 8i.

i have master -detail form. both are database blocks.

i have inserted values for the master block bt not for the detail record my problem is.. "user should not be allowed" to move to next record of the master block before saving the current record

View 10 Replies View Related

Forms :: Two Blocks - Unable To INSERT Record

Oct 16, 2012

I have this error. To put it simply I have two blocks.

Block1 contains two drop down list with PL/SQL statements for queries.
Block2 contains tabular form created from block wizard (I tried already in manual)

that will catch the result in Block1 queries.

Now I have a button with a trigger when-button-pressed that contains

BEGIN
INSERT INTO dummy1
VALUES ('hello',1,2,3);
COMMIT;
END;

My goal is to add into dummy1 values from :block2.item_name1, :block2.item_name2, :block2.item_name3 but to put it simply I tried these values but I received the same error.

When I run it and first things first click the button, the values will be added into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error.

View 10 Replies View Related

Forms :: How To Insert Values Through Blocks Using Button (save)

Dec 15, 2010

I HAVE 2 BLOCKS E.G. MASTER-DETAIL AND i have created it manually then how to insert values thrugh these blocks using a button called "save" using "commit_form;" suppose form fields are

master-block:
emp_id
emp name
age
detail block:
address
city
where emp_id is primary key as well foreign key in detail table

how these values will be inserted in both tables

View 1 Replies View Related

Forms :: FRM-40202 - Field Must Be Entered On Two Blocks With Same Table?

Sep 30, 2010

I have two blocks, blockA and blockB, both from the same table which is tableX.

When I query from blockA and it has returned results, then I go to blockB and edit some data and save, there was no problem. But when I don't execute query from blockA or if the query returned zero results, then I go to blockB and edit some data then save, I got this error. THe cursor then go to blockA first item. So now I have to delete that empty row before saving.

View 6 Replies View Related

Forms :: Master Child Relation For Non Control Blocks

Jul 8, 2011

I am working on form builder 6i. I have a header block A(Multi record block), child block B. Both are non control blocks. My requirement is, if i put the cursor in any header record, i want to auto populate corresponding child record like in master child relation.

which trigger i need to write logic to auto populate the child record.

View 4 Replies View Related

Forms :: 9i Form To Load Attendance Data

Jan 21, 2013

I want to use SQLLDR (sql loader) in my forms9i form to load attendance data therefore I installed SQLLDR utility in user computer but it is not working,

Begin
:message := 'Please Wait, Data LOADING...!';
Delete From atnd_load;
Forms_ddl('Commit');
utlt:= 'c:oracleora90insqlldr';
usr:= 'vikorapp';
pass := 'vikorapp';
strng := 'laptop';
cntrl := 'C:VikorPayrollFormsAtndCtl.ctl';
lg := 'c: empAtndLog.log';
bad := 'c: empAtndBad.bad';
host(cmd);
:message:= 'Data Loading Complete...!';
End;

View 11 Replies View Related

Forms :: Manually Display Data On Form

Mar 31, 2010

How to retrieve data manually to the text fields from the EMP database.what are the main properties ?

View 5 Replies View Related

Forms :: Import Data Through Form Developer

Dec 16, 2011

Following is the coding i am using to run in forms 6i to import the data in oracle on When_Button_Press . it will drop and create a user but not importing the data

FORMS_DDL('DROP USER TEST CASCADE');
MESSAGE('USER DROP TEST');
FORMS_DDL('GRANT DBA TO TEST IDENTIFIED BY TEST');
MESSAGE('USER TEST CREATED');

host ('C:oracleora90BINIMP TEST/TEST IGNORE=y file=D:ACC_INVTEST.DMP');

MESSAGE('IMPORT');

EXIT_FORM;

View 6 Replies View Related

Forms :: Can Pass Data Again To Calling Form

Jul 26, 2010

I want to send data back to calling form

1. is it possible? if so how?

2. How much length/byte data we can send?

View 3 Replies View Related

Forms :: Upload Data Using 6i While Compiling Form Automatically Closed

Dec 6, 2010

i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this

begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....

View 8 Replies View Related

Forms :: Reading Data From Excel File And Load Into Form

Oct 25, 2013

I have a Excel File which contains some columns and rows, i need to load that excel into a form and import that form data to Database Table, using DDE Method.

In simple i say; Just to read the excel and load into a form, which can be imported into a table later.

How to achieve this? only dde method.

View 10 Replies View Related

Forms :: Calling From Other Data Block Into Current Master / Detail Form

Jun 10, 2013

I got the following scenario.

- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-

Begin

go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......

When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.

View 1 Replies View Related

Forms :: Change Color In Fields In Form Filled Via Data Block?

Jan 4, 2012

I'm trying to change the attributes on a display where the info is gathered via a routine that fills the data block with info. I've searched and tried using 'set item instance property' in several places within the data block using different triggers but still doesn't work.

No errors are encountered or shown. Attributes aren't changed based on a small test condition.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved