6 Replies Latest reply: Aug 3, 2012 10:49 AM by 796401 RSS

    Current_record_indicator invalid identifier

    780125
      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
          plzz help me...is the question not clear ?
          • 2. Re: Current_record_indicator invalid identifier
            Fahd.Mirza
            What's the version of your Windows and database?

            regards
            • 3. Re: Current_record_indicator invalid identifier
              Fahd.Mirza
              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
                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
                  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
                    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?