The webMethods Oracle Applications Adapter 11.5.9 Predefined Transaction Services 6.0 is an add-on product for use with the webMethods Oracle Applications Adapter 6.0 that enables you to easily integrate with a wide range of Oracle Applications modules and interfaces. These predefined transaction services are complete, ready-to-use integration flows. Not only do these flows provide services that operate on Oracle Applications, they also expose required service inputs and outputs and perform required webMethods-to-Oracle Applications/Oracle Applications-to-webMethods document mapping. In many cases, all you need to do to use a predefined transaction service is specify your Oracle Applications system connection information.
The webMethods Oracle Applications Adapter provides inbound (webMethods-to-Oracle Applications) and outbound (Oracle Applications-to-webMethods) predefined transaction services.
Predefined inbound transactions provide the following:
Predefined outbound transactions provide the following:
The webMethods Oracle Applications Adapter provides over 50 predefined transaction services for Oracle Applications 11.5.9, representing 19 separate Oracle Applications modules. The following table lists and describes the Oracle Applications 11.5.9 predefined transactions:
| OA Module | OA Interface | Description |
| Assets | Mass Additions | Creates assets automatically from other systems. |
| Open Budget | Executes flow services to map the incoming document to the interface table and inserts data into the interface table. | |
| Cash Management | Bank Reconciliation | Loads bank statements into the Cash Management module of Oracle Applications and reconciles the bank statements automatically. |
| General Ledger | Budget Upload Interface | Loads budgets to the Oracle Applications General Ledger budget interface tables. |
| GL Balances (Outbound) | Retrieves General Ledger (GL) Budget, Encumbrance, Actual, and Funds Available account balances. | |
| Journal (Outbound) | Retrieves Journal information (general, recurring, mass allocation, and reversing journal entries). | |
| Journal Import Interface | Inserts Journals into the General Ledger production tables. You can import Journals such as Accounting, Encumbrance, and Multi-currency. | |
| Payables | Open Payables Interface | Maps the incoming invoice document to the interface table data structure and inserts data into the invoice interface table. |
| Invoices (Outbound) | Retrieves new or changed invoice records. | |
| Payments/Checks (Outbound) | Retrieves AP payments that are set up in Oracle Applications Payables to record payment-related information. | |
| Vendors (Outbound) | Retrieves the list of new or changed vendors. | |
| Receivables | AR Transactions (Outbound) | Retrieves the list of new or changed AR Transactions. |
| Auto Invoice | Imports and validates transaction data from other financial systems and creates invoices, debit memos, credit memos, and on-account credits in Oracle Receivables. | |
| Customers (Outbound) | Retrieves the list of new or changed Customers. | |
| Customer Interface | Maps the incoming document to the interface table and inserts data into the interface table. | |
| Human Resource | Employees | Imports new and modified employee data into the Oracle Applications production tables. |
| BOM | Bills and Route | Updates and deletes manufacturing and engineering bills of material and product families. |
| BOM Revisions (Outbound) | Retrieves bills of material revisions from Oracle Manufacturing. | |
| BOM Routings (Outbound) | Retrieves information on the routing of parent, component, substitute items, and routing revisions. | |
| Manufacturing BOM (Outbound) | Retrieves information on parent, component, and substitute manufacturing bills of material items, as well as revisions. | |
| Cost Management | Periodic Cost Open Interface | Imports periodic costs for the first open period. |
| Engineering | Engineering BOM (Outbound) | Retrieves information on the parent, component, and substitute engineering bills of material items, as well as revisions. |
| Inventory | Customer Item Cross Reference | Imports Customer Item Cross-References into Oracle Inventory. |
| Customer Item Interface | Imports Customer Items into Oracle Inventory. | |
| Cycle Count Entries Interface | Imports new and modified cycle count entries into the Oracle Applications production tables. | |
| Item Category (Outbound) | Retrieves item category information. | |
| Items (Outbound) | Retrieves item information. | |
| On-hand quantity (Outbound) | Retrieves the on-hand quantities for a particular item. | |
| Open Item Interface | Imports items into Oracle Applications. | |
| Open Replenishment Interface | Imports replenishment requests from external systems, such as barcode applications. | |
| Open Transaction Interface | Imports transactions into Oracle Inventory. | |
| Master Scheduling | Open Forecast Interface | Imports forecast entries for existing forecasts and forecasting sets into the Oracle Master Scheduling/MRP Application. |
| Open Master Schedule Interface | Imports master schedules. | |
| Quality Collection | Import Interface | Adds new quality results to, or updates existing quality results in, the Oracle Applications Quality Data Repository. |
| Release Management | Demand Schedule Interface | Imports demand schedules. You can use Oracle Release Management to automate the management and reconciliation of customer inbound schedules, and to enable a rapid response for changing demand requirements. |
| Work in Progress | Open Move Interface | Imports moved items. |
| Open Resource Interface | Imports work-in-process (WIP) resource transactions. | |
| Work Order Interface | Imports planned orders, planned order update recommendations, and suggested repetitive schedules. | |
| Advanced Pricing | Price Request (Outbound) | Retrieves price information for orders. |
| Order Management | Import Interface | Imports data into the Order Management table. |
| Pick Confirm | Imports pick confirmations on Move Order Line Detail records. | |
| Sales Order (Outbound) | Retrieves sales order changes. | |
| Shipping | Pick Details (Outbound) | Retrieves information about the inventory transfer when the item is moved from one location to another. |
| Advance Shipping Notice (Outbound) | Retrieves advanced shipping notices. | |
| Purchasing | Open Purchasing Interface | Imports three types of Purchasing documents into the Oracle Applications Production tables: Standard Purchase Orders, Blanket Agreements, and Catalog Quotations. Handles multiple PO records in a single business document. |
| Open Receiving Interface | Imports receiving data. You can use the Open Receiving Interface for processing and validating receipt data from sources other than the Receipts window in Purchasing. | |
| Open Requisition Interface | Imports requisitions. You can load multiple types of requisition documents, such as Internal or Purchase, into Oracle Applications Production tables. | |
| Purchase Orders (Outbound) | Retrieves all approved PO data, and presents it in a logical structure (a business document) that can be sent to a trading partner. | |
| Product Content - Catalog (Outbound) | Retrieves the Supplier Product/Item Catalog information to locate items and their source information for the purpose of creating purchase order and requisition lines. | |
| Order Status (Outbound) | Retrieves the purchase order status. | |
| Request For Quote (Outbound) | Retrieves all new and changed active RFQ data. | |
| Suppliers (Outbound) | Retrieves new or changed active supplier data. | |
| Project Accounting | Labor | Imports expenditures from external cost collection systems. |
For details about these transactions, see the webMethods Oracle Applications Adapter 11.5.9 Predefined Transaction Services User's Guide 6.0, which is provided as a PDF file in the IntegrationServerDirectory\packages\WmOACommon1159\doc directory.
If the webMethods Oracle Applications Adapter 11.5.9 Predefined Transaction Services do not provide the predefined transaction service you need, or if you do not want to use a predefined transaction service as designed, you can use the webMethods Oracle Applications Adapter to build new services or update existing services. See the webMethods Oracle Applications Adapter User's Guide 6.0 for more information about creating and modifying services.
The webMethods Oracle Applications Adapter 11.5.9 Predefined Transaction Services 6.0 supports Oracle Applications version 11.5.9 only.
For a complete list of the required software and hardware, see the webMethods Oracle Applications Adapter 11.5.9 Predefined Transaction Services Installation Guide 6.0.
webMethods Administrator, webMethods Broker, webMethods Dashboard, webMethods Developer, webMethods Fabric, webMethods Glue, webMethods Installer, webMethods Integration Server, webMethods Mainframe, webMethods Manager, webMethods Mobile, webMethods Modeler, webMethods Monitor, webMethods Optimize, webMethods Portal, webMethods Trading Networks, webMethods Workflow, and the webMethods logo are trademarks of webMethods, Inc. "webMethods" is a registered trademark of webMethods, Inc.
All other marks are the property of their respective owners. Copyright © 2004 by webMethods, Inc. All rights reserved, including the right of reproduction in whole or in part in any form.