Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Application Extension (Zoom)
Hello Gurus,
I have a basic question on Zooms. Following is the scenario. I have to zoom from a Fixed Assets Form to Accounts Payables form. The purpose of this zoom is to get Invoice Details tied to an Asset. So I zoom from FA form passing in the parameter 'invoice number' to the AP form where this AP form accepts the 'invoice number' parameter and queries the underlying view on this 'invoice number'.
Fixed Assets Accounts Payables ------------ ----------------- Form FAXASSET APXIWALL Block INVOICES INVOICE Param invoice_number invoice_num
So I have modified the AP form APXIWALL and included the parameter
'invoice number' as a varchar2(225).
Modified the WHERE clause for the target block 'INVOICE' so it includes
'invoice number' in its query condition.
Modified the 'WHEN_NEW_FORM_INSTANCE' of the target form so it would run
the query if it had been called with 'invoice number' parameter.
And also I modified the 'custom.pll' to make the Zoom_Available and called
fnd_execute.function to invoke the target APXIWALL form with
'invoice_number' parameter.
All the programs compile and the form APXIWALL is generated without problem.
I have included the function/form 'AP_APXIWALL' in FA so the function is available from FA menu.
But when I try to Zoom, I get the following error:
FRM-47023: No such parameter named 'G_QUERY_FIND' exists in form APXIWALL. FRM-47023: No such parameter named 'invoice_number' exists in form APXIWALL.
This Zoom was working fine when I first created it weeks ago. During the past few weeks the we applied patches to the AP(K) and PA(A) modules and since then I have been having this problem.
I was hoping that someone had already experienced this problem before and would be able to help me. Also if there is some documentation about what this 'G_QUERY_FIND' is and how it is supposed to be used, please let me know.
Thank You,
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Sep 26 1998 - 01:01:22 CDT
![]() |
![]() |