•  webMethods Oracle Applications Adapter Documentation
  •  About This Help
    • Document Conventions
    • Online Information and Support
    • Data Protection
  •  webMethods Oracle Applications Adapter Installation and User’s Documentation
    •  About Oracle Apps Adapter
      • Overview of the Adapter
      • Architecture and Components
      • Package Management
      •  Adapter Connections
        • Using the JDBC Driver to Connect to Oracle Applications
        • Transaction Management of Oracle Apps Adapter Connections
        •  Connection Pools
          • Run-Time Behavior of Connection Pools
        • Built-In Services For Connections
        • Changing the Connection Associated with an Adapter Service or Polling Notification at Design Time
        • Changing the Connection Associated with an Adapter Service at Run Time
      • Transaction Definitions
      •  Adapter Services
        • Adapter Service Templates
        • Predefined Transaction Services
      • Adapter Notifications
      • Using Version Control Systems to Manage Adapter Elements
      • Optimize Infrastructure Data Collector Support for Oracle Applications Adapter
      • Viewing the Adapter's Update Level
      • Controlling Pagination
    •  Installing Oracle Apps Adapter
      • Overview
      • Requirements
      • Installing Oracle Apps Adapter
      • Uninstalling Oracle Apps Adapter
    •  Package Management
      • Overview
      •  Oracle Apps Adapter Package Management
        • Package Dependency Requirements and Guidelines
        •  Enabling and Disabling Packages
          • Enabling Packages
          • Disabling Packages
        •  Loading, Reloading, and Unloading Packages
          • Reloading Packages Manually
          • Unloading Packages
        • Setting Package Dependencies
      • Group Access Control
      •  Oracle Apps Adapter in a Clustered Environment
        • What is webMethods Integration Server Clustering?
        • Configuring Oracle Apps Adapter
        • Replicating Packages to Integration Servers
        • Disabling the Redirection of Administrative Services
        •  Clustering Considerations and Requirements
          • Requirements for Each Integration Server in a Cluster
          • Considerations When Installing Oracle Apps Adapter Packages
          • Considerations When Configuring Connections with Connection Pooling Enabled
        • Scheduling Service Invocations in a Clustered Environment
        •  Configuring Polling Notifications When Integration Server Uses Terracotta
          • Before Configuring Polling Notifications to Execute via Scheduled Tasks
          • Configuring Polling Notifications to Execute via Scheduled Tasks
    •  Adapter Connections
      • Overview
      • Before Configuring or Managing Adapter Connections
      • Setting Up Your Adapter's Environment
      • Configuring Adapter Connections
      • Dynamically Changing a Service's Connection at Run Time
      • Enabling Adapter Connections
      •  Viewing Adapter Connection Parameters
        • Viewing Connection Parameters Using Integration Server Administrator
        • Viewing Connection Parameters Using Designer
      • Editing Adapter Connections
      • Copying Adapter Connections
      • Deleting Adapter Connections
      • Disabling Adapter Connections
    •  Transaction Definitions
      • Overview
      • Before Working with Transaction Definitions
      •  Importing Transaction Definitions
        • Importing Transaction Definitions One at a Time Using Integration Server Administrator
        • Importing All Transaction Definitions Using Designer
      • Exporting Transaction Definitions
      • Creating Integration Server-to- Oracle Applications Transaction Definitions
      • Creating Oracle Applications -to-Integration Server Transaction Definitions
      • Editing Integration Server-to- Oracle Applications Transaction Definitions
      • Editing Oracle Applications -to-Integration Server Transaction Definitions
      • Deleting Transaction Definitions
      •  Working with SQL Trees in Oracle Applications -to-Integration Server Transactions
        • SQL SELECT Statement Syntax
        • Stored Procedure Syntax
        •  SQL Tree Example
          • Parent Level Alias
          • Child Alias 1
          • Child Alias 2
          • Results
    •  Adapter Services
      • Overview
      • Before Configuring or Managing Adapter Services
      • Using Oracle Apps Adapter Services
      • Configuring Insert SQL Services
      • Configuring Compound Select SQL Services
      •  Configuring Simple SQL Services
        • Acknowledge Services
        • Error Services
      • Testing Adapter Services
      • Viewing Adapter Services
      • Editing Adapter Services
      • Deleting Adapter Services
      •  Enabling Automatic Data Validation
        • For a Single Adapter Service
        • For All Adapter Services
      •  Reloading Adapter Values
        • For a Single Adapter Service
        • For All Adapter Services
    •  Adapter Notifications
      • Overview
      • Before Configuring or Managing Notifications
      • Configuring Notifications
      • Managing Polling Notifications
      • Exporting Configured Adapter Notifications
      • Viewing Notifications
      • Editing Notifications
      • Deleting Notifications
      •  Validating Adapter Notification Values
        • For a Single Adapter Notification
        • For All Values in Adapter Notifications
      •  Reloading Adapter Values
        • For a Single Adapter Notification
        • For All Adapter Notifications Automatically
    •  Logging and Exception Handling
      • Overview
      •  Adapter Logging Levels
        • Configuring Adapter Logging Levels
      • Oracle Apps Adapter Message Logging
      • Oracle Applications Error Handling
      • Oracle Apps Adapter Error Codes
    •  Built-In Transaction Management Services
      •  Transaction Management Overview
        • Transactions
        •  Implicit and Explicit Transactions
          • Implicit Transactions
          • Explicit Transactions
      • Changing the Integration Server Transaction Timeout Interval
  •  webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation
    •  Adapter Services
      • Overview
      • Transaction Definitions
      • Adapter Services
      •  Database Scripts
        • Installing Service Components on the Oracle Applications Database
        • Uninstalling Service Components from the Oracle Applications Database
      • Built-In Utility Services
      • Transaction Processing
      •  Considerations When Using Transactions
        • Considerations When Using Oracle Applications-to-IS Transactions
        • Considerations When Using IS-to-Oracle Applications Transactions
        • Considerations for Multiple Organizations
        • Considerations for webMethods Clients
        •  Database Connection Management
          • Logging Into and Out of an Oracle Applications Instance
    •  Transaction Definition (IS-to-Oracle Applications 11.5)
      •  Overview
        • Transaction Overview
      • APInvoices
      • ARAutoInvoice
      • ARCustomers
      • INVCustomerItemCrossRef
      • INVCustomerItems
      • INVItems
      • OEOrderImport
      • PODocuments
      • POReceiving
      • PORequisitions
      • PORescheduleRequisitions
    •  Transaction Definitions (IS-to-Oracle Applications 11.0)
      •  Overview
        • Transaction Overview
      • APInvoiceOpen
      • ARCustomers
      • INVItems
      • INVCustomerItemsCrossReference
      • INVOpenTransactions
      • INVCustomerItems
      • OEOrderImport
      • PODocuments
      • POReceiving
      • PORequisitions
      • PORescheduleRequisitions
    •  Transaction Definitions (Oracle Applications 11.0-to-IS)
      •  Overview
        • Transaction Overview
      • InvoiceOutbound
      • PurchaseOrderChange
      • PurchaseOrderNew
    •  Transaction Definitions (IS-to-Oracle 10.7SC)
      •  Overview
        • Transaction Overview
      • APInvoice
      • ARCustomers
      • INVDemand
      • INVItems
      • INVOpenTransactions
      • INVReplenishment
      • OEOrderImport
      • OEShipConfirm
      • PORequisitions
      • PORescheduleRequisitions
    •  Transaction Definitions (Oracle Applications 10.7SC-to-IS)
      • Overview
      • AdvanceShipNotice
      • InvoiceOutbound
      • PurchaseOrderChange
      • PurchaseOrderNew
    •  Built-In Utility Services
      • pub.adapter.wmoa:deleteAllTransactions
      • pub.adapter.wmoa:importAllTransactions
  •  webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation
    •  Overview
      •  Overview
        • Predefined Transaction Service Packages
        • Service Types
        • Packaging Structure
        • Document and Service Locations
        • Transaction Definitions
        • Updating Transaction Definitions
        • Database Scripts
        • Before Installing Components for Predefined Transaction Services on the Oracle Applications Database
        • Installing Components for Predefined Transaction Services on the Oracle Applications Database
        • Removing Components for Predefined Transaction Services from the Oracle Applications Database
        • Business Documents
      •  Receive Services
        • Overview of Receive Service Transaction Processing
        • Using Receive Services
        •  Optimizing Receive Services
      •  Query Services
        • Overview of Query Service Transaction Processing
        • Using Query Services
      •  Send Services
        • Overview of Send Service Transaction Processing
        • Using Send Services
        • Using Send Services in Debug Mode
        • Custom Tables Used with Send Services
    •  Installing and Uninstalling Predefined Transaction Service
      • Overview
      • Requirements
      • Installing the Predefined Transaction Services
      • Uninstalling Predefined Transaction Services
    •  Financial Predefined Transaction Services
      • Overview
      • Query Accounts Payable Invoice Service
      • Query Accounts Payable Payment Service
      • Query Accounts Receivable Transaction Service
      • Query Customer Service
      • Query General Ledger Balance Service
      • Query Journal Service
      • Query Vendor Service
      • Receive Accounts Payable Invoice Service
      • Receive Auto Invoice Service
      • Receive Bank Statement Service
      • Receive Customer Service
      • Receive FA Budget Service
      • Receive General Ledger Budget Service
      • Receive Journal Service
      • Receive Mass Additions Service
      • Send Accounts Payable Invoice Service
      • Send Accounts Payable Payment Service
      • Send Accounts Receivable Transactions Service
      • Send Customer Service
      • Send Journal Service
      • Send Vendor Service
    •  Human Resource Predefined Transaction Services
      • Overview
      • Receive Employee Service
    •  Manufacturing Predefined Transaction Services
      • Overview
      • Query BOM Revision Service
      • Query BOM Routing Service
      • Query Engineering BOM Service
      • Query Item Service
      • Query Item Category Service
      • Query Manufacturing BOM Service
      • Query On-Hand Quantity Service
      • Receive Bills and Route Service
      • Receive Customer Item Service
      • Receive Customer Item Cross Reference Service
      • Receive Cycle Count Entry Service
      • Receive Demand Schedule Service
      • Receive Forecast Service
      • Receive Inventory Transaction Service
      • Receive Item Service
      • Receive Master Schedule Service
      • Receive Move Transaction Service
      • Receive Periodic Cost Service
      • Receive Quality Collection Service
      • Receive Replenishment Service
      • Receive Resource Transaction Service
      • Receive Work Order Service
      • Send Engineering BOM Service
      • Send Item Service
      • Send Manufacturing BOM Service
    •  Order Management Predefined Transaction Services
      • Overview
      • Query Advanced Shipping Notice Service
      • Query Pick Detail Service
      • Query Price Request
      • Query Sales Order Service
      • Receive Pick Confirm Service
      • Receive Sales Order Service
      • Send Advance Shipping Notice Service
      • Send Pick Detail Service
      • Send Sales Order Service
    •  Procurement Predefined Transaction Services
      • Overview
      • Query Product Catalog Service
      • Query Purchase Order Service
      • Query Purchase Order Status Service
      • Query Request For Quotation Service
      • Query Supplier Service
      • Receive Purchase Order Service
      • Receive RCV Service
      • Receive Requisition Service
      • Send Purchase Order Service
      • Send Request For Quotation Service
      • Send Supplier Service
    •  Project Predefined Transaction Services
      • Overview
      • Receive Labor Service
• Copyright

webMethods Oracle Applications Adapter Documentation

Copyright