Send this page to a colleagueTechnical information
The QuickAddress for Oracle E-Business Suite interface has been developed by Oracle Consulting. Learn more about:
System architecture
QuickAddress is available for the following environments:
- Forms 6i integration (Accounts receivable, Accounts payable,HR, TeleService and TeleSales)
- JSP integration (Sales on-line, iSupport, iStore) and
- OA Framework (HR Selfservice, iProcurement).
Forms integration
Set of integrations of a number of QuickAddress API products. These APIs are implemented as Unix shared object libraries, accessed from the Oracle 8i database using Oracle's remote procedure call functionality. A series of wrappers connect the PL/SQL data types used by Oracle to that of the C data types used by the QuickAddress APIs. Complete addresses are retrieved from a set of QuickAddress data files, which sit outside of the Oracle database. Quarterly updates can then be applied by replacing these data files with the most recent editions. The overall structure is outlined in the diagram below.
Using the Oracle Forms solution
-
QuickAddress functionality is activated via the 'Zoom' button as
shown below. The Zoom button is a standard icon on an Oracle
interface.
- The QuickAddress search interface is activated, and the user enters the address elements to be searched upon.
- Once a complete and verified address has been found, the user accepts the address before it is saved back into the Oracle interface.
Self Service integration
This integration has made use of the QuickAddress Pro World Web application. It is a middle-tier integration that utilizes web technologies as if Oracle were acting as a standard web site. When the user input form is called, the Application's 11i tier opens QuickAddress and displays it in a separate browser window.
Using the Oracle Self Service solution
-
QuickAddress functionality is activated via the 'Find Address'
button as shown above - this launches the QuickAddress Web
Interface.
- The user selects the relevant country data they wish to use, and is then shown the relevant optimal prompts.
- The user enters text into the search fields and selects 'Next' to initiate the search.
- Flattened pick lists display the results. Select the required addresses by double clicking on the item or via clicking on the select button against the item.
- The address is captured and pasted into the underlying screen.
Solution functionality
- Address data, GBR Names data and GBR Business data is available
- Single line and Typedown searching is available.
- Street, Organisation and PO Box Typedown functionality is available.
- Data sets can be selected via the Address Search UI in the standard way.
Solution deliverables
Forms integration
- QuickAddress product CD
- QuickAddress for Oracle product CD
- QuickAddress data CD(s)
Documentation
The following documentation is supplied as PDF documentation on the product CD:
- Installation Guide - for Forms and Self Service based Oracle Applications
- Technical Specification
- QuickAddress Product Manual
- Search tips
The following QuickAddress data documentation will be shipped:
- Country Information Guide
Installations
- Installs generally take one day
- Consultants from QAS or Oracle are available to conduct onsite installs
There are a number of access requirements on the day of the install; these include physical access to the required machine and the necessary user names and passwords to gain access to the relevant applications. Completing the installation will help to train technical staff in installing the product themselves.
Technical Support
- QAS offer support contracts to ensure timely resolution of support issues.
- Technical support is available over the telephone or on-site as necessary.