Skip Headers
Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations
Release 11.5

E40086-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

30 Configuring and Deploying the LSP Financial Mgmt: OTM - EBS PIP

This chapter discusses how to configure and deploy the Oracle Financial Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite (LSP Financial Mgmt: OTM - EBS PIP).

This chapter includes the following sections:

30.1 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of the LSP Financial Mgmt: OTM - EBS PIP. Enter the details of the LSP Financial Mgmt: OTM - EBS PIP screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

30.1.1 PIP Server Details Screen

All artifacts associated with the PIP infrastructure components deploy to the PIP server. This screen contains the following fields:

Table 30-1 PIP Server Details Screen Fields

Field Description

Admin Host Name

Specifies where the admin server resides. This can be a remote server or the same system where the AIA Pre-Built Integrations Installer is launched. Example: server1.company.com.

The Admin Host Name is _________________________________

Admin Port

This is the port number on which the Weblogic Admin server is started. To find this value contact the WebLogic administrator. Example: 7001.

The Admin Port is _____________________________________

Domain Name

This is WebLogic server domain corresponding to the Admin Server. Example: domain1

The Domain Name is _______________________________

Admin User

This value is the WebLogic admin user name. To find this value contact your WebLogic administrator.

The Admin User is __________________________________

Admin Password

This value is the WebLogic admin password. To find this value contact your WebLogic administrator.

The password is _____________________________________

Managed Server

After you enter the Admin Host Name, Admin Port and Admin User, this field populates with managed servers for the domain. Select the managed server from the list. If you are deploying the PIP to a SOA cluster, you should select the cluster name in this field.

The Managed Server is _______________________________

Managed Port

This field is automatically updated after you select the managed server. If you have configured a SOA Cluster, the SOA Cluster port appears in the list.


30.1.2 Oracle E-Business Suite Server Details Screen

Use this screen to enter details related to your Oracle E-Business Suite server instance.

The screen contains the following fields:

Table 30-2 Oracle E-Business Suite Server Details Screen Fields

Field Description

E-Business Suite Host Name

Specifies the fully qualified system name of the Oracle E-Business Suite application. Example: example1.corp.oracle.com.

E-Business Suite Host Name is ___________________________

E-Business Suite Port

This value is the Oracle E-Business Suite application port. To find this value, contact your administrator. Example: 8024.

E-Business Suite Port is _______________________________

E-Business Suite User Name

To find this value, contact your administrator.

E-Business Suite User Name is ___________________________

E-Business Suite Password

To find this value, contact your administrator.

E-Business Suite Password is ____________________________

Workflow Business Event System Name

This is the Workflow Business Event System Name of E-Business Suite Server. For example: server2.xyz.com. To find this value, contact your administrator.

Workflow Business Event System Name is __________________

E-Business suite version

This is the version of the E-Business Suite Application.


30.1.3 Oracle E-Business Suite Database Details Screen

Use this screen to enter details related to your Oracle E-Business Suite database instance.

The screen contains the following fields:

Table 30-3 Oracle E-Business Suite Database Details Screen Fields

Field Description

E-Business Suite Database Host

Specifies the system name. To find this value, contact the database administrator. Example: server1.oracle.com.

E-Business Suite Database Host is ________________________

E-Business Suite Database Port

To find this value, contact the database administrator. Example: 1521.

E-Business Suite Database Port is _____________________

E-Business Suite Database Username

To find this value, contact the database administrator. Example: apps.

E-Business Suite Database Username is ___________________

E-Business Suite Database Password

To find this value, contact the database administrator.

E-Business Suite Database Password is ___________________

E-Business Suite Database SID (System ID)

To find this value, contact the database administrator. Example: orcl.

E-Business Suite Database SID is ________________________

Database Schema

To find this value, contact the database administrator. Example: server1.

Database Schema is __________________________________

Note: All the database credentials are used for creating the connection pool URL and data source URLs.


30.1.4 Oracle OTM Server Details Screen

Use this screen to enter details related to your OTM server instance.

The screen contains the following fields:

