Forms :: Choose Fields From Left

Feb 16, 2013

Is there any possibility of creating a selection interface similar to our report or forms wizard where user can select single fields or multiple fields together and when he clicks on the arrow those fields data to be inserted into another table.Please refer attachment.

--this is the main table
create table batch_item (batch_no varchar2(12),item_batch varchar2(12),total_batch_qty number);

insert into batch_item ('0001','a',300);
insert into batch_item ('0002','b',200);
insert into batch_item ('0003','a',102);

--after inserting the data i should be able to move this data to corresponding batches by manually selection and pushing them to a batch.create table ct_item (item varchar2(12),item_nm varchar2(20),item_qty number);

insert into om_item values ('a','alpha',2);
insert into om_item values ('b','beta',3);
insert into om_item values ('c','gama',4);

--left side is om_item and right will have batch items where batch qty will be accumulated upon choose arrows.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: Left Align Number Fields

Mar 11, 2010

Is there any way to align the output data of sql plus.

for eg., if i give "select custname, custid, custage from cust;" the ouput am getting is,

custname custid custage
aaa 1 23
bbbbb 2 22
cccc 3 45
dddddddd 4 21

but i need to left align the custid and custage.

my output should look like,

custname custid custage
aaa 1 23
bbbbb 2 22
cccc 3 45
dddddddd 4 21

View 7 Replies View Related

Forms :: How To Choose Tab In Focus

Oct 7, 2011

I have created a form in Oracle Forms 6i that utilizes a tabbed interface. Each section of the form has different modules to create a quote on the end page. As far as the logic goes, I have it complete. However, I would like to choose the tab that is in focus, and I can't find a place to change this in the property panel. What am I missing? I don't want it to focus on the last tab which is the totals page, when it should focus on the first page where you enter the data.

View 5 Replies View Related

Forms :: Char Display Right To Left

Apr 1, 2011

I am using forms 6i and oracle 10g. i want to display a char from database. that means a database string 'Bangladesh' is display from by one char to one char.

and display view right to left first display "B" then "BA" then 'BAN' etc.

View 2 Replies View Related

Forms :: How To Base A Block On Left Join

Feb 5, 2012

I am trying to develop an application of cars. The car have marques example :

TOYOTA,HUNDAI,CHEVROLET

each mark have families example: TOYOTA have Hilux, yaris corola, CHEVROLET have opra,...etc. Each family have a lot of models example: hilux have h2kn-clim,.. etc. And finally there are some options witch are generally in all cars example Radio-k7,air-conditioner ... etc.

option 1..n-----------------1..n model the relation call(opt_mod)

i did develop the block of marques (master) and the block of families (detail) in a form 1. i did develop the bock of models(master) in form 2 and the is no problem. but i want to add to form 2 the block of (opt_mod) but the user did tell me that he want to to see all options with check boxes .

As a solution of this problem i want to build a block on LEFT JOIN between table :option and table :opt_mod

View 4 Replies View Related

Forms :: Choose Lov In First Record That Won't Be Display In Second Record Lov

Sep 10, 2012

I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov...

View 4 Replies View Related

Forms :: Popup Menu In Left Click Mouse?

Mar 2, 2010

I created Main Menu form and in this form I attached popup menu in picture's property problem is that when i right click on this picture then show the popup menu .I want when I click left click then it should show the popup menu.

View 2 Replies View Related

SQL & PL/SQL :: How To Choose First And Second Row Value

Jun 21, 2011

if i have table contains the following

r_nu record_s value time
1 11111 1 33904
2 30119 4 33904
3 70119 3 33904
4 11111 2 33904
5 20219 1 33920
6 11111 3 33920
7 50119 4 33935

if i want sql statement to select the first value of record_s and the second (both same value) and ignoring the rest

maybe to subtract its value from its second value

got it ?

so will choose
record_s 11111 and value 1
record_s 11111 and value 2
to do : value of second one - value of first one
2-1

View 3 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

Sep 23, 2011

I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.

Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.

View 5 Replies View Related

SQL & PL/SQL :: Choose Explicit Cursor To Loop Through At Runtime?

Nov 1, 2011

Oracle Version: 11.2.0.2.0. I have two explicit cursors and I would like to choose at run time which one to run. Here is a simplified code snippet of what I am doing today:

DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';

[code]....

I want to avoid maintaining the same long list of transformations. I also want to avoid, if possible, an explicit FETCH INTO, because there are hundreds of fields in both tables. I'm looking for something like this (and I know this doesnt work):

DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';
CursorToRun IS REF CURSOR;

[code]....

View 4 Replies View Related

Choose Right Raid Level For Oracle Database

Aug 10, 2010

Tell me the right raid level for oracle database and why? The best companies that makes raid servers?

[URL].........

View 3 Replies View Related

Forms :: Data Source For Fields?

Mar 15, 2012

