Developing OTDs for Application Adapters

Select Oracle Applications Module

Select the type of Oracle Applications Module you want included in the OTD.

ProcedureTo Select the Oracle Applications Module

  1. In the Select Oracle Applications Module dialog box (shown below), select the Business Function and Module and choose whether to use fully-qualified names and to replace existing stored procedures.

    Select Database Objects

    Module Information 

    Description 

    Business Function 

    Currently Financial and Manufacturing are the only supported business functions. 

    Module 

    The available modules in the Financial business function are: 

    • Auto Invoice

    • Auto Lock

    • Bank Statement

    • Budget

    • Customers

    • Daily Rates

    • Fixed Assets Categories

    • Fixed Assets Mass Additions

    • Journal

    • Payable

      The available modules in the Manufacturing business function are:

    • Customer Item

    • Customer Item Cross-Reference

    • Cycle Count Entries

    • Item Import

    • Item Transactions

    • Order Requisition

    • Order Import

    • Order Receiving

    • Replenishment

    Use fully-qualified names in the Java code 

    Specifies whether the generated Java code uses fully-qualified names. 

    Replace Existing Stored Procedures 

    Specifies to replace any existing stored procedures or stop the wizard if any stored procedures exist. You must select this option in order to continue with the wizard. 

    Take care to back up any stored procedures you have modified before continuing with this wizard. 


    Note –

    A set of stored procedures are installed with the Oracle Applications Adapter. Unless these stored procedures are somehow deleted, the only way to create the OTD is by selecting Replace Existing Stored Procedures, otherwise, the existing stored procedures are not overwritten, an error appears, and the wizard stops.


  2. Click Next to continue.

    The Specify the OTD Name window appears.