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


ADVERTISEMENT

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

Forms :: Populating Values To Record Group From Multi Record Datablock

Jul 26, 2012

My 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

View 3 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 :: 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 :: 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 :: 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 :: 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 :: Dynamic Record Group To Filter Selected Values In A Multirecord Block From A LOV

Jul 9, 2013

I 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 Related

Dynamic Record Group Not Working When Apostrophes Used?

Aug 14, 2012

I have developed a Form for the most part everything is working as expected. However, there is a search functionality that is giving me problems. The issue is that when the user enters search criteria for last_name that has an apostrophe (O'brian) the search lov doesn't get populated because the dynamic record group is not getting created when the string has an apostrophe (ie O'brian). I have a dynamic record group that takes the user's search criteria and populates an LOV on the screen with the records that matched their criteria.

Here is the code that is behind my search button where the dynamic RG gets created. It works fine for all searches that don't contain an apostrophe.

DECLARE
p_where_debtor varchar2(2000);
p_where_liab varchar2(2000);
rg_id RecordGroup;

[Code]....

errcode := Populate_Group(rg_id);

View 5 Replies View Related

SQL & PL/SQL :: How To Add Alias Column Name To Group By

Aug 10, 2011

I have the following query:

SELECT AGENCY, COUNT(*)
FROM (SELECT A.AGENCY,SUM(A.NUM_LOGIN)
FROM GOVAGENCY A
WHERE AGENCY = 'DOD1'
GROUP BY A.AGENCY
[code].......

The results are:

AGECNY COUNT(*)
-------- -----------
DOD1 1
DOD2 1
2

The rollup value has a blank label instead I want to have a label to the rollup result also ex:

AGENCY COUNT(*)
--------- -----------
DOD1 1
DOD2 1

DEPT. OF DEFENSE 2

View 5 Replies View Related

SQL & PL/SQL :: Column Search - Group By

Sep 27, 2010

I have a table emp where empid,employee name,job,salary are three columns.I need to retrieve empid,count of emp,emp name,emp salary of job = manager and total salary of all employees with grouping by job in one query.

View 13 Replies View Related

PL/SQL :: Add Four More Column And Group By PRODUCT

Sep 28, 2012

I am new to PL/SQL environment.. ( USING PL/SQL Oracle)

SELECT TABLE1.PRODUCTID, TABLE1.TYPE , TABLE1.PRODUCT, TABLE2.#SOLD
FROM TR.TABLE1
INNER JOIN
PR.TABLE2
ON (TR. PRODUCTID = PRODUCTID )

Query result.

Product ID     Product          Type          #Sold
1     Fruit          Banana          2
2          Food          Rice          4
3          Food          Sugar          6
4          Fruit          Orange          2
5          Fruit          Apple          10
6          Food          Sugar          12
7          Food          Corn          3
8          Fruit          Apple          5
9          Fruit          Banana          2
10          Food          Sugar          1
11          Fruit          Banana          5
12          Food          Sugar          7

But would like to add Four More Column and group by by PRODUCT.Final Result will look like :

     {Product}     ,     {Type}     ,     {#Sold}     ,     0 to 3     ,     4 to 9     ,     >10          Total Sold     
          ,     {Corn}     ,     3     ,          ,          ,                    
          ,     {Rice}     ,          ,     4     ,          ,                    
          ,     {Sugar}     ,          ,          ,          ,     26               
     {Food}     ,          ,          ,          ,          ,               33     
          ,     {Apple}     ,          ,          ,          ,     15               
          ,     {Banana}     ,          ,          ,     9     ,                    
          ,     {Orange}     ,          ,     2     ,          ,                    
     {Fruit}     ,          ,          ,          ,          ,               36     }

View 9 Replies View Related

SQL & PL/SQL :: What Is Meant By Invalid Column

Nov 29, 2010

I am going through this link: URL.....Under the heading "Creating FORCE VIEWS",it states,

For example, if a view refers to a non-existent table or an invalid column of an existing table, or if the owner of the view does not have the required privileges,. I did not understand what is meant be Invalid column and the situations which make a column Invalid.

View 2 Replies View Related

SQL & PL/SQL :: Expression Column With A Group By Clause?

Mar 28, 2011

getting expression into a Group By query in oracle.

I have a simple table with two columns. 'ID' and 'Amount'

I want output of the SQL to the following (only 2 fields in the output): I have attached the desired output.

select sum(amountheld) from table1
where member_status = 'MEMBER'
group by ID

This group by query works. But how can i get the expression field (the first field which 'TEMPACCOUNT') in this query (based on my attached output).

View 5 Replies View Related

Forms ::create History Record For Each Record Whether Updated Or Not

Sep 13, 2011

I have a fairly standard Purchase Order form which contains pre-loaded data (been uploaded from an XML file).When the Purchase Order is processed, the form updates a Price History table only if the Price on the PO_Details changes.The code for updating the price history table is contained in a PRE_UPDATE trigger on the PO_Details Data Block.

No other data changes on the PO_Details table.I now want to change this so that the Price History table is updated even if the price does not change i.e I want to create a history record for each record on the PO_Details irrespective of whether it was updated or not.

Is there an alternative trigger that I can move my code to (ie move it from PRE_UPDATE) to some other trigger that is fired for each PO_Details record even if there is no change.

View 4 Replies View Related

Forms :: Only New Record Have Saved Last Record No Longer Exist

Jun 29, 2013

I 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 Related

SQL & PL/SQL :: Using Sequence To Insert In Child Table Group By A Counter Column

Oct 1, 2011

I found nothing in SQL (all in PL/SQL).I have a table:

create table Parent (pk_id number primary key); --which is filled using sequence seq_Parent.

And I have a child table:

create table Child (rRef number, fk_parent number primary key (rRef, fk_parent);

that I need to insert into Child using seq_parent but I want to insert the same sequence for each group of rRef. I dont know how to do that using SQL not PL/SQL.

View 7 Replies View Related

SQL & PL/SQL :: Select Columns Of 3 Tables In Such A Way That Period Column Should Be In Group By Function

Aug 16, 2011

i want to select columns of 3 tables in such a way that period column should be in the group by function.

create view allocated_budgets_detail as
select ba.ba_fin_year, ba.ba_start_date, ba.ba_end_date, ba.ba_rev_no,
bh.bh_budget_code,
bd.bd_period,
bb.bb_entered_amount
from budget_header bh, budget_allocation ba, budget_distribution bd, budget_balance bb
where bh.bh_budget_id = ba.ba_budget_id
and ba.ba_line_id = bd.bd_budget_line_id
and ba.ba_line_id = bb.bb_budget_line_id
group by bd.bd_period

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

JDeveloper, Java & XML :: Invalid Column Index Error - Web Applications

Mar 13, 2012

I'm working on a Java Web Application

(User input(jsp)<-->Controller<----->DAO<----->Database) project where the user submits certain fields (partyId, DocId, cbrxPath, cbrValue, nodeId, TRANSLATION_Class and so on)and they are saved in 3 different tables (Party_Document_Node table, Routing and Routing_Node table).

Here's the portion of the DAO code below where the problem is:

public class AssociationsDAOOracleImpl implements AssociationsDAO {
private static final String PARTIES_WITH_ASSOCIATIONS = " Select distinct(party_id) from PARTY_DOCUMENT ORDER BY 1";

private static final String ASSOCIATION_FETCH_QUERY = " Select PARTY_ID, DOCUMENT_ID, NODE_ID, APPLICATION_CONTEXT_XPATH, DOCUMENT_LOGGING FROM PARTY_DOCUMENT_NODE WHERE PARTY_ID = ? ORDER BY PARTY_ID ";

private static final String ROUTING_FETCH_QUERY = " Select CONTENT_ROUTING_PATH FROM ROUTING WHERE PARTY_ID = ? AND DOCUMENT_ID =? ORDER BY PARTY_ID ";

private static final String ROUTINGNODE_FETCH_QUERY = " Select CONTENT_ROUTING_VALUE, TRANSLATION_CLASS FROM ROUTING_NODE WHERE PARTY_ID = ? AND DOCUMENT_ID =? AND NODE_ID =? ORDER BY PARTY_ID ";

private static final String CONTEXT_FETCH_QUERY = " Select CONTEXT_VALUE, CONTEXT_INSTANCE, CONTEXT_KEY FROM APPLICATION_CONTEXT where party_id = ? and document_id = ? and node_id = ? ";

private static final String NODEID_FETCH_QUERY = " Select NODE_ID FROM PARTY_DOCUMENT_NODE WHERE PARTY_ID = ? AND DOCUMENT_ID =? AND NODE_ID =? ORDER BY PARTY_ID ";
[code]....

View 1 Replies View Related

Reports & Discoverer :: Creating Data Link Using A Column Only Selected In One Group

Dec 14, 2010

I have a report with 2 groups Gheader and Glines.The report looks at PO headers and lines. I want to create a data link from the the 2 queries based on the line id in po_lines_all.However I only want to select this in the lines query so I do not get repeating records at the header query.

View 11 Replies View Related

SQL & PL/SQL :: Record To Column Format

Feb 1, 2011

I have to display a record in column format. I have tried doing it using COUNT & DECODE as in below script.

SELECT COUNT (DECODE (a1.application_status, 21, a1.ppid, NULL)) cnt_app21,
COUNT (DECODE (a1.application_status, 22, a1.ppid, NULL)) cnt_app22
FROM (SELECT a.application_status application_status, a.ppid ppid
FROM vp_recon_upload_dtls a, vp_ppid_upload_info b

[Code]...

This gives output as:-

cnt_app21 cnt_app21
3 1

The second query is little different from above as it has 2 more tables joined and more conditions than first query.

SELECT SUM (DECODE (a2.application_status, 21, a2.rate_amount, NULL)) sum_app21,
SUM (DECODE (a2.application_status, 22, a2.rate_amount, NULL)) sum_app22
FROM (SELECT a.application_status application_status,
d.rate_amount rate_amount
FROM vp_recon_upload_dtls a,

[Code]....

Second query output is :-

SUM_APP21 SUM_APP21
222 111

My requirement is to display all the four values in one row as:-

cnt_app21 cnt_app21 SUM_APP21 SUM_APP21
3 1 222 111

One easy way is to create two views and select values from them.

But for some reason I have to write in a query as there would be more dynamic conditions added to it.

View 2 Replies View Related

SQL & PL/SQL :: Column Reverse In Record?

Nov 7, 2011

I am trying to reverse data from couple record. I have display the output below of how I want it to be and is it possible to do it?

Quote:

This is how it is right now

ID|FROM_UOM_KEY|UOM_KEY|UOM|QUANTITY
1 |PK |PK |PK |1
2 |EA |PK |PK |3
3 |PK |PK |PK |1
4 |EA |PK |PK |3

I want it to be like this.

ID|FROM_UOM_KEY|UOM_KEY|UOM|QUANTITY
1 |EA |PK |PK |1
2 |PK |PK |PK |3
3 |EA |PK |PK |1
4 |PK |PK |PK |3

Here is the code

SELECT
from_uom_key,
vip.UOM_KEY,
--DECODE ( from_uom_key,from_uom_key,vip.UOM_KEY,from_uom_key),

[Code]....

View 21 Replies View Related

SQL & PL/SQL :: Getting Back Whole Record Then Picking 1 Column?

Jul 22, 2010

I want a function that'll execute a query and return the whole table record then i need to somehow pick a column in that record and return the data in that column

So like

function something(p_param varchar2)
return table_record
something('blah).employee_number

where employee_number is a column in that table

View 3 Replies View Related

PL/SQL :: Only Display A Column Value One Time For A Record / Not A Static Value

Jan 7, 2013

I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.

select Date, Person, Language, Country
from TableATableA
Date            Person  Language   Country
01/25/2013       James   English
12/20/2012       James   English
US

[code]....

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







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