webMethods Oracle Applications Adapter 12.0.6 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 12.0.6, representing 19 separate Oracle Applications modules. The following table lists and describes the Oracle Applications 12.0.6 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 12.0.6 Predefined Transaction Services User's Guide 6.0, available from the Software AG Documentation Web site http://documentation.softwareag.com/.
If the webMethods Oracle Applications Adapter 12.0.6 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 12.0.6 Predefined Transaction Services 6.0 supports Oracle Applications version 12.0.6 only.
For a complete list of the required software and hardware, see the webMethods Oracle Applications Adapter 12.0.6 Predefined Transaction Services Installation Guide 6.0.
Copyright © 2009 Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, United States of America, and/or their licensors.
The name Software AG, webMethods, and all Software AG product names are either trademarks or registered trademarks of Software AG and/or Software AG USA, Inc. and/or their licensors. Other company and product names mentioned herein may be trademarks of their respective owners.
Use of this software is subject to adherence to Software AG's licensing conditions and terms. These terms are part of the product documentation, located at http://documentation.softwareag.com/legal/ and/or in the root installation directory of the licensed product(s).
This software may include portions of third-party products. For third-party copyright notices and license terms, please refer to "License Texts, Copyright Notices, and Disclaimers of Third Party Products." This document is part of the product documentation, located at http://documentation.softwareag.com/legal/ and/or in the root installation directory of the licensed product(s).