Forms :: How To Use Group By Command In 6i

Oct 28, 2011

How to use group by command in forms 6i

View 4 Replies


ADVERTISEMENT

Forms :: How To Apply Group By Command In 6i

May 22, 2012

How To Apply Group by Command in Forms 6i at block level for example in data block a field name is code,quantity and code replicate many times it is not working with out commit but i want to calculate sum of quantity in data block by code group before commit

if we apply this command at sql level then command is

select code,sum(nvl(quantity,0)) from sal_detail group by code and its work very well

View 11 Replies View Related

SQL & PL/SQL :: Sort Names In Table Without Using Group By Command

Jul 3, 2011

how to sort the names in table without using group by command?.

View 3 Replies View Related

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

Group Records With Less Than One Hour Separation And Count How Many Per Group

Nov 1, 2013

I'm trying to group sets of data based on time separations between records and then count how many records are in each group.

In the example below, I want to return the count for each group of data, so Group 1=5, Group 2=5 and Group 3=5

SELECT AREA_ID AS "AREA ID",
LOC_ID AS "LOCATION ID",
TEST_DATE AS "DATE",
TEST_TIME AS "TIME"
FROM MON_TEST_MASTER
WHERE AREA_ID =89
AND LOC_ID ='3015'
AND TEST_DATE ='10/19/1994';

[code]....

Group 1 = 8:00:22 to 8:41:22

Group 2 = 11:35:47 to 11:35:47

Group 3 = 15:13:46 to 15:13:46

Keep in mind the times will always change, and sometime go over the one hour mark, but no group will have more then a one hour separation between records.

View 4 Replies View Related

Forms :: Command To Run SQL File?

Mar 8, 2011

i want to run sql file by forms...is there command do that

View 3 Replies View Related

SQL & PL/SQL :: Combining Rownum And Group By Gives - Not A Group By Expression

Jun 23, 2011

I read that rownum is applied after the selection is made and before "order by". So, in order to get the sum of salaries for all employees in all departments with a row number starting from 1, i wrote :

select ROWNUM,department_id,sum(salary) from employees group by department_id

If i remove rownum, it gives the correct output. Why can't rownum be used here ?

View 16 Replies View Related

Forms :: Dynamic Record Group For LOV?

Feb 22, 2011

I want to create a Dynamic record group and associate it to a LOV.for example: I want that for a set of people A, i want to fire the query in lov:

select * from emp where (condition 1)
and for another set of people B, I want to fire
select * from emp where (condition 2)...

How could I achieve it?

View 4 Replies View Related

Forms :: Query In Record Group

Mar 6, 2011

I am calling one record group to get the security permissions. That RC is associated with one SELECT query. That RC is already created and used before i call. I m just re-using the same. But my form/module dont have privilages to see the QUERY in that recrod group. I just want to see the query in side that record group. how to print the SELECT query from the record group.

p.s: That record group is built in run-time.

View 1 Replies View Related

Forms :: FRM-41827 - Group Does Not Exist?

Mar 13, 2012

FRM-41827:Group does not exist.

I am getting the above error in Oracle Forms as I am using it in Oracle Apps 11.5.10.2 as a custom form... how to resolve the above error....

View 4 Replies View Related

Forms :: Get Record Group Query

Apr 3, 2010

How can I get record group query in code and chang it ?( for example change its where clus). I need to get its Query.

the record group exists and I must get its query not make it.

and I know about Populate_Group_With_Query for changing but cant I have the query to change?

FOR EXAMPLE :
my record group query is :
select a ,b from A where A.c=1;

and I use it in an LOv.

Now i want get this record group in code and change its WHERE cluse after pressing A BUTTON How can I do it?

View 2 Replies View Related

Forms :: Dynamic Record Group

Aug 25, 2012

i have a question regarding dynamic record group creation.I have a text item(department) attached with LOV ,and a list item is also there.i want whatever the department name i will select from ma LOV according to that corresponding manager name should be display in the list item.