Table 30-4 Oracle OTM Server Details Screen Fields

Field Description

OTM Host name

Specifies the system name of the OTM application. For example: example1.corp.oracle.com. To find the value, contact your administrator.

OTM Host name is _________________________________

OTM Http Port

This value is the OTM Web Service port. For example: 8024. To find the value, contact your administrator.

OTM Port is _________________________________

OTM User Name

This is the user name for OTM application. To find the value, contact your administrator.

OTM Username is _________________________________

OTM Password

This is the password for OTM application. For example: welcome. To find the value, contact your administrator.

OTM Password is ________________________________

OTM System Name

This is the system name for the OTM application. To find the value, contact your administrator. For example: http://<server name.example.com>:<port_no>

OTM System Name is __________________

OTM System Version

This is the version of the OTM Application like 5.5,6.0.

OTM System Version is ________________


30.1.5 Oracle OTM Database Details Screen

Use this screen to enter details related to your OTM database instance.

The screen contains the following fields:

Table 30-5 Oracle OTM Database Details Screen Fields

Field Description

OTM Database Host

Specifies the system name. For example: example1.corp.oracle.com. To find the value, contact your database administrator.

OTM Database Host is ______________________________

OTM Database Port

This is the Database port for OTM application. For example: 8024. To find the value, contact your database administrator.

OTM Database Port is ______________________________

OTM Database Username

This is the Database user name for OTM application. For example: apps. To find the value, contact your database administrator.

OTM Database Username is _______________________

OTM Database Password

This is the password for Database Password user. For example: apps. To find the value, contact your database administrator.

OTM Database Password is _________________________

OTM Database System ID (SID)

This is the Database SID for OTM application. For example: orcl. To find the value, contact your database administrator.

OTM Database SID is _________________________________


30.2 Configuring and Deploying the LSP Financial Mgmt: OTM - EBS PIP

This section discusses the PIP configuration and deployment process. There are two steps:

  1. Configure your PIP using the deployment DCW.

  2. Deploy the PIP to the Fusion Middleware server.

30.2.1 Configuring the LSP Financial Mgmt: OTM - EBS PIP

The screens that appear prompt you to enter the data that is required for successful configuration of the LSP Financial Mgmt: OTM - EBS PIP. Keep the completed worksheets of the LSP Financial Mgmt: OTM - EBS PIP screens ready before you launch the DCW.

Note:

If you are harvesting content to OER, perform the first three steps. Else start from step 4.

To configure the LSP Financial Mgmt: OTM - EBS PIP:

  1. Navigate to <MiddleWare_HOME>/user_projects/domains/<soa_domain_name>/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.

  2. Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".

  3. Restart the server.

  4. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  5. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh for Linux based systems and aiaconfig.bat for Microsoft Windows.

    This launches the AIA DCW.

  6. Click Next.

  7. Select the LSP Financial Mgmt: OTM - EBS PIP

  8. Click Next.

30.2.1.1 Specify PIP Server Details

To specify PIP Server details:

  1. Enter information related to your PIP server in the PIP Server Details screen.

  2. Click Next.

30.2.1.2 Specify Oracle E-Business Suite Server Details

To specify Oracle E-Business Suite Server details:

  1. Enter information about your E-Business Suite Server in the E-Business Suite Server Details screen.

  2. Click Next.

30.2.1.3 Specify Oracle E-Business Suite Database Details

To specify Oracle E-Business Suite Database details:

  1. Enter information about your E-Business Suite Database in the E-Business Suite Database Details screen.

  2. Click Next.

30.2.1.4 Specify Oracle OTM Server Details

To specify Oracle OTM Server details:

  1. Enter server information about Oracle OTM in the Oracle OTM Server Details screen.

  2. Click Next.

30.2.1.5 Specify Oracle OTM Database Details

To specify Oracle OTM Database details:

  1. Enter information about your Oracle OTM Database in the Oracle OTM Database Details screen.

  2. Click Next.

30.2.1.6 Complete Configuration

