Help New Financials Sysadmin set up a Zoom?

Hi!

I hope that you can help me set up this Zoom. Our usual consultant from Oracle is some where else (covering for his boss who has had an accident) so I can't reach him. Called Oracle Customer Support but Sharon is making a field call to another customer and BoonLong is on leave. So...you're elected!

Application: Oracle Financials 9.4/Inventory Platform: Solaris 2.2

I Want To:

Set up a zoom from: Form "Receive Purchase Orders" Zone "Items"

              to : Form "View Item Quantities"

I have set up the following steps:

StartZoom(Once, Initially) Sequence 1

EXEMACRO EXETRG FND_EXEQRY; Query(Always) Sequence 1

EXEMACRO COPY SOURCE:PO_LINE_ITEMS.PART_NUMBER          INTO DEST:INVENTORY_ITEM.SEGMENT; I can successfully zoom to the target form, but I can't get the query to run. i.e. in the target form I get a blank row waiting for me to key in a query and execute (F2)

Note: I have absolutely no experience on SQL*FORMS and all I have to go on is the example text in the online help. The answer is probably very obvious, but not to me :-(

Philip

--
+---------------------------------+-------------------------------------------+


|Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance |

|Tasek Cement Berhad              |  to persons living or dead is completely  |

|P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article |

|Voice: +605-551-011              |    has asserted its moral right to be     |


|  Fax: +605-566-142              |          identified as the author.        |


+-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+