Home » Developer & Programmer » Forms » frm-40505 error
icon5.gif  frm-40505 error [message #183120] Wed, 19 July 2006 07:33 Go to next message
idraganj
Messages: 3
Registered: July 2006
Junior Member
I'm working in Designer 6i. I built a form based on a view. In my application I can see columns but when I try to run a query(F8) i get:

FRM-40505: ORACLE error: unable to perform query.

Cause: Processing error encountered. The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table.

I have all rights for tables that I'm using.

Does somebody know what could couse this error, thanks.


Re: frm-40505 error [message #183124 is a reply to message #183120] Wed, 19 July 2006 08:22 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
This is clearly a Forms question and as such should be asked in the proper Forum. Maybe you added a non-database field to the block but didn't change the properties for Database Item to No.
Re: frm-40505 error [message #183161 is a reply to message #183124] Wed, 19 July 2006 14:00 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Moved to Forms forum
Re: frm-40505 error [message #184551 is a reply to message #183120] Thu, 27 July 2006 00:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: frm-40505 error [message #184724 is a reply to message #184551] Thu, 27 July 2006 10:16 Go to previous messageGo to next message
idraganj
Messages: 3
Registered: July 2006
Junior Member
I did, thanks for asking. There was something wrong with my query.
Re: frm-40505 error [message #478766 is a reply to message #183120] Tue, 12 October 2010 07:53 Go to previous messageGo to next message
rverma64
Messages: 6
Registered: July 2007
Location: Gurgaon
Junior Member

Hi i have a error in AUtocreate folder

PO_REQUISITION_LINES_INQ_V.CATEGORY_ID =(SELECT CATEGORY_ID FROM MTL_CATEGORIES_B WHERE PO_REQUISITION_LINES_INQ_V.CATEGORY_ID=CATEGORY_ID AND SEGMENT1 LIKE 'INVENTORY%' AND STRUCTURE_ID=201
AND (SEGMENT2 NOT LIKE 'CONSUMABLES'
AND SEGMENT2 NOT LIKE 'FREIGHT')) and ( ((NVL(LINE_LOCATION_ID, -999) = -999 AND nvl(cancel_flag,'N')='N' AND nvl(reqs_in_pool_flag, 'Y') = 'Y' AND nvl(closed_code,'OPEN')!='FINALLY CLOSED' AND nvl(modified_by_agent_flag,'N')='N' AND source_type_code = 'VENDOR')) and (authorization_status = 'APPROVED') and (PO_REQ_LINES_AUTOCREATE_V.REQUISITION_HEADER_ID=428660))


error while executing is


ORA-00904: "PO_REQUISITION_LINES_INQ_V"."CATEGORY_ID": invalid identifier

--------------------------------------------------------------
FRM-40505: ORACLE error: unable to perform query

Can you please help

Regards,

Rajesh
Re: frm-40505 error [message #478790 is a reply to message #478766] Tue, 12 October 2010 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How does this reappear in Server Administration forum?
Re: frm-40505 error [message #478809 is a reply to message #478790] Tue, 12 October 2010 12:44 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Rajesh

ORA-00904: "PO_REQUISITION_LINES_INQ_V"."CATEGORY_ID": invalid identifier

--------------------------------------------------------------
FRM-40505: ORACLE error: unable to perform query

CATEGORY_ID is, probably, marked as a DATABASE ITEM but is not (so when Forms try to execute a query, can not because there's no such column in a table. Set the property to NO.


Michel: maybe someone moved it over there? If so, it wasn't me.
Re: frm-40505 error [message #479391 is a reply to message #478809] Sat, 16 October 2010 11:18 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi,

i have an exhaustive problem with this frm- 40405 too... Please have a look at the demonstration of my form and help me if somebody can:

actually there are a number of datablocks shown on different canvases.

in 1st canvas i have a non database data block containing a search mechanism (comprising radio groups (search by donor_registration_no, donor_name, donor_nic_no etc) and a text item associated with it). Database Data block property is set to NO

there is a database block DONOR_INFO subsequent to key_next_item of the previous block, showing a list of relevant search...

there is yet again another non database block containg buttons (donor_profile in detail and donation record).

when either of these buttons is pressed a new canvas is shown below containing relevant data in full detail.

this module is designed for searching purpose only. insertion is locked in all the blocks, updation only in DONOR_INFO block is also locked since it is aimed to show only a list of relevant search. details are shown in later data blocks where updation is allowed too...

the problem with this module is that, whenever i update any field in the DONOR_PROFILE or DONATION_RECORDS (data blocks) my form prompts the message "frm- 40405 No changes to apply". PLUS none of any other messages except this 40405 apears on the status bar on any event.

i have a similar PATIENT_SEARCHING_MODULE. that works all fine but this DONOR_SEARCHING_MODULE is not so

i tried a form level on-commit FORM_DDL ('COMMIT');

then i tried in when-new-form_instance :SYSTEM.MESSAGE_LEVEL:=25;

then i tried both but none of the try was fruitfull

if u people got any advice please help me with that...

regards...
Re: frm-40505 error [message #479400 is a reply to message #479391] Sat, 16 October 2010 12:24 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use display error on the run time help menu to see exactly what oracle thinks is the problem with the query.
Re: frm-40505 error [message #479404 is a reply to message #479391] Sat, 16 October 2010 13:28 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
shehpar wrote on Sat, 16 October 2010 18:18
i tried a form level on-commit FORM_DDL ('COMMIT');

Did you try
standard.commit;

Re: frm-40505 error [message #479438 is a reply to message #479404] Sun, 17 October 2010 01:11 Go to previous message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi all,

i found half solution to my problem myself...

actually the problem was something else... i was opening this form from another main_form via open_form() builtin. since open_form keepd both forms active so status bar was issueing frm- 40405 no changes to apply. this message was due for the main_form perhaps...

i open this module this way now: open_form ('C:\proj_modules\donor_searching_hamza', activate, session); and this solved 40405 thing...

but still other messges are not available... i wana have all the status bar messages, like i have in my other forms...

if somebody have any idea, about how to have all the conventional status bar messages please help me with that... i tried :SYSTEM.MESSAGE_LEVEL =5,10,15,20,25,30 one by one but it didnt help me..

regards...
Previous Topic: Custom Form
Next Topic: Launch Web Service Forms 6i C/S
Goto Forum:
  


Current Time: Fri Dec 09 00:15:10 CST 2016

Total time taken to generate the page: 0.12381 seconds