I have a horrible problem with EBS (actually, all problems with EBS are horrible) and I think I am stuck because of my ignorance of Forms. if I use terms that are not correct in the Forms world. The form consists of a number of named "blocks" and each block consists of a number of named "fields", not all of which are visible. I need to find the source of the data values in one of these fields. I have searched every table for a column of that name, also all the views and stored PL/SQL that I think might be relevant, but I can no find no mention of a column or variable with the same name as the field. The name does not get a hit in the online EBS tech ref manual, and only two ancient and irrelevant hits in MOS.

My question is: What are the possible sources of data for a field in a form? Have I missed any?

View 14 Replies View Related

Forms :: Search For NULL Fields

Feb 1, 2012

Is there any way to see items in the block having null in them? I want to figure out null field before inserting the data in the database table. At the moment I am having an error ORA 01400 which means that a NULL cannot be inserted into NOT NULL column. So, I want to create a procedure which will fire before insert trigger of the block and it will show me the names of items having null it them.

Procedure check_data(block_name in varchar2)
First_item varchar(20);
Current_item varchar(20);
Last_item varchar(20);
Begin

[Code]..

The problem is that I don't know the function to get the value inserted by user in the field so that I can compare it in IF condition.

View 3 Replies View Related

Forms :: Disable Fields Using Personalization

Oct 2, 2010

I am working on Oracle Apps 11i. Need Forms Personalization.

Client requirement: Selected user should only see Office Phone Number for all the people in the organization when he enters the Phones form.

Means, the client is having around 10 Lookup values for Phones (Like Mobile (Office), Mobile (Personal), Office (fax), Office No. etc). Now, they want to give access to admin, only to update the Phone numbers related to Office. So, when the admin logs-in to the phone form of a employee, that admin should not be able to see other phone numbers of that Employee.

Is it possible using Forms Personalisation?

View 4 Replies View Related

Forms :: How To Use Some Fields Of Form In Arabic

Sep 30, 2012

i want to use Arabic language in one of the fields available on the form.

i alreade have done the following

1. On database

update PROPS$
set value$ ='AR8MSWIN1256'
where name = 'NLS_CHARACTERSET';

2. On system registry

Have changed all nls_lang variable in the registry to 'American_America.AR8MSWIN1256'

3. On Form

Have changed the field font to 'Simplified Arabic' and reading order 'right to left'

4. On Operating System

Change the region and language setting
format 'Arabic (saudi Arabia)'
keyboard and languages add 'Arabic (saudi arabia)'

5. have restarted the database on the server and also the client machine.

View 13 Replies View Related

Forms :: All Block Fields Are Disabled

Dec 11, 2011

I am using Forms 6i in Application. In Form, After i enter the data and saved then,if i retrieve the data by using Ctrl+F11, all the fields of data block turns to be disabled (insert not allowed, update not allowed) of course i am getting the data.If i close the application, and open freshly it works good (insert allowed, update allowed).

View 1 Replies View Related

Forms :: How To Validate Primary Key Fields In 6i

Mar 5, 2011

i have a emp block with multiple rows in which col1,col2,col3,col4,col5,col6 are the columns...In emp block col1,col2,col3 are the primary key fields.. i need to validate the primary key columns such that it should not allow duplicates values in the primary key col's with out checking the database values with out using enforce primary key property

View 2 Replies View Related

How To Choose Best Stripe Size For A RAID10 Array - 10gR2

Oct 7, 2010

I have been studying possible ways to calculate the best size for the stripe size on my new storage. From what I have seen it appears that there is no straight answer but I believe there must be good way of estimating it. I am deploying a new storage that uses 16 x 600GB 15k RPM 6Gbps SAS drives, it is supposed to be very fast but I think if I get the stripe size on the RAID10 array right I should be able to get even more out of it. I am running oracle 10.2.0.4.0 (10gR2) on 64bit Linux with 32GB of RAM, the SGA is set to 20GB.

What I read said that the "stripe size must be at least as large as the I/O size." The I/O size is calculated from DB_BLOCK_SIZE * DB_ FILE_ MULTIBLOCK_ READ_COUNT, which is my case is "db_block_size = 16k * db_file_multiblock_read_count = 16 = 256k." The current RAID10 array that I am using which will be decommissioned soon has a stripe size of 128k, and if I understood it all correctly it is undersized for my Oracle instance.

With an I/O size of 256k the smallest stripe that I should choose is 256k but how do I know what is the best combination of db_file_ multiblock_ read_ count and db_block_size?

We are planning to create new table space with a block size of 32k as this has been recommended by a number of DBAs but with "db_block_size = 32k * db_file_multiblock_read_count = 16 = 512k".

Is this a viable size? Do you think this will actually improve performance on my system? Note that this database gets about 1500 insertions per second and peaks around 3000 insertions per second, it is a mixture of OLTP and data warehousing.

After doing a lot of research I came across an article by "Don Burleson" which says that starting in Oracle 10gR2 the "Oracle recommends not setting the db_file_multiblock_read_count parameter, allowing Oracle to empirically determine the optimal setting." References: URLs.....

View 5 Replies View Related

Memory Management - Choose Parameters For Server With A Fixed RAM?

Apr 18, 2011

the erelationship between sga_max_size,sga_targt,shared_pool_size,pga_aggregate_target and the server memory.