my table structure is :-
table- QRY
column- DEPT_ID,DEPT_NAME,MANAGER_NAME

View 2 Replies View Related

Forms :: Saving The Object Group

Dec 13, 2010

I've created Object Group which consists of (alert, parameters, visual attribute and property class). Now I want to save this Object Group.

View 3 Replies View Related

Forms :: Command To Maximize The Window

Mar 9, 2010

Some of the items are not getting displayed properly in my form when i run.I want all of them to appear on form. Can i maximize when i open.If so whats the command.

View 5 Replies View Related

Forms :: Sum Data Without Commit Command?

Feb 8, 2011

how we can sum data with out commit command in forms

View 3 Replies View Related

Forms :: Changing Record Group For LOV At Run Time

Dec 2, 2008

I have 2 record groups names RG1,RG2 , I attached RG1 record group to LOV1 at design time,I want to change the record group RG1 to RG2 for LOV1 at run time.

View 11 Replies View Related

Forms :: Frm-41084 Error Getting Group Cell?

Aug 23, 2010

DECLARE
rg_id RecordGroup;
rec_count NUMBER;
BEGIN

-- Get the record group ID --
rg_id := Find_Group( 'PAYMENT_TERM_RG' );

-- Get the number of rows --
rec_Count := Get_Group_Row_Count( rg_id );

-- delete the selected row --
FOR j IN 1..rec_Count LOOP
If Get_Group_Number_Cell( 'PAYMENT_TERM_RG.DESCRIPTION', j ) = :XX_PAYMENT_TERM.ATTRIBUTE1 Then
Delete_Group_Row( rg_id, j );
exit ;
End if ;
END LOOP;
END;

View 1 Replies View Related

Forms :: Dynamically Changing The Record Group?

Nov 17, 2011

I am working on forms 6i, ebs 11i and data base 9i. I have below requirement to achieve.

I want to create a lov for a column called 'FORM'.

I have lookup for this as follows

lookup code meaning description

FORM FORM XXSMCINV_FORM

in the description, it's value set name.

I am manually checking the value set name and writing static record group.

Right now, i have static record group for this like below.

select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM' order by flex_value;

It's working fine.

But in the lookup, they can add one more FORM like below.

LOOKUP_CODE MEANING DESCRIPTION

FORM FORM XXSMCINV_FORM
FORM1 FORM1 XXSMCINV_FORM1

Now i have to change the record group query manullay like below.

select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM' order by flex_value;
UNION
select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM1' order by flex_value;

Is there anyway i can make this automatic whenever they add new FORM lookup.

Is this possible to achieve using dynamic record group.

View 1 Replies View Related

Forms :: Frm-41075 Error Deleting Group?

Jan 11, 2013

i used item list in my form ,i want to fill this item list ...but i encountered this error 'frm-41075 error deleting group' !!!here is the code :

//when-new-form-instance
declare
errcode number;
group_id RecordGroup;

[code]...

View 3 Replies View Related

Forms :: Pivot Table Inside Group

Mar 21, 2011

I want to use the pivot table inside the group.

View 3 Replies View Related

Forms :: FRM-41072 Cannot Create Group List

Oct 26, 2010

I am having one list item Source_Name, combo box Column_name.

Source_Name list item which shows the table/view name. Upon selecting this table name, next combo box should populate columns of this selected table/view.

Passing below SQL to populate columns:

'SELECT COLUMN_NAME ,COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE ' ||' TABLE_NAME = '||:GEAECUST_SLISE_OUT_FILES.SOURCE_NAME
||' ORDER BY 1'

I am writing this code in when-list-changed of source name.It is compiling but while running the form, when source name is selected, it is giving error:

FRM-41072: Cannot create group list
FRM-41076: Error populating group.

If i use USER_TAB_COLUMNS instead of all_tab_columns but i want to write all_tab_columns because tables are present in different schema.

View 1 Replies View Related

Forms :: Using Host Command To Run Commands From Linux?

Jul 6, 2010

