This content has been marked as final. Show 6 replies
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)
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:
Hope it helps,
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
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.
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?