In short how shud i choose the above parameters for a server with a fixed RAM.

View 1 Replies View Related

Forms :: Fields Not Writing To Database Table

Jul 27, 2010

I have an Oracle Form 6i. There are two blocks. One is a database block called CUSTOMER and the other is a non-database block called CONTROL.

In the PRE-INSERT trigger of the database block, values from the non-database table block are passed to the database table block. When I pass values I use the :BLOCK_NAME.field_name eg. :CUSTOMER.scale_code := :CONTROL.scale.

In this form the values passed to the database block from the non-database block in the PRE-INSERT trigger do not use the block name e.g. :-

:warehouse := :global.default_warehouse;
:capturer :=captured
:scale_code := scale;
:date_captured := sysdate;
insert into dd_audit(cus_id,cap_date) values(:CONTROL.cus_id,SYSDATE);

This application used to work fine for months, last week when writing the values in the PRE-INSERT trigger, just the warehouse field had a value. The remaining fields after the warehouse did not pass any values, although it was verified that values would have been present in the non-database block. The date_captured field should have at least had the system date. The last insert into dd_audit was successful.

I have done numerous tests on our test database and could not replicate the problem. Would passing the values from the non-database block to the database block without the :BLOCK_name preceding the field name cause this problem.

View 4 Replies View Related

Forms :: Enter Data In Mandatory Fields

Mar 29, 2011

I developed a custom Form using Form Builder 6i. This Form has selection criteria (data to be entered in a couple of fields) and a "Find" Button, which queries the data (based on the selection criteria) and populates all fields on the Form.

This Form has a couple of "Required" fields in its search criteria section. When data is not populated in any of the Required fields and "Find" button is clicked upon, Form raises an exception and pops up a message indicating the user 'to enter data in mandatory fields'. However, this message keeps popping up and would not stop.

So, I'm not able to proceed with querying data on my custom Form. I had to kill the session and reconnect to front end to overcome this issue.

View 6 Replies View Related

Forms :: Fields Not Getting Disabled In Mouse Click?

Apr 11, 2011

I am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'

but I can go there with mouse click ( for tab and enter it is working fine ) .

but for mouse click it is not working .

if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);

[Code]....

View 1 Replies View Related

Forms :: Calculate Difference Time Between Two Fields

Mar 24, 2011

I have two different date in my payroll software,

1-Shift_date shift date *used to contain shift timings
2-Attendace_datedate *used to contain employee IN timings

As you all know that shift is a setup form, where user input data once in the starting of software so the shift_date can be "01/jan/2011 16:00 pm" but attendance loads daily and attendance field data can be in this form "24/mar/2011 16:15 pm"..Now I want to calculate difference time between these two fields therefore I used this statement

SQL> Select to_char(attendance_date,'HH24:MI') to_char(shift_date,'HH24:MI') from dual;

but it is showing error: ORA-01722: invalid number...I used hours/minutes format mask in my query because you can see there is a difference of dates between these fields and it will be increase in the coming future and I need late hours and minutes.

View 2 Replies View Related

Forms :: FRM-30187 - Checked All Fields On RG Query

Aug 1, 2008

I got that error bur I checked all the fields on RG query and they are not more 300 char in total. Even I changed the query but I still get this error.

View 2 Replies View Related

Forms :: How To Capture Date And Time In Separate Fields

May 8, 2012

I want to capture date and time in separate fields from user and save it in single column in table

example: user enters date and time
Date : 08/05/20212
Time : 18:50:00

At the time of save I want to save [08/05/2012 18:50:00].

View 1 Replies View Related

Forms :: Unable To Make The Form Fields Available To Edit

Jan 30, 2013

My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.

For that i have used below code in when-new-form-instance

- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');

After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.

I have added below piece of code

set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);

in almost all the triggers and tried. I could still see all the fields are read only.

View 4 Replies View Related

PL/SQL :: Text Fields Getting Disappeared After Saving In Oracle Forms?

Mar 1, 2013

I have developed a screen using oracle forms.... it has 4 text fields..then a LOAD button.After giving i/p in the 4 text boxes user will save (ctl+S) ..then hit LOAD button ,which will populate the fields below the screen.Everything is working fine but only problem I am facing...when user is trying to save (ctl+S) after giving the 4 i/ps in the text fields....the text fields getting disappeared and also becoming editable...though the data they have already given is being populated in the table..I want ..even after pressing ctl+S...the data should be there & non-editable.

View 2 Replies View Related

Forms :: Fields Disappear / Hide After Pressing Execute Query?

Feb 15, 2010

Something strange happens when i give execute query in a form (Oracle Forms 10g.). On executing query, one field disappeared but when i clicked on the location of the field it appeared again. I am not sure if this has something to do with visual attributes/display properties. This is happening only after migration to 10g.

View 7 Replies View Related

Forms :: Error - 7033 In Total Folder Form Fields

Jun 24, 2013

In my Folder Form i have 6 Total Fields(SUM) , when i press anyone of these Total Filed, to move Right Or Left i got an error like this "frm-40733 pl/sql built-in set_group_char_cell failed."

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