i was trying to use the host command to run the commands from linux. however, it doesnt work.

PROCEDURE compile_procedure IS
c_success boolean;
c_bare_filename varchar2(50);
command_string varchar2(1000) ;
BEGIN
c_bare_filename := substr(:B_DEV.B_DEV_ITEM_FILENAME,instr(:B_DEV.B_DEV_ITEM_FILENAME,'',-1)+1);

[code]....

View 4 Replies View Related

Forms :: Create Lov And Record Group Dynamically At Run Time?

Apr 10, 2013

i want to create a lov and record group dynamically at run time. i have the code in when-form-instance..

Declare
v_lov lov;
rg_id recordgroup;
gc_id groupcolumn;

[Code]....

whether i create first a lov and record group at design time or not? if i create a lov and have the recordgroup column then what is the benefit of dynamically lov.?

View 5 Replies View Related

Forms :: Set Properties Of A Visual Attribute Group During Runtime?

Oct 17, 2011

way to set the properties of a visual attribute group during runtime? During our forms 6 to 10 conversion we missed that our visual attributes for mandatory and not-manadatory items were different, so we have font size 8 and 9 in our system now, does not look very nice.

View 1 Replies View Related

Forms :: FRM-30058 - Invalid Name For A Record Group Column

Feb 2, 2010

earlier the query was running on same record group but i hav to delete some code so i did but after made such changes itreturns this error.but still query is correct i complied on toad.

View 10 Replies View Related

Forms Host Command Cannot Copy To Network Drive

Oct 3, 2013

I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.

The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow

net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf

Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:

copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf

Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?

View 1 Replies View Related

Forms :: POST Command - Getting Committed With Error Especially In New Database?

Jul 29, 2010

I have a form which will call another and do some transactions and come back to original form and do other processes. save if successful. or roll back with error message.i m doing POST when i exit from the called form. and continue process in calling form. if any error, i m raising an error message with rollback.

But sometimes, it is getting committed with that error trn. especially in new database, first time try the scenario, it any error comes then getting commited.I m not able to find where the commit is happening? if any other sessions commit will affect this trn?

View 1 Replies View Related

Forms :: FRM-41334 Invalid Record Group For List Population

Apr 23, 2010

i want to populate value into list item from below record group

DECLARE
channel recordgroup;
banks recordgroup;
errcode NUMBER;
errcode1 NUMBER;
m_stmt VARCHAR2 (100);
BEGIN
m_stmt :='SELECT DISTINCT RI_TYPE FROM COMPETETITION_DATA_UPLOAD';

[code]....

but i'm getting following error in forms FRM-41334 Invalid Record Group for list population

View 1 Replies View Related

Forms :: FRM-41334 / Invalid Record Group For List Population

Jul 5, 2010

I created 3 radio buttons and one list item. Different options will appear according to the radio button the user has clicked on. i've created 3 recordgroups and 3 LOV. the first two for seven_eleven and mannings work fine, but not for GNC. is it because there is only one option for list item in GNC? Must it be more than one? I've tried to another option as space but it still doesnt work.

DECLARE
it_id1 item;
V_SEVEN_ELEVEN RECORDGROUP:=NULL;
V_MANNINGS RECORDGROUP:=NULL;
V_GNC RECORDGROUP:=NULL;

[code]....

View 13 Replies View Related

SQL & PL/SQL :: Group Through Expression Inside Group By?

May 17, 2011

Refer to the txt file to create table and insert data.

I executed the following query-

SELECT priority, detail, COUNT(1) FROM TEST GROUP BY priority, detail

and got the following result-

PRIORITYDETAIL COUNT(1)

StandardPatch 27
StandardInitial TSS 1
StandardInitial development 10
StandardProduction deployment5
High PriorPatch 1

Now I want that Initial TSS and Initial development should be combined as Initial together and I should get the result as follows:

PRIORITYDETAIL COUNT(1)

StandardPatch 27
StandardInitial 11
StandardProduction deployment5
High PriorPatch 1

View 3 Replies View Related







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