 frm-40505 error [message #183120] |
Wed, 19 July 2006 07:33  |
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  |
joy_division
Messages: 4963
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 #478766 is a reply to message #183120] |
Tue, 12 October 2010 07:53 |
|
|
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 #479391 is a reply to message #478809] |
Sat, 16 October 2010 11:18 |
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 #479438 is a reply to message #479404] |
Sun, 17 October 2010 01:11 |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
