The webMethods Oracle Applications Adapter 10.7SC 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 40 predefined transaction services for Oracle Applications 10.7SC, representing 16 separate Oracle Applications modules. The following table lists and describes the Oracle Applications 10.7SC 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. | |
| Engineering | Engineering BOM (Outbound) | Retrieves to the webMethods Integration Server 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. | |
| 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 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. |
| Work in Progress | Open Move Interface | Imports moved items. |
| Open Resource Interface | Imports work-in-process (WIP) resource transactions. | |
| Order Management | Import Interface | Imports data into the Order Management table. |
| 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. |
| 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. | |
| 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 10.7SC Predefined Transaction Services User's Guide 6.0, which is provided as a PDF file in the IntegrationServerDirectory\packages\WmOACommon107SC\doc directory.
If the webMethods Oracle Applications Adapter 10.7SC 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 10.7SC Predefined Transaction Services 6.0 supports Oracle Applications version 10.7SC only.
For a complete list of the required software and hardware, see the webMethods Oracle Applications Adapter 10.7SC 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.