This discussion is archived
6 Replies Latest reply: Aug 3, 2012 8:49 AM by 796401 RSS

Current_record_indicator invalid identifier

780125 Newbie
Currently Being Moderated
when i presser SHIFT+CNTRL+E i got this error msg

SELECT ROW_ID,ORDER_ID,ORDER_LINE_NUM,ORDERED_QUANTITY,PRODUCT_DESCRIPTION,SUGGESTED_PRICE,PRODUCT_ID,UNIT_OF_MEASURE,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,GL_ACCOUNT_CC_ID,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CURRENT_RECORD_INDICATOR FROM dem_order_lines_v WHERE (ORDER_ID=:1)

ORA-00904: "CURRENT_RECORD_INDICATOR": invalid identifier


when i am trying to query the records its showing this error ..??

even after making the current record indicator's database item property setting to no ..

why its fetching current_record_indicator while querying ??

Plzzz help
  • 1. Re: Current_record_indicator invalid identifier
    780125 Newbie
    Currently Being Moderated
    plzz help me...is the question not clear ?
  • 2. Re: Current_record_indicator invalid identifier
    FahdMirza Oracle ACE
    Currently Being Moderated
    What's the version of your Windows and database?

    regards
  • 3. Re: Current_record_indicator invalid identifier
    FahdMirza Oracle ACE
    Currently Being Moderated
    Hi,
    Write your query like the following, and you would be fine:
    SELECT ROW_ID,ORDER_ID,ORDER_LINE_NUM, 
    ORDERED_QUANTITY, PRODUCT_DESCRIPTION, SUGGESTED_PRICE,PRODUCT_ID,UNIT_OF_MEASURE,
    LAST_UPDATE_DATE,LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,LAST_UPDATE_LOGIN, 
    GL_ACCOUNT_CC_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5, 
    ATTRIBUTE6,ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, 
    "CURRENT_RECORD_INDICATOR" FROM dem_order_lines_v WHERE (ORDER_ID=:1)
    regards
  • 4. Re: Current_record_indicator invalid identifier
    gdarling - oracle Expert
    Currently Being Moderated
    Does that column exist in the dem_order_lines_v table?

    Open SQLPlus and describe dem_order_lines_v

    Ora-904 occurs because the db cant find the column in your select list, perhaps because the column name is case sensitive, or perpaps it just doesnt exist. For example:
    SQL> desc dual;
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------
     DUMMY                                              VARCHAR2(1)
    
    SQL> select dummy from dual;
    
    D
    -
    X
    
    SQL> select bad_column_name from dual;
    select bad_column_name from dual
           *
    ERROR at line 1:
    ORA-00904: "BAD_COLUMN_NAME": invalid identifier
    Hope it helps,
    Greg
  • 5. Re: Current_record_indicator invalid identifier
    896107 Newbie
    Currently Being Moderated
    Hi
    I too got this error in the front end, though my form was compiling no absolutely no errors.
    And whoever i consulted said that this is some issue with the query I m trying to fetch.

    "ora-00904 current_record_indicator invalid identifier FRM-40505: Oracle unable to perform query"

    But the issue was with the directory where i was compiling my form.
    The compilation should be done on sever directory where one has all the PLLs copied/backed up.
    So, instead of compiling in resource folder (dint want to take any chance n mess that up), i created a seperate folder of mine, copied all the pll's there and put the .fmb file there.
    Then the compiled file worked fine.

    Regards
    Bimz
  • 6. Re: Current_record_indicator invalid identifier
    796401 Newbie
    Currently Being Moderated
    I got this error too on the form whenever I wanted to use Oracle EBS "Current Record Indicator" feature.
    I compiled on the server with all the pll form $AU_TOP/resource but the error persists.

    For those suggested to rewrite the query, this is related to Oracle Forms, the query is generated by the engine from the datablock definition.
    Oracle suggested to add a Current Record Indicator as standard user interface guidelines.

    I tried to read the documentations from Oracle about this but it is very vague, I followed what they asked without success.

    Any idea how to implement this "Current Record Indicator" feature properly in EBS?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points