To complete configuration:

  1. Review the configuration information on the Configuration Summary screen.

    Note:

    If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.

    You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the PIP. You can configure using the steps described in Section 30.2.2, "Configuring using the Response File". Click Save Response File and save the response file with the name and location of your choice.

  2. Click Configure to accept the configuration.

    The system displays progress of the configuration in the Configuration Progress screen.

    The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in Configuration Progress screen.

  3. When the configuration process completes without errors, the AIA DCW displays the Configuration Complete screen.

  4. Click Finish to close the DCW.

30.2.2 Configuring using the Response File

To configure using the response file:

  1. Open the response file.

    When you create a response file through OUI, passwords get stored as <SECURE>.

  2. Replace the password fields with actual passwords in the response file.

  3. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  4. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name> for Linux based systems and aiaconfig.bat <Response File Location and Name> for Microsoft Windows.

30.2.3 Deploying the LSP Financial Mgmt: OTM - EBS PIP

To deploy the PIP to Fusion Middleware server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Note:

    When you copy and paste the command in the command line, ensure that there is space between .xml and -. Ensure that there is space between these two when you run undeployment command too.

    Table 30-6 Deployment Commands for the LSP Financial Mgmt: OTM - EBS PIP

    Platform Deployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancialsDP.xml 
    -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancialsSupplementaryDP.xml 
    -DDeploymentPolicyFile=<AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancialsConditionalPolicy.xml 
    -l <AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancials.log
    

    Microsoft Windows

    ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancialsDP.xml 
    -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancialsSupplementaryDP.xml 
    -DDeploymentPolicyFile=<AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancialsConditionalPolicy.xml 
    -l <AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancials.log
    

    Note:

    In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the PIPs are not displayed.

  3. Review the log file in the location specified in the command to verify successful deployment.

Oracle AIA ships artifacts in AIA Lifecycle Workbench which can be used in your integrations. These artifacts are created using FMW technologies such as BPEL and Mediator and are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator, AIA Deployment Driver (ADD). These are called native artifacts and they include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These artifacts can be modified or new natively supported artifacts can be added using the AIA Lifecyle Workbench and a BOM.xml file can be generated.

AIA PIP development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require artifacts such as, Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.

For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".

30.3 Performing Postdeployment Configurations

You can edit existing csf-key or create new csf-key and configure flows to use the modified/new csf-key.

