Skip Headers
Oracle® Application Integration Architecture Oracle Financial Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide
Release 3.1

Part Number E23563-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

10 Performing an Initial Load

This chapter includes the following sections:

10.1 Initial Load of Currency Exchange Rates

The General Ledger application within Oracle E-Business Suite is responsible for maintaining and storing currency exchange rates. Currency Exchange Rates data should be loaded from the Oracle E-Business Suite Financials - General Ledger - to the Oracle Transportation Management (OTM). Existing currency exchange rates present in E-Business can be synchronized (initial load) to OTM using this process.

10.1.1 How to Start and Run Initial Load of Exchange Rates

To load the currency exchange rates initially from Oracle E-Business Suite to OTM:

  1. Contact your SOA Administrator and obtain the endpoint location of the process CurrencyExchangeListEbizJMSProducer.

    Note:

    If a web service is secured, enter credentials before invoking the web service.

  2. Open the end point.

    The system displays the parameters listed in Table 10-1:

    Table 10-1 Current Exchange Load Parameters

    Parameter Description

    from_currency

    xsd: string

    to_currency

    xsd: string

    from_date

    xsd: string

    to_date

    xsd: string

    conversion_rate_type

    xsd:string

    SystemID

    xsd: string

    from_currency

    xsd: string


    The from_date field is a mandatory field. If the to_date is not specified, it takes the current date as the TO DATE. The valid date format is YYYY-MM-DD (2008-02-09). The rest of the elements are optional. You can use those elements to limit the rates, which are required to be loaded from Oracle E-Business Suite to OTM. Use the appropriate date range based on the load of data and performance of the server.

    If a user defined conversion rate type must be loaded, provide the internal ID/number of the rate type in the parameter list.

  3. Click Invoke and the exchange rates within the input range specified are sent from Oracle E-Business into OTM.

10.2 Initial Load of Suppliers

Oracle E-Business Suite Accounts Payable is responsible for adding and maintaining the Supplier and Supplier Site Profiles. For this integration, the supplier information should be initially loaded or synchronized from Oracle E-Business Suite to OTM using this process.

10.2.1 How to Start and Run Initial Load of Supplier Parties

To start the initial load of the supplier parties:

  1. Contact your SOA Administrator and obtain the endpoint location of the process CurrencyExchangeListEbizJMSProducer.

    1. Login to Oracle Enterprise Manager Fusion Middleware Control (http://<soa_server_host>:<soa_server_port>/em).

    2. Click InitialLoadSupplierPartyListEbizAdapter.

    3. Click Test.

    4. Click Test WebService.

  2. Note:

    If a web service is secured, enter credentials before invoking the web service.

  3. Click the link to display the parameters listed in Table 10-2:

    Table 10-2 Current Exchange Load Parameters

    Parameter Description

    from_currency

    xsd: string

    to_currency

    xsd: string

    from_date

    xsd: string

    to_date

    xsd: string

    conversion_rate_type

    xsd:string

    SystemID

    xsd: string

    from_currency

    xsd: string


    Enter an appropriate value for the chunk size field based on the memory of the system, the number of suppliers present in the Oracle E-Business Suite for initial load. It is appropriate to give this value between 50 and 100 or even smaller based on the kind of supplier profiles existing in the system.

  4. Click Invoke.

    This starts the initial load of the suppliers from Oracle E-Business Suite to OTM.

10.2.1.1 Performance Tuning Parameters

In case of any issues during the initial load, these properties can be fine-tuned by referring to the SOA guide.

In the Fusion Middleware machine, change the domain level configurations as described below.

To fine tune the properties:

  1. Login into Oracle Enterprise Manager Fusion Middleware Control (http://<soa_server_host>:<soa_server_port>/em).

  2. Right-click SOA-infra, SOA Administration, Common Properties.

    You can change the Audit level to either Production or Off.

  3. Enable Capture Composite Instance State to see the instance state in the Oracle Enterprise Manager Fusion Middleware Control.

  4. Click More BPEL Configuration Properties.

  5. Right-click SOA-infra, SOA Administration, BPEL Properties.

Change SyncMaxWaitTime property based on your server performance. Provide a lesser value for the chunk size to run the initial load.

10.2.1.2 Alternative Option

An alternative approach to run the initial load of suppliers from Oracle E-Business into OTM is described below.

The initial load of supplier information from Oracle E-Business to OTM can also be done using these steps if the range of supplier IDs are known:

  1. Contact your SOA Administrator and obtain the endpoint location of the process SupplierPartyListEbizJMSProducer.

    1. Login to Oracle Enterprise Manager Fusion Middleware Control (http://:/em).

    2. Click SupplierPartyListEbizJMSProducer process.

    3. Click Test.

    4. Click Test WebService.

    Note:

    If a web service is secured, enter credentials before invoking the web service.

  2. Choose the operation as ProduceSupplierPartyABMInitLoad.

  3. Enter the data in From Vendor ID and To Vendor ID fields for which the data should be synchronized from Oracle E-Business Suite to OTM.

  4. Click Invoke.

    The suppliers present in Oracle E-Business Suite between the from and to values are synchronized to OTM.