Forms :: How To Use Group By Command In 6i
Oct 28, 2011How to use group by command in forms 6i
View 4 Replies
ADVERTISEMENT
Forms :: How To Apply Group By Command In 6i
May 22, 2012How 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
SQL & PL/SQL :: Sort Names In Table Without Using Group By Command
Jul 3, 2011how to sort the names in table without using group by command?.
View 3 Replies View RelatedBrtools Command Versus Oracle Command For Shutdown And Startup (statistics)
Sep 13, 2013we 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 RelatedGroup Records With Less Than One Hour Separation And Count How Many Per Group
Nov 1, 2013I'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.
Forms :: Command To Run SQL File?
Mar 8, 2011i want to run sql file by forms...is there command do that
View 3 Replies View RelatedSQL & PL/SQL :: Combining Rownum And Group By Gives - Not A Group By Expression
Jun 23, 2011I 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 ?
Forms :: Dynamic Record Group For LOV?
Feb 22, 2011I 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?
Forms :: Query In Record Group
Mar 6, 2011I 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.
Forms :: FRM-41827 - Group Does Not Exist?
Mar 13, 2012FRM-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....
Forms :: Get Record Group Query
Apr 3, 2010How 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?
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
Forms :: Saving The Object Group
Dec 13, 2010I'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 RelatedForms :: Command To Maximize The Window
Mar 9, 2010Some 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 RelatedForms :: Sum Data Without Commit Command?
Feb 8, 2011how we can sum data with out commit command in forms
View 3 Replies View RelatedForms :: Changing Record Group For LOV At Run Time
Dec 2, 2008I 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 RelatedForms :: Frm-41084 Error Getting Group Cell?
Aug 23, 2010DECLARE
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;
Forms :: Dynamically Changing The Record Group?
Nov 17, 2011I 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.
Forms :: Frm-41075 Error Deleting Group?
Jan 11, 2013i 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]...
Forms :: Pivot Table Inside Group
Mar 21, 2011I want to use the pivot table inside the group.
View 3 Replies View RelatedForms :: FRM-41072 Cannot Create Group List
Oct 26, 2010I 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.
Forms :: Using Host Command To Run Commands From Linux?
Jul 6, 2010i 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]....
Forms :: Create Lov And Record Group Dynamically At Run Time?
Apr 10, 2013i 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.?
Forms :: Set Properties Of A Visual Attribute Group During Runtime?
Oct 17, 2011way 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 RelatedForms :: FRM-30058 - Invalid Name For A Record Group Column
Feb 2, 2010earlier 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 RelatedForms Host Command Cannot Copy To Network Drive
Oct 3, 2013I 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?
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?
Forms :: FRM-41334 Invalid Record Group For List Population
Apr 23, 2010i 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
Forms :: FRM-41334 / Invalid Record Group For List Population
Jul 5, 2010I 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]....
SQL & PL/SQL :: Group Through Expression Inside Group By?
May 17, 2011Refer 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