To edit existing csf-key or create new csf-key:

  1. Log in to Oracle Enterprise Manager Fusion Middleware Control (http://<server_host>:<server_port>/em).

  2. Right click WebLogic Domain and navigate to <your_domain>, Security, and select Credentials.

  3. Expand oracle.wsm.security and click OTM_DOMAIN.

  4. Edit existing csf-key credentials or create new csf-key with new credentials.

To configure flows to use new csf-key:

  1. Log in to Oracle Enterprise Manager Fusion Middleware Control (http://<server_host>:<server_port>/em).

  2. Click the process name which is invoking OTM Webservice based on the flow.

  3. Click the corresponding Reference under the Services and References section. (use the security exceptions table in the Section 30.4.1, "Validating Security Policies" section to find the References)

  4. Click the Policies and select oracle/wss_http_token_client_policy.

  5. Update the csf-key value under Security Configuration Details tab and save the changes.

30.4 Verifying Deployment

To verify the LSP Financial Mgmt: OTM - EBS PIP deployment:

  1. Open the log files from the following location and look for warnings and error messages:

    • For Linux, Solaris SPARC, HP-UX and IBM AIX Based Systems: Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify that the PIP is successfully installed.

    • For Microsoft Windows: Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify that the PIP is successfully installed.

  2. Confirm that JMS Queues are created:

    1. Navigate to the WLS Console (http:// name>:<port number>/console/).

    2. Log in with the server admin user name. For access details, contact the system administrator

    3. Navigate to Services, Messaging, JMS Modules, AIAJMSModule for the following Queue Names

    • AIA_EbizSupplierPartyJMSQueue

    • AIA_EbizCurrencyExchangeJMSQueue

  3. Confirm that the LSP Financial Mgmt: OTM - EBS PIP services were installed.

    1. Navigate to the Oracle Enterprise Manager Fusion Middleware Control (http://<server name>:<port number>/em/).

    2. Log in with the server admin user name. For access details, contact the system administrator.

    3. Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:

    • AccountingEntryEBS

    • AccountingEntryResponseEBS

    • CreateAccountingEntryListEbizDBAdapter

    • CreateAccountingEntryListEbizProvABCSImpl

    • CreateAccountingEntryListLogisticsAQConsumer

    • CreateAccountingEntryListLogisticsReqABCSImpl

    • CreateInvoiceListEbizAppsAdapter

    • CreateInvoiceListEbizProvABCSImpl

    • CreateInvoiceListLogisticsAQConsumer

    • CreateInvoiceListLogisticsReqABCSImpl

    • CreatePayableInvoiceListEbizDBAdapter

    • CreatePayableInvoiceListEbizProvABCSImpl

    • CreatePayableInvoiceListLogisticsAQConsumer

    • CreatePayableInvoiceListLogisticsReqABCSImpl

    • CurrencyExchangeEBS

    • CurrencyExchangeListEbizJMSConsumer

    • CurrencyExchangeListEbizJMSProducer

    • CurrencyExchangeResponseEBS

    • CustomerPartyEBSV2

    • CustomerPartyResponseEBSV2

    • InitialLoadSupplierPartyListEbizAdapter

    • InvoiceEBS

    • InvoiceResponseEBS

    • MergeAccountEbizEventConsumer

    • MergeAccountEbizReqABCSImpl

    • MergeCustomerPartyListLogisticsProvABCSImpl

    • MergePartyEbizEventConsumer

    • MergePartyEbizReqABCSImpl

    • PayableInvoiceEBS

    • PayableInvoiceResponseEBS

    • QueryCustomerPartyEbizAdapter

    • QueryCustomerPartyListEbizCreateAdapter

    • QueryCustomerPartyListEbizUpdateAdapter

    • QueryMergeAccountEbizAdapter

    • QueryMergeOrgCustEbizAdapter

    • QueryPartyMergeEbizAdapter

    • SupplierPartyEBS

    • SupplierPartyListEbizJMSConsumer

    • SupplierPartyListEbizJMSProducer

    • SupplierPartyResponseEBS

    • SyncCurrencyExchangeListEbizAdapter

    • SyncCurrencyExchangeListEbizReqABCSImpl

    • SyncCurrencyExchangeListLogisticsProvABCSImpl

    • SyncCustomerPartyListEbizEventConsumer

    • SyncCustomerPartyListEbizReqABCSImpl

    • SyncCustomerPartyListLogisticsProvABCSImpl

    • SyncSupplierPartyListEbizAdapter

    • SyncSupplierPartyListEbizReqABCSImpl

    • SyncSupplierPartyListLogisticsProvABCSImpl

    • TransformAppContextEbizService

    • UpdateAccountingEntryListEbizXref

    • UpdateInvoiceListEbizXref

    • UpdatePayableInvoiceListEbizXref

  4. LSP Financial Mgmt: OTM - EBS PIP and LSP Order Mgmt: OTM - EBS - Siebel CRM PIP use the same CustomerPartyEBSV2.

    When you install the Fleet PIPs, if LSP Financial Mgmt: OTM - EBS PIP is installed after LSP Order Mgmt: OTM - EBS - Siebel CRM PIP, routing rules pertaining to Customer flow of LSP Financial Mgmt: OTM - EBS PIP do not appear on the Oracle Enterprise Manager Fusion Middleware Control for CustomerPartyEBSV2. In this case, routing rules pertaining to the SyncCustomerPartyListLogisticsProvABCSImpl and MergeCustomerPartyListLogisticsProvABCSImpl of Customer flow of LSP Financial Mgmt: OTM - EBS PIP have to be added manually to the CustomerPartyEBSV2.

  5. LSP Driver Mgmt: OTM - EBS PIP and LSP Financial Mgmt: OTM - EBS PIP use same PayableInvoiceEBS.

    When you install Fleet PIPs, if LSP Financial Mgmt: OTM - EBS PIP is installed after LSP Driver Mgmt: OTM - EBS PIP, routing rules pertaining to Payable Invoice flow of LSP Financial Mgmt: OTM - EBS PIP do not appear in Oracle Enterprise Manager Fusion Middleware Control for PayableInvoiceEBS. In this case, routing rules pertaining to CreatePayableInvoiceListEbizProvABCSImpl of PayableInvoice flow of LSP Financial Mgmt: OTM - EBS PIP have to be added manually to PayableInvoiceEBS and deployed on server.

    For more information on manual deployment of routing rules, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack "Creating Routing Rules".

30.4.1 Validating Security Policies

All SOA composites are protected by Global Policies provided by Foundation Pack as defined in the Security section of the Developer Guide. Additionally individual services for this PIP have locally attached security policies.

To validate locally attached security policies:

  1. Log in to Oracle Enterprise Manager Fusion Middleware Control.

  2. Navigate to WebLogic Domain, soa_domain, Web Services, Policies.

  3. Verify Service Policy attachment.

    1. Find the service policy in the list of policies.

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    3. Change the Subject Type list box to SOA Service.

    4. Validate that all the composites are listed with local attachment to this service policy.

  4. Verify Client Policy attachment

    1. Navigate back to Policies screen and find the client policy

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    3. Change the Subject Type list box to SOA Reference.

    4. Validate that all the composites are listed with local attachment to this client policy and attached to the correct references.

      Note:

      The default csf-key for all the flows is OTM_DOMAIN. This is created in server automatically as a part of PIP installation.

      Table 30-7 Service Policy Attachments for LSP Financial Mgmt: OTM - EBS PIP

      Composite Service Service Policy

      MergeCustomerPartyListLogisticsProvABCSImpl

      TransmissionReport

      oracle/wss_http_token_service_policy

      SyncCurrencyExchangeListLogisticsProvABCSImpl

      TransmissionReport

      oracle/wss_http_token_service_policy

      SyncCustomerPartyListLogisticsProvABCSImpl

      TransmissionReport

      oracle/wss_http_token_service_policy

      SyncSupplierPartyListLogisticsProvABCSImpl

      TransmissionReport

      oracle/wss_http_token_service_policy


      Table 30-8 Wss Http Token Client Policy Attachments for LSP Financial Mgmt: OTM - EBS PIP

      Composite Reference Client Policy

      MergeCustomerPartyListLogisticsProvABCSImpl

      LogisticsWebService

      oracle/wss_http_token_client_policy

      SyncCurrencyExchangeListLogisticsProvABCSImpl

      LogisticsWebService

      oracle/wss_http_token_client_policy

      SyncCustomerPartyListLogisticsProvABCSImpl

      LogisticsWebService

      oracle/wss_http_token_client_policy

      SyncSupplierPartyListLogisticsProvABCSImpl

      SyncSupplierPartyListLogisticsProvABCSImplService

      oracle/wss_http_token_client_policy


For more information about security validation, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Working with Security."

For PIP implementation, see Oracle Application Integration Architecture Oracle Financial Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide.

30.5 Undeploying the LSP Financial Mgmt: OTM - EBS PIP

To undeploy the PIP from Fusion Middleware Server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Table 30-9 Undeployment Command for the LSP Financial Mgmt: OTM - EBS PIP

    Platform Undeployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancialsUndeployDP.xml 
    -l <AIA_HOME>/pips/FleetFinancials/DeploymentPlans/FleetFinancialsUndeployDP.log
    

    Microsoft Windows

    ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancialsUndeployDP.xml 
    -l <AIA_HOME>\pips\FleetFinancials\DeploymentPlans\FleetFinancialsUndeployDP.log
    

  3. Restart the SOA server.

  4. Uninstall the PIP following the instructions in Chapter 37, "Uninstalling Oracle AIA".