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.
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.
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.
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
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.
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.
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.?
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?
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.
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.
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.
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.
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.
(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]....
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.
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:-
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
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
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.