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....
ADVERTISEMENT
SQL & PL/SQL :: ORA-23404 - Refresh Group Does Not Exist?
Jul 11, 2011When I create a Materialized view using:
CREATE MATERIALIZED VIEW LOAD.M_VW_ABN_PROD_921
[color=red][i]REFRESH FORCE ON DEMAND START WITH sysdate+0
NEXT (TRUNC(SYSDATE+1) + 9.5/24)[/i][/color]AS
SELECT
...............
......................
it creates a DBMS_JOB for me with the required interval.
But now my requirement is that I want to create a job on the existing MV.
Now I tried the code mentioned in the previous post to schedule the job.
This job does not work. When I tried to execute it manually using:
DBMS_IJOB.RUN(12345) as sys user is throws the follwing error.
Error listed in the alert.log file is as below:
ORA-12012: error on auto execute of job 17497
ORA-23404: refresh group "CLARITY"."M_MV_INBASKET_ANALYSIS"
does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REFRESH", line 23
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Sun Jul 10 20:07:51 2011
Forms :: ORA-00942 - Table Or View Does Not Exist
Jun 8, 2011The form actually consists of one block that refers to a table in DB(Datablock). The functionality of the form is to run some logic and then just insert data in the table .This happens on press of a button.
The problem is when I run the form thru' Admin Id it runs successfully but when I run the form through some other user it gives me the error.
The grants on the table are Public. GRANT DELETE, INSERT, SELECT, UPDATE ON XYZ TO PUBLIC;
Forms :: Frm-40815 Error Variable Does Not Exist
Apr 6, 2011I am using Global Variables to store the data from the form variables and once again restore it in the form when User ID is entered.
For this I write the code in Pre-commit trigger
:global.gzaoffe_nofday := :gzaoffe.gzaoffe_nofday;
:global.gzaoffe_time_period := :gzaoffe.gzaoffe_time_period;
:global.gzaoffe_time_from := :gzaoffe.gzaoffe_time_from;
:global.gzaoffe_time_to := :gzaoffe.gzaoffe_time_to;
:global.gzaoffe_date_from := :gzaoffe.gzaoffe_date_from;
:global.gzaoffe_date_to := :gzaoffe.gzaoffe_date_to;
:global.gzaoffe_official_reason := :gzaoffe.gzaoffe_official_reason;
Then I write the code in KEY-NEXT-ITEM trigger of gzaoffe.user_id
:gzaoffe.gzaoffe_nofday := :global.gzaoffe_nofday;
:gzaoffe.gzaoffe_time_period := :global.gzaoffe_time_period;
:gzaoffe.gzaoffe_time_from := :global.gzaoffe_time_from;
:gzaoffe.gzaoffe_time_to := :global.gzaoffe_time_to;
:gzaoffe.gzaoffe_date_from := :global.gzaoffe_date_from;
:gzaoffe.gzaoffe_date_to := :global.gzaoffe_date_to;
:gzaoffe.gzaoffe_official_reason := :global.gzaoffe_official_reason;
Form is compiling successfully. But when I enter the User ID It is showing the error FRM-40815 Variable GLOBAL.GZAOFFE_NOFDAY does not exist. Like this it is showing for all global variables.
Group 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 :: How To Use Group By Command In 6i
Oct 28, 2011How to use group by command in forms 6i
View 4 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 :: 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 :: 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
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 :: 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 :: 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 :: 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
Forms :: Dynamic Record Group To Filter Selected Values In A Multirecord Block From A LOV
Jul 9, 2013I am working on Oracle forms 10g (Windows 7 OS).I have got one requirement to show one LOV for COLOR table. Say i have three colors BLACK, RED, BLUE in color table. Suppose in a multi record block if a user selects BLACK from a lov for one record then for the next record lov it should show only RED and BLUE. How to filter the COLOR from a LOV record group query which are already selected?
View 1 Replies View RelatedForms :: Only New Record Have Saved Last Record No Longer Exist
Jun 29, 2013I create a data block on a table when I am inserting new record only one record have been saved. Last record no longer exist.
View 4 Replies View RelatedForms :: Populating Values To Record Group From Multi Record Datablock
Jul 26, 2012My procedure proc_ex is in when_validate_item trigger
I have one Multi Record data block in my form with values in its items
I need to Populate multi record block values to one Record Group using
add_group_row,
add_group_column,
set_group_char_cell to populate values to record group
Let us suppose my multi record data block looks like
item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80
how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies
Forms :: How To Check Only One Radio In Radiobuttons Of Radio Group
Aug 2, 2013i have a radio group(RG) in that group i have two radiobuttons: rb1 and rb2 on a datablock based on a view having display iems 8. i made only one visible i.e rb1. so there is 8 radio buttons displaying in that datablock and when i check one and then another, the previously checked is not unchecked by itself. i need to do when i checked on one then the previous one unchecked itself.
View 2 Replies View RelatedTo Add One Disk Group Space To Another Disk Group
May 9, 2011Is there any way to add one disk group space to another disk group. Because One of my disk group is full i want to add space in to that group.
View 1 Replies View Related