IBM Maximo Enterprise Adapter

Version 7.1

Installation Guide for Oracle Applications 12 Adapter

Note
Before using this information and the product it supports, read the information in “Notices” on page 103

This edition applies to version 7, release 1, modification 0 of IBM Maximo Enterprise Adapter and to all subsequent releases and
modifications until otherwise indicated in new editions.

© Copyright International Business Machines Corporation 2008. All rights reserved.

US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM
Corp.
 Contents

About This Publication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii

Intended Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii

Chapter 1: Installation Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Installation Qualifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Hardware Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Software Requirements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Asset Management System Application Server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Oracle Applications E-Business Suite Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

Chapter 2: Installing the Oracle Adapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Prerequisites to Installing the Oracle Adapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Installing the Oracle Adapter. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Chapter 3: Oracle Adapter and Asset Management System Configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

Adding Support for Flat Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Specifying and Enabling the Endpoint for the Oracle Adapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Enabling Publish Channels and Enterprise Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Setting Integration Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Activating Cron Tasks for Sequential Queues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Setting up the Cron Task for Interface Table Polling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Asset Management System Column Lengths and GL Account Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Viewing the Oracle GL Account Format. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Reconfiguring the Asset Management System GL Account Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Running the ConfigDB Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Adding Oracle Vendors to the Asset Management System Companies Master Set . . . . . . . . . . . . . . . . . . . . . . 22
Setting Active Default Item Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

Chapter 4: PL/SQL Object Installations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Identification of the Name and the Location of Oracle Adapter PL/SQL Files . . . . . . . . . . . . . . . . . . . . . . . . . . 26
Creating the Oracle Applications E-Business Suite Integration Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
Configure Installation-dependent Parameters in [Link] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Creating the Asset Management System Interface Tables in the Oracle Applications E-Business Suite Database
29
Installing Packages, Procedures, Triggers and Other Objects to the Oracle Applications E-Business Suite
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Installation Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
MAXORACTLS Integration Control and the Oracle Applications E-Business Suite Database. . . . . . . . . . . . . 31
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Chapter 5: Oracle-specific Integration Controls and Data Synchronization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

Activating the Cron Task for Interface Table Polling. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Enabling the External System (OA12) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Setting up Oracle-specific Integration Control Values in Asset Management System . . . . . . . . . . . . . . . . . . . . 37
Generating the [Link] Output File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Generating the [Link] Output File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Synchronizing Oracle and Asset Management System GL Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Synchronizing Oracle and Asset Management System Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
Synchronizing Oracle Employees and Asset Management System Labor Codes . . . . . . . . . . . . . . . . . . . . . . . . 41

© Copyright IBM Corp. 2008 iii

 Synchronizing Oracle Organizations and Locations and Asset Management System Address Codes . . . . . . 41
Obtaining a list of Oracle Applications E-Business Suite Organizations and Location Codes. . . . . . . . . . 42
Mapping Oracle Organizations and Locations to Asset Management System Address Codes . . . . . . . . . 42
Synchronizing Oracle and Asset Management System Currencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
Obtaining a List of Oracle Applications E-Business Suite Currency Codes . . . . . . . . . . . . . . . . . . . . . . . . . 43
Defining Oracle Currency Codes in Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Synchronizing Oracle Vendors and Asset Management System Companies . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Updating the Asset Management System Company ID with an RBNI and Suspense Account . . . . . . . . 45
Synchronizing Oracle Inventory Organizations and Asset Management System Storeroom Locations . . . . . 46
Obtaining a List of Oracle Applications E-Business Suite Organizations . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Defining Storerooms in the Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Synchronizing Oracle Order Units and Asset Management System Units of Measure . . . . . . . . . . . . . . . . . . . 47
Obtaining a List of Oracle Applications E-Business Suite Order Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47
Defining Units of Measure and Conversion Factors in Asset Management System . . . . . . . . . . . . . . . . . . 47
Adding Tax Codes to Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Obtaining a List of Oracle Applications E-Business Suite Tax Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Defining Oracle Tax Codes in the Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Synchronizing Oracle and Asset Management System Items. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49
Synchronizing Oracle and Asset Management System Item Balances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
Transferring Oracle Item Balances to the Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
Verifying Item Balances in the Asset Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53

Appendix A: MAXORA Schema Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

Appendix B: Request Sets and Purchase Order Imports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67

Submitting the Import Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69

Appendix C: Asset Management System Column Lengths. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71

Changes in the Database Configuration Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
Changes in the Domains Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Post-Update Activities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73

Appendix D: Oracle Applications

E-Business Suite Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
Creating a Ship to Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Setting Up a General Ledger to Import Journals from the Asset Management System . . . . . . . . . . . . . . . . . . . 76
Setting Up Accounts Payable to Import Invoices from the Asset Management System . . . . . . . . . . . . . . . . . . 78

Appendix E: Oracle Project Accounting Configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79

Configuration Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Configuration Activities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Update Database Column Lengths . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Enable New Publish Channels, Enterprise Services, and the Integration Event Listener . . . . . . . . . . . . . . 81
Configure Projects-specific Asset Management System Integration Controls . . . . . . . . . . . . . . . . . . . . . . . 81
Add Fields to User Interfaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Adding Fields to the Work Order Tracking Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
Adding Fields to Purchase Requisition Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Adding Fields to the Purchase Order Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Adding Fields to the Invoice Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
Adding Fields to the Receipts Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92
Adding Fields to the Issues and Transfers Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
Adding Fields to the Cost Management Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Enable the Financial Control Concurrent Extract Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
Provide Access to the Financial Control Concurrent Extract Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101
Synchronize Oracle Employees and Asset Management System Labor Codes . . . . . . . . . . . . . . . . . . . . . 101

Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

iv IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

Contents v
vi IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 About This Publication

This guide describes how to install and configure the IBM Maximo® Enterprise
Adapter for Oracle® Applications 12. It also includes step-by-step instructions for
performing post-installation tasks required for your adapter to work with asset
management system and Oracle Applications E-Business Suite database.

Intended Audience
This guide is for the use of system administrators or other qualified persons who
might perform the installation of the IBM Maximo® Enterprise Adapter for
Oracle® Applications, or for the purposes of this guide, the Oracle adapter.

© Copyright IBM Corp. 2008 vii

Intended Audience

viii IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Installation
Requirements
1
This installation guide helps you install the Maximo Enterprise Adapter for
Oracle Applications (the Oracle Adapter).

ATTENTION Customers who have installed the Maximo Enterprise Adapter for Oracle
Applications version 6 need to upgrade to the asset management system version 7
by using the launchpad.

If you are upgrading from a previous version of the Maximo Enterprise Adapter
for Oracle Applications or re-installing the software, back up any user exit
procedure files that you have customized. The installation program overwrites
the contents of the APISUSER directory, which contains the user exit procedure
files, and the [Link] file.

Installation Qualifications
To perform the installation, you must be familiar with the following topics:

T PC installation tasks such as creating folders, editing files, and running scripts

T Database utilities such as Oracle Enterprise Manager and SQL* Plus®

T Database administration

T Oracle Applications E-Business Suite

T Operating system-specific knowledge for your UNIX® or Microsoft®

Windows platform.

To complete the installation, you need database administration privileges.

© Copyright IBM Corp. 2008 1

Hardware Configuration

Hardware Configuration
To integrate the asset management system and Oracle Applications E-Business
Suite, you must establish separate servers to host the following parts of the
system:

T The asset management system application server to run the asset

management system business components and the Maximo Enterprise
Adapter for Oracle Applications (the Oracle Adapter)

T Asset management system database server

T Oracle Applications E-Business Suite server

Software Requirements
The following sections list the software requirements for the Maximo Enterprise
Adapter for Oracle Applications. IBM Corporation has tested and validated the
versions listed in this section.

Asset Management System Application Server

For the software requirements of the asset management system application
server, refer to the IBM Maximo Asset Management Installation Guide.

Before installing Maximo Enterprise Adapter for Oracle Applications, ensure that
you have installed and properly configured the Maximo Asset Management
System version 7.

Oracle Applications E-Business Suite Server

Verify that the following items have been installed on the Oracle Applications
E-Business Suite server before you continue with the installation of the
integration software:

T Oracle Client Software 9i or greater (SQL* Plus and Oracle Networking)

T Oracle Applications E-Business Suite Release 12

2 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Software Requirements

The following diagram shows a typical integration framework configuration.

Installation Requirements 3
Software Requirements

4 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Installing the Oracle
Adapter
2
There are steps that you must perform to install the Oracle Adapter on the asset
management system in a Windows environment. Steps include completing the
installation prerequisites and the installation of the Oracle Adapter.

Prerequisites to Installing the Oracle Adapter

Before you install the Oracle Adapter, you must install the Maximo Asset
Management System. You can install the asset management system using the IBM
Enterprise Asset Management version 7 installation CD. The installation CD
provides you with a launchpad that guides you through the following installation
prerequisites:

T Middleware installation (MWI) - Only necessary when you are using

DB2® and the IBM WebSphere® Application server and when you have
not installed these components as a pre-requisite for the asset
management system. All other databases and application servers (for
example, BEA® BEA WebLogic server ) must be installed before the
installation of asset management system base services.

T Asset management system base services installation

T Asset management system base services language pack installation - Only

necessary when you need support with other languages other than the
base language. English is installed automatically during the base services
installation step.

T Asset management system Process Solution Installer (PSI) license

installation and update - The Process Solution Installer license installation
is required to enable the asset management system functionality. You can
use the Update Enabler to access future fixpacks automatically when
desired.

© Copyright IBM Corp. 2008 5

Installing the Oracle Adapter

Installing the Oracle Adapter

When you install the Oracle Adapter, the Process Solution Installer application
retrieves the most recent patch and installs it on your machine. The Process
Solution Installer application also establishes all links between the Oracle Adapter
and the asset management system.

ATTENTION If you have installed IBM Maximo Enterprise Adapter for Oracle Applications 11i
version 6, you must upgrade to IBM Maximo Asset Management version 7 by
using the launchpad.

The installation process requires an active internet connection.

To install the Oracle Adapter on the asset management system when running in
Windows environment, you must complete the following steps:

1 Close all open Windows programs.

2 Insert the IBM Enterprise Asset Management System Adapter for Oracle
Applications E-Business Suite CD into your CD-ROM drive.

ATTENTION Verify the following information from the CD:

Name: IBM Enterprise Asset Management System Adapter for

Oracle Applications E-Business Suite

Volume Label: MEA71ORA12

3 Using Windows Explorer, go to the directory where your

[Link] is located (for example, home dir\SMP\bin).

4 Double-click the [Link] file in your drive folder. The IBM

Tivoli Base Services window opens.

5 Select the language to run the install application and click OK.

6 The Process Solution Installer Introduction window opens. Click Next.

7 The Choose PSI Package window opens. Click Choose and select the
[Link] file from your CD folder.

8 Click Next. Wait for the Process Solution Installer to finish validating your
package.

9 The Package Validation Results window opens. Click Next.

6 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Installing the Oracle Adapter

10 The Software License Agreement screen opens. Select the I accept the terms in
the license agreement option and click Next.

11 The Add Features screen opens. If you are using a language other than
English, select the check box for Maximo Asset Management Oracle Adapter
Language Support Features.

If you installed the IBM WebSphere Application Server and DB2 by using the
Middleware Installer launchpad, then continue with the next step. If you are
working on a BEA WebLogic Server and an Oracle environment, or did not
use the Middleware Installer, go to step 15.

12 The Process Solution Installer queries for the required credentials and the
Middleware Login Information window opens. Go to Maximo DB tab and
enter the password for Maximo database user. Go to the WebSphere
Admininstration tab and enter the password for the IBM WebSphere
Application Server manager.

13 Go to the WebSphere Remote tab and enter the password for the Remote
Administrator user.

14 Click Next. Wait for the Process Solution Installer to finish validating the
Middleware credentials.

15 The Package Options window opens.

Leave both Support Package check boxes cleared and click Next.

16 The Pre-install Summary window opens. Review the summary and click
Next. The Deployment Progress window opens.

If the Process Solution Installer is deploying the .EAR files (this happens only
when working on IBM WebSphere Application Server and DB2
environments), this process can take several minutes.

17 The Package Successfully Deployed window opens. Click Next.

18 The Install Another Package window opens.

„ If you have additional packages, you must install, select the Install
Another Package check box and click Done.
„ If you do not have any other packages to install, leave the Install Another
Package check box cleared and click Done.

19 Start the asset management system application server.

20 Start the Actuate server.

21 Log in to the asset management system to verify that the application server
started successfully.

Installing the Oracle Adapter 7

Installing the Oracle Adapter

8 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Oracle Adapter and
Asset Management
System Configurations
3
The Oracle Adapter is a set of components, programs, mappings, and controls
that enable you to send transactional data between the asset management system
and the Oracle Applications E-Business Suite.

The asset management system uses the Oracle Adapter components to transform
data from the asset management system format to a format compatible with the
Oracle Applications E-Business Suite. From an asset management system
standpoint, the Oracle Applications E-Business Suite is an external system. Any
business application that sends data to or receives data from the asset
management system is considered to be an external system.

For more information about integration framework terminology and usage, see
the IBM Maximo Asset Management Integration Guide.

© Copyright IBM Corp. 2008 9

Adding Support for Flat Structure

Adding Support for Flat Structure

The support for flat structure needs to be enabled for the MEA 7.1 for Oracle
Applicatons 12 integration using interface tables to work properly.

To enable the support for flat structure:

1 Select Go To > Integration > Object Structures.

2 Check the Support Flat Structure check box for the following object
structures.

T MXCOA T MXITEM

T MXCRAFT T MXLABOR

T MXGLCOMP T MXPC

T MXGLTXN T MXPO

T MXINVBAL T MXPR

T MXINVENTORY T MXPROJ

T MXINVISSUE T MXRCVROTITM

T MXINVOICE T MXRECEIPT

T MXINVRES T MXVENDOR

3 Click Save.

10 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Specifying and Enabling the Endpoint for the Oracle Adapter

Specifying and Enabling the Endpoint for the Oracle

Adapter
The endpoint defines where and how you send outbound transactions to the
Oracle Applications E-Business Suite external system. You must define an
endpoint for the Oracle Adapter. The handler describes how the Oracle Adapter
sends transactions to the external system, such as an interface table, HTTP post, or
XML file.

To create and enable an endpoint for the Oracle Adapter.

1 Open the End Points application.

2 Select Go To > Integration > End Points.

3 Select New End Point.

4 Populate the following data:

Name OAIFACETABLE

Description Oracle Adapter 12 Endpoint

Handler IFACETABLE

ISREMOTE 1

URL jdbc:oracle:thin:@[Link]:a120

T [Link] is the machine that hosts

Oracle Applications

T 9400 is the port number

T a120 is the Oracle instance

Driver [Link]

Username maxora

Password maxora

5 Click Save End Point.

6 Select Go To > Integration > External Systems.

7 Select the endpoint that you have just created (OAIFACETABLE).

8 Click Save External System.

Oracle Adapter and Asset Management System Configurations 11

Enabling Publish Channels and Enterprise Services

Enabling Publish Channels and Enterprise Services

The integration framework uses the publish channel to transform data from the
asset management system format to an external format that is compatible with the
Oracle Applications E-Business Suite. Similarly, the integration framework uses
an enterprise service to transform data from the Oracle Applications E-Business
Suite external system to a format that is compatible with asset management
system. The publish channels and the enterprise services act as communication
channels between Oracle Applications E-Business Suite.

For example, you can use the asset management system to send general ledger
journal transactions to the Oracle Applications E-Business Suite General Ledger
application. The Oracle Applications E-Business Suite system uses different data
formats and business rules than the asset management system, but the Oracle
Applications E-Business Suite system-specific components process data
transactions according to the formatting and processing requirements of that
system.

To enable publish channels and enterprise services:

1 Open the External Systems application.

2 Press Enter to display a list of external systems.

3 Click OA12 to display information about the Oracle Applications E-Business

Suite external system in the System tab.

4 To display all the publish channels, select Go To > Integration > Publish
Channels and filter by OA12

The adapter uses the sequential outbound (sqout) Java Message Service (JMS)
queue for each of these publish channels.

The following table shows the provided Oracle adapter publish channels.

Publish channels Oracle description

MXGLTXN_TOOA12 OA GL Journals

MXINVENTORY_TOOA12 OA Inventory

MXINVOICE_TOOA12 OA Invoices

MXINVRES_TOOA12 OA Inventory Reservations

MXITEM_TOOA12 OA Items

MXPC_TOOA12 OA Purchase Contracts

MXPO_TOOA12 OA Purchase Orders

MXPROJTXN_TOOA12 OA Project Actuals

MXPR_TOOA12 OA Purchase Requisitions

MXRECEIPT_TOOA12 OA Receipts

12 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Enabling Publish Channels and Enterprise Services

5 Clear the Enabled check box for any publish channels that you do not use for
your integration.

6 Click Save External System.

7 Enable the integration events for publish channels that you choose to use.
Select Go To > Integration > Publish Channels.

8 Filter the records by OA12.

You can mark the publish channels you choose to use. To do so, Select Action
> Enable Listener.

9 Click OK.

10 To display all the enterprise services, select Go To > Integration > Enterprise
Services and filter by OA12.

By default, the adapter enables the continuous queue (cqin) for each of the
enterprise services. If you clear the Use Continuous Queue check box for an
enterprise service, the adapter uses the sequential inbound (sqin) JMS queue.

The following table shows the provided Oracle adapter enterprise services.

Enterprise services Oracle description

MXCOA_FROA12 OA Chart of Accounts

MXCRAFT_FROA12 OA Employee Jobs

MXGLCOMP_FROA12 OA GL Components

MXINVBAL_FROA12 OA Inventory Balances

MXINVENTORY_FROA12 OA Inventory

MXINVISSUE_FROA12 OA Inventory Issue

MXINVOICE_FROA12 OA Invoices

MXITEM_FROA12 OA Items

MXLABOR_FROA12 OA Employees

MXPC_FROA12 OA Purchase Contracts

MXPO_FROA12 OA Purchase Orders

MXPROJ_FROA12 OA Projects

MXPR_FROA12 OA Purchase Requisitions

MXRCVROTITM_FROA12 OA Receive Rotating Items

MXRECEIPT_FROA12 OA Receipts

MXVENDOR_FROA12 OA Vendors

11 Clear the Enabled check box for any enterprise services that you do not use
for your integration, or click New Row to add a new outbound or enterprise
service.

Oracle Adapter and Asset Management System Configurations 13

Setting Integration Controls

12 Click Save External System after you make any changes.

Setting Integration Controls

Integration controls give you the ability to override the behavior of certain
predefined publish channel or enterprise service processing and to configure
them according to the requirements of your organization and sites.

The Oracle adapter has a set of controls that are associated with its publish
channels and enterprise services. You can use controls to alter the processing of
data within a publish channel or enterprise service. For example, you can
configure an integration control to set a purchase order (PO) in the publish
channel to a status APPR (approve), or a status of CLOSE.

The asset management system provides four types of integration controls:

Control type Description

Boolean Specifies a check box value of true or false.

Cross-reference Replaces one value with another

List Specifies a list of values

Value Specifies a single value

You can view or update the default integration controls that are installed with the
Oracle adapter. You can also add new integration controls to meet the business
needs of your business.

To view or update your integration controls:

1 Open the External Systems application.

2 Select the OA12 external system record.

3 From the Select Action menu, select Setup Integration Controls.

The Setup Integration Controls dialog box displays the following Value type
integration controls for the Oracle Applications E-Business Suite external
system.

Integration control Description

APLINETYPE Default invoice line type in the Oracle Applications

E-Business Suite

CHARGEORG Default charge (project expenditure) organization

CONVHRS Hours to convert annual salary to hourly rate

DTC_EXP Destination type code for direct issue PO lines

DTC_INV Destination type code for replenishment PO lines

EXPENDITEM Oracle Project Accounting item expenditure type

14 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting Integration Controls

Integration control Description

EXPENDLABOR Oracle Project Accounting labor expenditure type

EXPENDTOOL Oracle Project Accounting tool expenditure type

GENITEM Dummy identifier for masking item number

GENSTORE Dummy identifier for masking storeroom on

outbound transactions

GENUSR Dummy identifier for masking user ID on outbound

transactions

GLCURNCY Default currency code in the Oracle Applications

E-Business Suite

GLCURNCYTYPE Type of currency exchange rates

NLRORG Default Oracle Project Accounting non-labor

resource organization

OAITMLOTPREF Default starting lot prefix

OAITMLOTSTART Default starting lot Number

OFPCDEFORDER Default order unit for purchase contracts

RESLEVELITEM Resource level for items

RESLEVELLABOR Resource level for labor

RESLEVELTOOL Resource level for tools

SRCTIM Transaction source for labor actuals

SRCUSE Transaction source for non-labor actuals

SUBLOCDEL Delimiter between subinventory code and locator ID

in the asset management system bin number

For more information about integration controls, see the IBM Maximo Asset
Management Integration Guide.

The following table lists all the Boolean type integration controls for the
Oracle Applications E-Business Suite (OA12) external system.

Integration control Description

PROJAP Include project accounting data on outbound invoice

lines

PROJPO Include project accounting data on outbound

purchase order lines

PROJPR Include project accounting data on outbound

purchase requisition lines

USEPRNUM Specifies if integration uses the asset management

system PR number as the Oracle Applications E-
Business Suite PR number (value 1) or uses the
autogenerated number used by the Oracle import
routine (0)

Oracle Adapter and Asset Management System Configurations 15

Setting Integration Controls

The following table lists all the List type integration controls for the Oracle
Applications E-Business Suite (OA12) external system.

Integration Description Domain

control

APSEND Statuses at which invoices are IVSTATUS

sent from the asset management
system to the Oracle
Applications E-Business Suite

GLSOURCE Source business object of the GLSOURCE

asset management system
general ledger journal

JEPROJSEND List of the asset management GLSOURCE

system project transactions to
forward to Oracle general ledger

PCSEND Statuses at which purchase CONTRACTSTATUS

requisitions are sent from the
asset management system to
Oracle Applications E-Business
Suite

POSEND Statuses at which purchase POSTATUS

orders are sent from the asset
management system to the
Oracle Applications E-Business
Suite

PROJSEND Transaction types for which GLSOURCE

actuals transactions are sent to
Oracle Project Accounting

PRSEND Statuses at which purchase PRSTATUS

requisitions are sent from the
asset management system to the
Oracle Applications E-Business
Suite

The following table lists all the Cross Reference type integration controls for
the Oracle Applications E-Business Suite (OA12) external system.

Integration control Description

CATEGORYXREF Cross-reference asset management system item

category and Oracle stock enabled flag

COAXREF Cross-reference asset management system

organization ID and Oracle chart of accounts ID

CRAFTXREF Multiply Oracle craft code to asset management

system organizations

FCSTATUSXREF Cross-reference Oracle project status and asset

management system financial control status

INVCSTATUSXREF Translate asset management system internal and

external invoice status, if using synonyms

16 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting Integration Controls

Integration control Description

INVCTYPEXREF Cross-reference asset management system and

Oracle invoice document types

ITMSUBXREF Cross-reference storeroom and subinventory

JECATXREF Cross-reference asset management system

transaction type and the Oracle Applications
E-Business Suite journal category

LABXREF Multiply Oracle labor code to asset management

system organizations

LANGXREF Cross-reference asset management system language

code and Oracle SET_PROCESS_ID

LINETYPEXREF Cross-reference asset management system line type

(synonyms) and the Oracle Applications E-Business
Suite line type

LOTTYPEXREF Cross-reference asset management system and

Oracle lot control indicators

OACATXREF Cross-reference asset management system line type

and Oracle item or service category identifier

ORGXREF Cross-reference asset management system

organization and Oracle ledger ID

PCSTATUSXREF Cross-reference asset management system internal

and external contract status, if using synonyms

PCTYPEXREF Cross-reference asset management system and

Oracle contract types

POSTATUSXREF Cross-reference asset management system internal

and external PO status, if using synonyms

POTYPEXREF Cross-reference asset management system and

Oracle Applications E-Business Suite purchase order
types

PRSTATUSXREF Cross-reference asset management system internal

and external PR status, if using synonyms

SITEXREF Cross-reference asset management system site ID

and Oracle operating unit

4 Click Save External System.

Oracle Adapter and Asset Management System Configurations 17

Activating Cron Tasks for Sequential Queues

Activating Cron Tasks for Sequential Queues

As part of the installation, you must activate the JMS sequential queues in the
asset management system by completing the following steps:

1 Open the Cron Task Setup application by selecting Go To > System

Configuration > Platform Configuration > Cron Task Setup.

2 Press Enter to display a list of cron tasks.

3 Select JMSQSEQCONSUMER to display the cron task details.

4 Select the Active check box for the sequential outbound queue (SEQQOUT).

Select the Active check box for SEQQIN only when you have enabled the
sequential inbound queue for any enterprise service (by clearing the Use
Continuous Queue check box in the Enterprise Services tab for the OA12
external system).

5 Click Save Cron Task.

6 Select Action > Reload Request.

7 Select all activated items.

8 Click OK.

18 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting up the Cron Task for Interface Table Polling

Setting up the Cron Task for Interface Table Polling

You must use the Cron Task Setup application to prepare the Oracle interface
table for polling.

Do not activate the cron task until you are ready to send transactions between
asset management system and the Oracle Applications E-Business Suite. You
must first install Oracle objects.

To set up the cron task and specify a schedule for interface table polling:

1 Open the Cron Task Setup application by selecting Go To > System

Configuration > Platform Configuration > Cron Task Setup.

2 Press Enter to display a list of cron tasks.

3 Click IFACETABLECONSUMER to open the Interface Table Polling Task

page.

4 Click New Row.

5 Enter a Cron Task Instance Name, for example, OAPolling.

6 Click the Schedule icon to display the Select Schedule or Time Interval dialog
box.

7 Enter a schedule for the OAPolling task that reflects how frequently you want
to poll the interface table.

8 Click the Run as User icon to display a Select Value list where you can choose
a User ID to associate with the cron task. The default value is MAXADMIN,
which provides the highest level of user authorization.

9 Do not activate the polling cron task (by selecting the Active check box) until
you are ready to receive transactions that are sent to asset management
system from Oracle Applications E-Business Suite.

10 Select the ENDPOINT Cron Task Parameter and enter the name that you
assigned to the endpoint for the Oracle Adapter, for example,
OAIFACETABLE.

11 Select the EXTSYSNAME Cron Task Parameter and enter OA12.

12 Click Save Cron Task.

Oracle Adapter and Asset Management System Configurations 19

Asset Management System Column Lengths and GL Account Format

Asset Management System Column Lengths and GL

Account Format
Use the asset management system Database Configuration application to
configure the asset management system table column lengths and general ledger
account formats to ensure that they are compatible with the corresponding data
in the Oracle Applications E-Business Suite.

Refer to the asset management system column lengths information for a list of
table columns and their recommended field sizes. You must use the Database
Configuration application to configure column lengths in the asset management
system.

For the Oracle Applications E-Business Suite interface, you must configure the
asset management system general ledger accounts to have the same length and
account delimiters as the Oracle database.

Viewing the Oracle GL Account Format

To view the structure of the chart of accounts in the Oracle Applications
E-Business Suite, complete the following steps:

1 In Oracle, select Responsibility > General Ledger, Vision Operations (USA).

2 Select Setup > Financials > Flexfields > Key > Segments.

3 Select View > Query by Example > Enter.

4 Enter General Ledger for Application and Accounting Flexfield for Flexfield
Title.

5 Select View > Query by Example > Run.

The Structures section displays all of the system chart of accounts.

6 To view the Segments Summary window, select a chart of accounts and click
Segments.

Reconfiguring the Asset Management System GL Account Format

Complete the following steps to reconfigure the asset management system GL
account format so that it matches the Oracle GL account format.

1 Navigate to the Database Configuration page by selecting Go To >

Configuration > Database Configuration.

2 Choose Select Action > GL Account Configuration to open the GL Account

Configuration dialog box.

3 Define each GL component to have the same length as in the Oracle

Applications E-Business Suite. For example, if the Oracle Applications

20 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Asset Management System Column Lengths and GL Account Format

E-Business Suite has a GL account format where SEG 1 (out of 5) is 2

alphanumeric characters and the account delimiter is a dash as shown below:

Use the following table as a guide to reconfigure the asset management

system GL account format using the GL Account Configuration dialog box:

Component Length Type Required

SEG1 2 ALN Y

SEG2 3 ALN Y

SEG3 4 ALN Y

SEG4 4 ALN Y

SEG5 3 ALN Y

4 Before you reconfigure the GL account format, you must delete each of the
existing the asset management system GL components by clicking the
appropriate Trash icons.

5 To add the Oracle GL account format, click New Row for each component,
and enter the information in the previous table for SEG1 through SEG5 in the
following fields:

T Component
T Length
T Type
T Required
T Screen Delimiter

You can enter any acceptable alphanumeric or special character as the

delimiter between GL account components.

The Oracle Adapter uses the delimiter to parse the GL account before sending
component information to Oracle Applications E-Business Suite.

6 Click OK after you add each new row for an Oracle GL account component.

Oracle Adapter and Asset Management System Configurations 21

Running the ConfigDB Tool

Running the ConfigDB Tool

You must run [Link] to add Oracle integration-specific fields to your asset
management system database. When you run [Link], it applies all pending
database configuration changes for the integration framework.

Complete the following steps to update your asset management system database.

1 Stop the asset management system application server.

2 Navigate to the asset management system directory, which contains the

[Link] file. The default path is:

Maximo_root\tools\maximo

3 Run [Link].

4 After configdb runs, open the log files in the following directory to review
changes made to the database.

Maximo_root\tools\maximo\log

5 Restart the application server to continue with the Oracle Adapter

installation.

Adding Oracle Vendors to the Asset Management

System Companies Master Set
If you plan to synchronize Oracle vendors and the asset management system
companies, then you must select the Automatically Add Companies to Company
Master check box. Enabling this flag ensures that all the Oracle vendors that you
add are also included in the asset management system company master set. For
the vendor and company integration to work, you must include Oracle vendors in
the company set so that vendors are added at the organizational level in the asset
management system.

To add Oracle vendors to the asset management system company master set:

1 Navigate to the Sets application by selecting Go To > Administration > Sets.

2 Open the Details section for each Set record with a company type.

3 Select the Automatically Add Companies to Company Master check box.

4 Click Save Set.

22 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting Active Default Item Status

Setting Active Default Item Status

When you are sending item transactions to the asset management system, you
must set the default item status to active.

To set the default item status to active:

1 Navigate to the Sets application by selecting Go To > Administration > Sets.

2 For each Item Set row, change Default Item Status to Active.

3 Click Save Set.

4 Navigate to the Sets application by selecting Go To > Administration >

Organizations.

5 For each Organization row, change Default Item Status to Active.

6 Click Save Set.

Oracle Adapter and Asset Management System Configurations 23

Setting Active Default Item Status

24 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
PL/SQL Object
Installations
4
When you install and set up the adapter on the Oracle side of the integration, you
must create a new integration schema in the Oracle Applications E-Business Suite
database. You also must be familiar with how to configure installation-dependent
parameters, and how to create interface tables and install objects in the database.

Some other things you must consider are the name and location of the Oracle
adapter PL/SQL files, how to install packages, procedures, and triggers, checking
installation errors, and performing manual updates.

© Copyright IBM Corp. 2008 25

Identification of the Name and the Location of Oracle Adapter PL/SQL Files

Identification of the Name and the Location of Oracle

Adapter PL/SQL Files
The installation program for the Oracle Applications E-Business Suite adapter
creates the ORACLEAPIS directory, which holds user template files and scripts, in
the root directory of your asset management system installation. For example, the
default path for the directory is:

Maximo_root\ORACLEAPIS

The following table lists the type of files in the ORACLEAPIS subdirectories.

Subdirectory Description

apiuser Contains standard template files for the user exits

install Contains installation scripts

interfac Contains the script that creates triggers, procedures, and

packages

log The log subdirectory

The template files in the apiuser subdirectory with a .usp extension contain
sample code for the user exit procedures. If you have written custom user exit
procedures, you must integrate your changes within these template files.

Creating the Oracle Applications E-Business Suite

Integration Schema
This section describes how you create a new schema in the Oracle Applications
E-Business Suite database where you install all the Oracle Adapter objects for the
integration. You must create a schema for managing the integration framework in
the Oracle Applications E-Business Suite database.

The examples in this guide use MAXORA as the Oracle Applications E-Business
Suite integration schema user name, however, you can choose any name for your
schema owner.

To create the Oracle Applications E-Business Suite integration schema, complete

the following steps:

1 Open the [Link] file located in the following directory:

Maximo_root\ORACLEAPIS\install

2 Replace all instances of MAXORA with your integration schema name.

3 Replace all instances of USER_DATA with your tablespace name.

4 Save the [Link] file.

26 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configure Installation-dependent Parameters in [Link]

5 Launch SQL* Plus and connect to the Oracle Applications E-Business Suite
database as a database administration user.

6 To create and grant privileges to the integration schema, enter the following
command:

SQL > start Maximo_root\ORACLEAPIS\install\cremxora <Enter>

7 Review and correct any errors that you see on the screen.

You can create multiple integration schemas on the same database instance to
support multiple the asset management system application servers.

Configure Installation-dependent Parameters in

[Link]
The [Link] script specifies the parameters for installing the Oracle Adapter
like the user name and password for the Oracle Applications E-Business Suite
integration schema. You must configure all of the parameters in the [Link]
script that are described in the following table.

You can find the setofvar script in Maximo_root\ORACLEAPIS\install along

with the other Oracle Adapter installation files.

The Maximo_root variable in directory paths generally defaults to c:\maximo for

Windows.

PL/SQL Object Installations 27

Configure Installation-dependent Parameters in [Link]

In the [Link] file, change only the variables specified in the following table.

Parameter Description

hostStrOF = 'service name for Oracle Enter the Oracle database service name configured in
database' [Link].

MaximoUserName = 'MAXORA' User name created for the Oracle Applications E-Business
Suite integration schema.

MaximoPass = 'MAXORA user password' Password for MAXORA.

ORAAPPLSYSUSERNAME = 'APPS' Owner for the Oracle Applications E-Business Suite database.

ORAAPPLSYSPASS = 'APPS' Password for the Oracle Applications E-Business Suite

owner.

RootApis = 'Maximo_root\ORACLEAPIS' The install directory for the Oracle Applications E-Business
Suite adapter. It contains the following subdirectories:

apiuser

install

interfac

log

LogDir = 'Maximo_root\ORACLEAPIS\log' The location of output log files.

UserDir = The location of user exit templates.

'Maximo_root\ORACLEAPIS\apiuser'
If you have customized versions of the user exits, be sure to
add them to the templates.

28 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Creating the Asset Management System Interface Tables in the Oracle Applications E-Business Suite Database

Creating the Asset Management System Interface

Tables in the Oracle Applications E-Business Suite
Database
You must execute the create procedure in the asset management system, but it
creates the tables in the Oracle Applications E-Business Suite database. You must
complete the installation of the Maximo Enterprise Adapter for Oracle
Applications before proceeding.

Complete the following steps in the asset management system to create the
interface tables.

1 Choose Go To > Integration > External Systems.

2 Select the System field and press Enter, then select OA12 External System.

3 Choose Select Action > Create Interface Tables.

4 Click the End Point Select icon, then select OAIFACETABLE.

5 Select the interface tables that you want to create or re-create.

T MXCOA_IFACE T MXLABOR_IFACE

T MXCRAFT_IFACE T MXPC_IFACE

T MXGLCOMP_IFACE T MXPO_IFACE

T MXGLTXN_IFACE T MXPR_IFACE

T MXINVBAL_IFACE T MXPROJ_IFACE

T MXINVENTORY_IFACE T MXPROJTXN_IFACE

T MXINVISSUE_IFACE T MXRCVROTITM_IFACE

T MXINVOICE_IFACE T MXRECEIPT_IFACE

T MXINVRES_IFACE T MXVENDOR_IFACE

T MXITEM_IFACE

6 Click Create.

You can anticipate that it might take 10 minutes or more to build the interface
tables.

PL/SQL Object Installations 29

Installing Packages, Procedures, Triggers and Other Objects to the Oracle Applications E-Business Suite Database

Installing Packages, Procedures, Triggers and Other

Objects to the Oracle Applications E-Business Suite
Database
To set the installation parameters that are defined in [Link], complete the
following steps:

1 In SQL* Plus, connect as the user MAXORA to the Oracle Applications

E-Business Suite database.

2 Enter the following command:

SQL> start Maximo_root\ORACLEAPIS\install\setofvar

This command lists the install parameters defined in [Link].

3 Enter the following command:

SQL> start [Link]

4 Press Enter.

Depending on your environment, this step might take 2 to 10 minutes to run.

The generated file is in the following location:

Maximo_root\ORACLEAPIS\log\[Link]

5 Check the [Link] file for any errors.

30 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Installation Errors

Installation Errors
After you install the packages, procedures, and triggers to the Oracle
Applications E-Business Suite database, you must open the [Link] spool file in
the log directory and check for errors.

The following table describes the types of errors you might find:

Error type Description

File not found Search for text similar to “unable to open file
\Maximo_root\ORACLEAPIS\...”. Errors of this type indicate
that the [Link] file might not have correct directory settings.
For example, the user directory
Maximo_root\ORACLEAPIS\apiuser might be missing a \ after
“apiuser.”

Statements not accepted by the system Search for “unknown command” text. If you find this error,
verify that your version of SQL* Plus for Windows is equal to or
higher than [Link].4.

Oracle Search for “ORA –” text. If you find any ORA-type errors,
contact your Oracle Database Administrator.

Compile Search for “PLS –” text. If you find any lines that start with “PLS-
”, then also search for “with compilation error” text. If you find
any compile errors, contact IBM Support.

Before continuing with the installation, you must fix any problems that you find
and rerun [Link] without errors.

MAXORACTLS Integration Control and the Oracle

Applications E-Business Suite Database
The Oracle Adapter installation process creates the MAXORACTRLS integration
control table in the Oracle Applications E-Business Suite database. This table
contains additional controls that the adapter uses on the Oracle Applications
E-Business Suite side of the integration. You set the values of Oracle integration
controls with a SQL statement.

The following tables display the structure and contents of the MAXORACTLS
table.

Any changes you make to the MAXORACTLS controls table take effect within 1
minute.

PL/SQL Object Installations 31

MAXORACTLS Integration Control and the Oracle Applications E-Business Suite Database

MAXORACTLS Table Structure

Field Description Lengt Null Data Type

h

CTLNAME Control name 25 Not null Varchar2

CTLVALUE Control value 50 Null Varchar2

CTLDESC Control description 200 Null Varchar2

MAXORACTLS General Controls

Default
Control name value Description

APITRANS 1 If value is 1, allows the transfer of data

from Oracle Applications E-Business
Suite to the asset management system
interface tables.

If value is 0, does not allow the

transfer of data from Oracle
Applications E-Business Suite to the
asset management system interface
tables.

APITRG 0 If value is 1, you exit triggers without

further processing.

To set to 1 (disable triggers), execute

the following command in SQL* Plus:

exec [Link]

To set to 0 (enable triggers), execute

the following command in SQL* Plus:

exec [Link]

EXCEPTIONTOEXT 0 Exception to Oracle Applications E-

Business Suite

If value is 1, sends errors to the Oracle

Applications E-Business Suite.

If value is 0, no errors are sent to the

Oracle Applications E-Business Suite.

32 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 MAXORACTLS Integration Control and the Oracle Applications E-Business Suite Database

Default
Control name value Description

EXCEPTIONTOMAX 0 Exception to the asset management

system

If value is 1, sends errors back to the

asset management system server.

If value is 0, inserts the records in the

asset management system interface
tables and logs the errors in the
interface table message and status
columns.

EXTSYS OA12 External system name.

FCEXTRACTDATE Null Last FC Extract Date (fmDD-MON-

RRRR HH24:MI:SS)

GLSOBID2 0 Reporting ledger ID used to retrieve

EXCHANGERATE2 in Oracle
Applications E-Business Suite.

MEAORAVER [Link] The installed version of the Maximo

Build nn Enterprise Adapter for Oracle
Applications.

PL/SQL Object Installations 33

 MAXORACTLS Inbound Controls

Control name Default Description

value

APIN 1 Controls transfer of inbound invoices.

COAIN 1 Controls transfer of inbound charts of

accounts.

COMIN 1 Controls transfer of inbound companies.

INVBALIN 1 Controls transfer of inbound inventory

balances.

ISUIN 1 Controls transfer of inbound material issues.

ITEMIN 1 Controls transfer of inbound items.

ITMBALXFRIN 1 Controls transfer of inbound item balances.

LCIN 1 Controls transfer of inbound labor codes.

LOGLEVEL Error, Controls the amount and type of information

Warning, written to the log file.
Info,
Debug

PCIN 1 Controls transfer of inbound purchase

contracts

POIN 1 Controls transfer of inbound purchase orders.

PROJPAY 1 Controls transfer of inbound Oracle Projects

pay rates.

Default value is 1 when integration with

Oracle Project Accounting is installed.

RCVIN 1 Controls transfer of inbound receipts.

34 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Oracle-specific
Integration Controls and
Data Synchronization
5
Certain data that is shared by the asset management system and the Oracle
Applications E-Business Suite must be consistent at the asset management system
organization-level and Oracle Applications E-Business Suite ledger-level. To
ensure consistency, you must configure and synchronize a number of asset
management system and Oracle fields by using the integration controls.

You must accurately synchronize information like Oracle employees and asset
management system labor codes and Oracle vendors and asset management
system companies before you can successfully exchange data between the asset
management system and Oracle.

For example, if the Oracle Applications E-Business Suite uses the British pound as
the base currency in a ledger, the asset management system must use the British
pound as the base currency for the corresponding organization.

The following data must be consistent between the asset management system and
the Oracle Applications E-Business Suite:

T Currencies
T Financial calendars
T Tax rates
T Units of measure and conversion factors
T User names (if you do not use the GENUSR integration control)

To maintain this data, update it manually in the applications.

© Copyright IBM Corp. 2008 35

Activating the Cron Task for Interface Table Polling

Activating the Cron Task for Interface Table Polling

Now that you have completed installing and configuring the Oracle Adapter on
the Oracle side of the integration, you are ready to send transactions between the
asset management system and the Oracle Applications E-Business Suite. You
must first enable the cron task (i.e., OAPolling).

1 Navigate to the Cron Task Setup application by selecting Go To > System

Configuration > Platform Configuration>Cron Task Setup.

2 Press Enter to display a list of cron task instances.

3 Click IFACETABLECONSUMER.

4 Click OAPolling (or some other Cron task name) to display record
information.

5 Select the Active check box to enable the cron task.

6 Click Save Cron Task.

7 Click Select Action > Reload Request.

Enabling the External System (OA12)

In addition to enabling the cron task for interface table polling, you also must
enable the Oracle Applications E-Business Suite external system (OA12).
Complete the following steps to enable OA12:

1 Navigate to the External Systems application by selecting Go To > Integration

> External Systems.

2 Type OA12 in the System field, and press Enter.

3 Click OA12 to open the OA12 external systems window.

4 Select the Enabled check box.

5 Click Save External System.

36 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting up Oracle-specific Integration Control Values in Asset Management System

Setting up Oracle-specific Integration Control Values

in Asset Management System
There are several Oracle-specific integration control values you must configure in
the asset management system.

For information on updating the integration control values in asset management

system, see the IBM Maximo Asset Management Integration Guide.

Generating the [Link] Output File

To determine the values you must enter in the Oracle-specific integration controls
for Services, Special Orders, and Materials, complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar

SQL> start &[Link]

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file displays the values of category IDs to use for Services,
Special Orders, and Materials.

2 Select a category ID to transfer, then rerun the showcats script.

3 Use the information from [Link] shown in the following table to set the
integration control values in the asset management system:

Control Value

OACATXREF Used to convert the asset management system line types

into Oracle categories.

Oracle-specific Integration Controls and Data Synchronization 37

Setting up Oracle-specific Integration Control Values in Asset Management System

Generating the [Link] Output File

To determine the values you must enter in the Oracle-specific integration controls
that display the relationship between inventory organizations and operating
units, complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar

SQL> start &[Link]

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file displays the relationship between inventory

organizations and operating units.

2 Use the information from [Link] shown in the following table to set
the ORGXREF and SITEXREF integration control values in the asset
management system.

If the multi_org_flag at the top of the file is Y, your application is running

multiple operating units (organizations). If you are not running multiple
organizations, then you can bypass setting up values for the ORGXREF and
SITEXREF controls.

Control Value

ORGXREF Maps the asset management system organizations to the

Oracle Applications E-Business Suite ledger.

SITEXREF Maps the asset management system sites to the Oracle

Applications E-Business Suite operating units.

38 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle and Asset Management System GL Components

Synchronizing Oracle and Asset Management

System GL Components
The Oracle Applications E-Business Suite and the asset management system must
use the same chart of accounts structure before you can begin transferring GL
data from Oracle to the asset management system. Oracle and asset management
system chart of accounts must share the same number of segments.

You can reconfigure the asset management system so that its account segments
have the same structure as those in the Oracle Applications E-Business Suite.

Additionally, you can modify the Oracle and asset management system GL
structures with user exit procedures that transform accounts from one structure
to the other. For example, Oracle allows null segments in any part of the account
structure, while the asset management system does not allow a null segment to
precede a populated segment. To reconcile these differences, you may need to
create a user exit procedure that alters the number and position of the GL
segments.

To transfer GL components from Oracle to the asset management system,

complete the following steps:

1 Navigate to the Install directory from Maximo_root. Locate and open the
[Link] file. You can edit this file by using a WHERE clause to
accomplish the following:

T To transfer all accounts to the asset management system

T Transfer selected accounts to the asset management system

2 Login to SQL* Plus and connect to the Oracle Applications E-Business Suite
database.

3 Enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

The above commands set the Oracle Adapter environment and start the
transfer of Oracle GL component data to Asset Management System.

4 When prompted, press Enter.

5 Enter a chart of accounts ID (COA_ID) from the list of IDs displayed on your
screen, then press Enter.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

Oracle-specific Integration Controls and Data Synchronization 39

Synchronizing Oracle and Asset Management System Chart of Accounts

6 Review the [Link] file for errors.

The spool file might direct you to select from the MAXORALOG table to
review error conditions. You can view this log in SQL* Plus after logging in as
user MAXORA.

For example, you might see errors similar to the following:

column application = ‘API_GLCC_SP’

ORA-06502: PL/SQL: numeric or value error

If you get the above error message, check the mapping for the
MX_GLCOMP_IFACE table. This error indicates that the COMPTEXT field is
not large enough to hold the GL component description from the Oracle
Applications E-Business Suite. To resolve this type of error, reconfigure the
asset management system GLCOMPONENTS table and increase the length of
the COMPTEXT field.

Synchronizing Oracle and Asset Management

System Chart of Accounts
To transfer the chart of accounts from Oracle to the asset management system,
complete the following steps:

1 Navigate to the ORAAPIS directory from Maximo_root. Locate and open the
[Link] file. You can edit this file by using a WHERE clause to accomplish
the following:

T To transfer all accounts to the asset management system

T Transfer selected accounts to the asset management system

2 Login to SQL* Plus and connect to the Oracle Applications E-Business Suite
database.

3 Enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

The above commands set the Oracle Adapter environment and start the
transfer of Oracle chart of accounts data to the asset management system.

4 When prompted, press Enter.

5 Enter a chart of accounts ID (COA_ID) from the list of IDs displayed on your
screen, then press Enter.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

6 Review the [Link] file for errors.

40 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle Employees and Asset Management System Labor Codes

7 To transfer additional chart of accounts IDs:

T Select a different COA_ID from the list

T Rerun the script

T Review the output file for errors

Synchronizing Oracle Employees and Asset

Management System Labor Codes
To transfer the Oracle employees to the asset management system labor codes,
complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

2 When prompted, press Enter.

3 Enter an Oracle business group ID from the list of IDs displayed on your
screen, then press Enter.

Each time you want to transfer a different business group ID, select it from the
screen and rerun the synclabor script.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

4 Review the [Link] file for errors.

Synchronizing Oracle Organizations and Locations

and Asset Management System Address Codes
You must map the Oracle Applications E-Business Suite organizations and
locations to the asset management system address codes. To synchronize the two
systems, you must first obtain a listing of the organizations and locations in the
Oracle Applications E-Business Suite and then define those codes in the asset
management system.

Oracle-specific Integration Controls and Data Synchronization 41

Synchronizing Oracle Organizations and Locations and Asset Management System Address Codes

Obtaining a list of Oracle Applications E-Business Suite

Organizations and Location Codes
To generate a list of Oracle organizations and locations, complete the following
steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

2 When prompted, press Enter.

You will see a list of Oracle organizations and locations that you must
manually map to the asset management system address codes as described in
the procedure that follows.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

Mapping Oracle Organizations and Locations to Asset

Management System Address Codes
The following procedure describes how to map the asset management system
address codes to the Oracle organizations and locations. Additionally, the
following table shows how to map the asset management system Bill To
Companies, Ship To Companies, and Bill To and Ship To contacts to the Oracle
Applications E-Business Suite.

Asset Oracle Applications Asset Management

Management E-Business Suite System definition
System

Bill to company Organization Address code

Ship to company Location Address code

Bill to contact Employee Labor code

Ship to contact Employee Labor code

To define an address code in the asset management system for an Oracle

organization or location, complete the following steps:

1 In the asset management system, select Go To > Administration >

Organizations.

2 Press Enter to display a list of organizations.

3 Click the name of the organization that you want to update.

4 Click the Address tab.

5 Click New Row.

42 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle and Asset Management System Currencies

6 Enter the Oracle location or organization in the Address Code field.

7 Enter the following address information:

T Long description
T Address
T City
T State/Province
T Zip/Postal Code
T Country

8 Click Save Organization.

Synchronizing Oracle and Asset Management

System Currencies
The asset management system and the Oracle Applications E-Business Suite must
use the same currency. To synchronize the two systems, you must first obtain a
listing of the currency codes in the Oracle Applications E-Business Suite and then
define those codes in the asset management system.

Obtaining a List of Oracle Applications E-Business Suite

Currency Codes
To obtain a listing of the currency codes in the Oracle Applications E-Business
Suite, complete the following steps:

1 Login to SQL* Plus and connect to the Oracle Applications E-Business Suite
database.

2 Enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file lists the currency codes defined in the Oracle
Applications E-Business Suite.

Oracle-specific Integration Controls and Data Synchronization 43

Synchronizing Oracle Vendors and Asset Management System Companies

Defining Oracle Currency Codes in Asset Management System

To define the Oracle currency codes in the asset management system, complete
the following steps:

1 In the asset management system, select Go To > Financial > Currency Codes.

2 Click New Row.

3 Enter a currency code in the Currency field and a description in the adjacent
text box.

4 Click Save Currency Code.

Synchronizing Oracle Vendors and Asset

Management System Companies
To synchronize the Oracle vendors and the asset management system companies,
you must run a script that defines the Oracle Applications E-Business Suite
vendors as companies in the asset management system.

Before you run the synchronization script, you must set up the Oracle vendor
type defaults in the asset management system as follows:

1 In the asset management system, select Go To > Financial > Chart of

Accounts.

2 Choose Select Action > Company-Related Accounts to open the Company-

Related Accounts screen.

3 Click New Row, then add the following information:

T Company Type (Courier, Manufacturer, or Vendor)

T RBNI Account
T AP Suspense Account
T AP Control Account

4 Repeat Steps 1 – 3 for each Oracle vendor type you expect to transfer to the
asset management system.

The newly defined asset management system company ID is a concatenation of

the Oracle operating unit ID, vendor ID, and vendor site code. Hyphens separate
the three segments.

The script adds the AP control account to each asset management system
company ID. If you plan on using invoicing, you must update each company ID
with an RBNI (received but not invoiced) and suspense account.

44 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle Vendors and Asset Management System Companies

To synchronize the Oracle vendors and the asset management system companies,
complete the following steps:

1 Navigate to the Install directory from Maximo_root. Locate and open the
[Link] file. You can edit this file by using a WHERE clause to accomplish
the following:

T To transfer all vendors to the asset management system

T Transfer selected vendors to the asset management system

2 Login to SQL*Plus and connect to the Oracle Applications E-Business Suite

database.

3 Enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

4 When prompted, press Enter.

5 Enter an Oracle operating unit ID from the list of IDs displayed on your
screen, then press Enter.

Each time you want to transfer a different operating unit ID, select it from the
screen and rerun the syncvnd script.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

6 Review the [Link] file for errors.

Updating the Asset Management System Company ID with an

RBNI and Suspense Account
To update the company ID with an RBNI and suspense account, complete the
following steps:

1 In the asset management system, select Go To > Purchasing > Companies.

2 Press Enter to display a list of company IDs.

3 Click the company you want to update to display the record in the Company
tab.

4 Click the Select Icon for the RBNI Account to open the Select GL Account
dialog box where you can build the RBNI account.

5 Repeat Step 4 for the Suspense Account.

6 Click Save Company.

Oracle-specific Integration Controls and Data Synchronization 45

Synchronizing Oracle Inventory Organizations and Asset Management System Storeroom Locations

Synchronizing Oracle Inventory Organizations and

Asset Management System Storeroom Locations
To synchronize the Oracle inventory organizations and the asset management
system storeroom locations, you must first obtain a listing of the organizations in
the Oracle Applications E-Business Suite, then define them as storerooms in the
asset management system.

Obtaining a List of Oracle Applications E-Business Suite

Organizations
To obtain a listing of the organizations and other control values from the Oracle
Applications E-Business Suite, complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

2 When prompted, press Enter to display a list of the Oracle Applications

E-Business Suite [Link] control values as shown in the following table.

Control Default value

APLINETYPE ITEM

GENSTORE Null or ORG_CODE

COAXREF Chart_of_accounts_ID

ORGXREF Ledger_ID

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

3 Review the [Link] file for any errors.

Defining Storerooms in the Asset Management System

To create a storeroom in the asset management system, complete the following
steps:

1 In the asset management system, select Go To > Inventory > Storerooms.

2 Click New Storeroom.

46 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle Order Units and Asset Management System Units of Measure

3 Enter data about the storeroom, including:

T Storeroom and site location

T GL account information
T Ship to and Bill to information

4 Click Save Storeroom.

Synchronizing Oracle Order Units and Asset

Management System Units of Measure
To synchronize the Oracle and the asset management system order units, you
must first obtain a listing of the order units in the Oracle Applications E-Business
Suite, then define them in the asset management system.

Obtaining a List of Oracle Applications E-Business Suite Order

Units
To obtain a listing of the order units in the Oracle Applications E-Business Suite,
complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

2 When prompted, press Enter.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] output file lists the units of measure defined in the Oracle
Applications E-Business Suite.

3 Review the [Link] file for any errors.

Defining Units of Measure and Conversion Factors in Asset

Management System
To define a unit of measure and a conversion factor in Asset Management System,
complete the following steps:

1 In asset management system, select Go To > Inventory > Item Master.

2 Choose Select Action > Unit of Measure and Conversion > Add/Modify
Units of Measure.

3 Click New Row.

Oracle-specific Integration Controls and Data Synchronization 47

Adding Tax Codes to Asset Management System

4 Enter the unit of measure, a long description, and an abbreviation for the unit
of measure. For example, you might enter GBYTE, GIGABYTE, and GB.

5 Click OK.

6 Additionally, if you wish to add a conversion factor for a unit of measure,

choose Select Action > Unit of Measure and Conversion > Add/Modify
Conversions.

For example, you might enter a conversion factor of 250 when converting a
unit of measure value of BOX to a unit measure value of FEET.

7 Click OK.

8 Click Save Item.

Adding Tax Codes to Asset Management System

Before you can synchronize the Oracle and the asset management system items,
you must define the Oracle tax codes that you use in asset management system.

Obtaining a List of Oracle Applications E-Business Suite Tax

Codes
To obtain a listing of the tax codes in the Oracle Applications E-Business Suite,
complete the following steps:

1 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

2 When prompted if OK to continue, press Enter.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file lists the tax codes defined in the Oracle Applications
E-Business Suite.

3 Review the [Link] file for any errors.

Defining Oracle Tax Codes in the Asset Management System

To define tax codes, complete the following steps:

1 In the asset management system, select Go To > Administration >

Organizations.

2 Press Enter to display a list of organizations.

48 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle and Asset Management System Items

3 Click an organization to open the record.

4 Click Select Action > Purchasing Options > Tax Options.

5 Click New Row.

6 Enter values for the following fields:

T Tax Code
T Tax Code Description
T Tax Rate
T Effective Date
T Paid Tax GL Account
T Unpaid Tax GL Account

7 Click OK.

8 Click Save Organization.

Synchronizing Oracle and Asset Management

System Items
To synchronize items between the two systems, you must complete the following
tasks:

T Verify integration control settings and financial periods

T Run a SQL script that transfers the Oracle items to the asset management
system
T Verify that the Oracle items were added to the Item Master in the asset
management system
T Define the item as a direct delivery item in Oracle (optional)

You must define individual or all items in an Oracle organization as direct

delivery so that you can receive an item in Oracle and then send the receipt to the
asset management system.

Items that belonged to an organization in the Oracle Applications E-Business

Suite belong to a storeroom in the asset management system after you run the
[Link] script.

For more information about integration controls and inventory management in

the asset management system, see the IBM Maximo Asset Management Integration
Guide.

Oracle-specific Integration Controls and Data Synchronization 49

Synchronizing Oracle and Asset Management System Items

To synchronize items across the two systems, complete the following steps:

1 Verify that the item-related asset management system integration controls for
the Oracle Adapter have the following default value setting:

Integration control Default value

ITEMIN 1

2 In Maximo, make sure that Default Item Status is set appropriately (for
example, to Active) at the Set and Organization levels. Items that come from
Oracle system will take the default item status defined at the Organization
level. Also, depending on the default item status, certain operations may not
be allowed on the Item in Maximo.

For more information about Item Status functionality, refer to IBM Maximo
Asset Management 7.1 documentation.

3 Ensure that the financial periods during which you synchronize items are
open in the asset management system.

For information on displaying the financial periods in Asset Management

System, see the IBM Maximo Asset Management Integration Guide.

4 Navigate to the Install directory from Maximo_root. Locate and open the
[Link] file. You can edit this file by using a WHERE clause to accomplish
the following:

T To transfer all items to the asset management system

T Transfer selected items to the asset management system

5 Login to SQL* Plus and connect to the Oracle Applications E-Business Suite
database.

6 Enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file contains a list of all the inventory items that you can
transfer to the asset management system.

7 Review the [Link] file for any errors.

8 Enter an Oracle item ID from the list of IDs displayed on your screen, then
press Enter.

Each time you want to transfer a different item ID, select it from the screen
and rerun the syncitm script.

50 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle and Asset Management System Items

9 To verify that you successfully transferred an Oracle item to the asset

management system, select Go To > Inventory > Item Master.

10 Enter the item number in the Item field, and press Enter.

11 If successfully transferred, the item search action displays a line item for the
record.

12 Click the Item number to open the detail record.

Oracle-specific Integration Controls and Data Synchronization 51

Synchronizing Oracle and Asset Management System Item Balances

Synchronizing Oracle and Asset Management

System Item Balances
If you want to transfer item balances from Oracle to the asset management
system, complete the following procedures. This synchronization transfers the
current balance and the bin number where the balance is located. Transferring
item balances is optional.

When testing reservations, receipts, and issues, you need a default bin. The script
in the following procedure defines the default bin.

Transferring Oracle Item Balances to the Asset Management

System
To transfer item balances from Oracle to the asset management system, complete
the following steps:

1 Navigate to the Install directory from Maximo_root. Locate and open the
[Link] file.

2 Edit this file by entering an organization ID in a WHERE clause that

represents the organization item balances that you wish to transfer.

3 Login to SQL* Plus, then enter the following commands:

SQL> start c:\MAXIMO\ORACLEAPIS\install\setofvar <Enter>

SQL> start &[Link] <Enter>

4 When prompted, press Enter.

The generated file is in the following location:

c:\MAXIMO\ORACLEAPIS\log\[Link]

The [Link] file lists the Oracle inventory organization IDs that can be
transferred to the asset management system.

5 Review the [Link] file for any errors.

Each time you want to transfer a different inventory balance, select the
inventory organization ID from the screen and rerun the syncbal script.

52 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Synchronizing Oracle and Asset Management System Item Balances

Verifying Item Balances in the Asset Management System

To verify that transferred items were updated with the correct balance and bin
number in the asset management system, complete the following steps:

1 In the asset management system, select Go To > Inventory > Inventory.

2 Type an item number in the Item field, and press Enter. Also, you can click the
Select Icon > Select Value, and click an item number from the displayed list of
items.

The summary line displays the current balance for the selected item.

3 Click the Inventory tab to view the item detail record, including bin and lot
numbers.

Oracle-specific Integration Controls and Data Synchronization 53

Synchronizing Oracle and Asset Management System Item Balances

54 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
MAXORA Schema Table
A
There are a number of asset management system-specific objects that are created
in the MAXORA schema by the Oracle Adapter. An Oracle database
administrator can use this list for reference purposes.

You should not drop, modify, move, or have additional grants issued for objects
listed below even though they are mentioned in this report.

The following table shows a list of the asset management system objects in the
MAXORA schema:

Object name Object type

APILOG SEQUENCE

API_APX_SP PROCEDURE

API_BAL_SP PROCEDURE

API_GLCC_PKG PACKAGE BODY

API_GLCC_PKG PACKAGE

API_GLCC_SP PROCEDURE

API_GLCC_TRG TRIGGER

API_GLCOMP_DESC_TRG TRIGGER

API_GLCOMP_SP PROCEDURE

API_GLCOMP_TRG TRIGGER

API_INVCAPPR_SP PROCEDURE

API_INVCAPPR_TRG TRIGGER

API_INVC_TRG TRIGGER

API_INV_SP PROCEDURE

API_ITEM_PKG PACKAGE BODY

API_ITEM_PKG PACKAGE

API_ITEM_SP PROCEDURE

API_LC_PA_SP PROCEDURE

API_LC_SP PROCEDURE

API_LOC_PKG PACKAGE BODY

API_LOC_PKG PACKAGE

© Copyright IBM Corp. 2008 55

 Object name Object type

API_MTLBAL_TRG TRIGGER

API_MTLISU_SP PROCEDURE

API_MTLITMTL_TRG TRIGGER

API_MTLITM_TRG TRIGGER

API_PA_COMPENSATION_TRG TRIGGER

API_PA_EMPLOYEE_TRG TRIGGER

API_PCX_SP PROCEDURE

API_PC_SP PROCEDURE

API_POACTION_TRG TRIGGER

API_POACT_PKG PACKAGE

API_POACT_PKG PACKAGE BODY

API_POAPPR_SP PROCEDURE

API_POAPPR_TRG TRIGGER

API_POIMP_TRG TRIGGER

API_POLINE_SP PROCEDURE

API_POLINE_TRG TRIGGER

API_POLX_SP PROCEDURE

API_POREL_TRG TRIGGER

API_POX_SP PROCEDURE

API_PRIMP_TRG TRIGGER

API_PR_SP PROCEDURE

API_PUT_ERROR_SP PROCEDURE

API_RCVROT_SP PROCEDURE

API_RCV_SERIAL_TRG TRIGGER

API_RCV_SP PROCEDURE

API_RECEIPT_TRG TRIGGER

API_VNDCONTUPD_SP PROCEDURE

API_VNDCONTUPD_TRG TRIGGER

API_VNDCONT_SP PROCEDURE

API_VNDCONT_TRG TRIGGER

API_VNDHDR_TRG TRIGGER

API_VNDSITE_TRG TRIGGER

API_VND_SP PROCEDURE

56 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Object name Object type

AP_INVOICES_ALL SYNONYM

AP_INVOICES_INTERFACE SYNONYM

AP_INVOICES_INTERFACE_S SYNONYM

AP_INVOICE_DISTRIBUTIONS SYNONYM

AP_INVOICE_DISTRIBUTIONS_ALL SYNONYM

AP_INVOICE_LINES_INTERFACE SYNONYM

AP_INVOICE_LINES_INTERFACE_S SYNONYM

AP_SUPPLIERS SYNONYM

AP_SUPPLIER_CONTACTS SYNONYM

AP_SUPPLIER_SITES_ALL SYNONYM

AP_TAX_CODES SYNONYM

AP_TERMS SYNONYM

CREATE_DEBUG_SP PROCEDURE

CREATE_INSERT_SP PROCEDURE

CREATE_TRIGGER_SP PROCEDURE

CST_ITEM_COSTS SYNONYM
CST_QUANTITY_LAYERS SYNONYM

CVROTITM_IFACE_NDX INDEX

ENTERPROC PROCEDURE

EXTRACT_FC_DATA PROCEDURE

FA_CATEGORIES SYNONYM

FINANCIALS_SYSTEM_PARAMETERS SYNONYM

FND_API SYNONYM

FND_APPLICATION_VL SYNONYM

FND_FILE SYNONYM

FND_FLEX_VALUES SYNONYM

FND_FLEX_VALUES_TL SYNONYM

FND_ID_FLEX_SEGMENTS SYNONYM

FND_ID_FLEX_STRUCTURES SYNONYM

FND_LANGUAGES SYNONYM

FND_MSG_PUB SYNONYM

FND_PRODUCT_GROUPS SYNONYM

FND_PROFILE_OPTIONS SYNONYM

FND_PROFILE_OPTION_VALUES SYNONYM

MAXORA Schema Table 57

 Object name Object type
FND_USER SYNONYM

GET_OPERID_SP PROCEDURE

GET_PA_ORGID_SP FUNCTION

GL_CODE_COMBINATIONS SYNONYM

GL_INTERFACE SYNONYM

GL_LEDGERS SYNONYM

GL_SETS_OF_BOOKS SYNONYM

HR_ALL_ORGANIZATION_UNITS SYNONYM

HR_EMPLOYEES SYNONYM

HR_LOCATIONS SYNONYM

HR_LOCATIONS_ALL SYNONYM

HR_OPERATING_UNITS SYNONYM

HZ_CONTACT_POINTS SYNONYM

HZ_LOCATIONS SYNONYM

HZ_ORG_CONTACTS SYNONYM

HZ_PARTIES SYNONYM

HZ_PARTY_SITES SYNONYM

HZ_RELATIONSHIPS SYNONYM

INVISSUE_IFACE_NDX INDEX

IN_INTER_TRANS_NDX INDEX

IS_PARENT_REJECTED FUNCTION

MAXAPIDEBUG PACKAGE BODY

MAXAPIDEBUG PACKAGE

MAXAPIERRORS PACKAGE

MAXAPIERRORS PACKAGE BODY

MAXAPIINSERT PACKAGE BODY

MAXAPIINSERT PACKAGE

MAXAPISET PACKAGE BODY

MAXAPISET PACKAGE

MAXAPITRIGGER PACKAGE BODY

MAXAPITRIGGER PACKAGE

MAXDEBUGAPI PACKAGE BODY

MAXDEBUGAPI PACKAGE

MAXIFACETRANSSEQ SEQUENCE

MAXORACTLS TABLE

58 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Object name Object type
MAXORACTLS_TRG TRIGGER

MAXORALOG TABLE

MAXPCPACK PACKAGE BODY

MAXPCPACK PACKAGE

MAXPOPACK PACKAGE BODY

MAXPOPACK PACKAGE

MAXSEQ SEQUENCE

MAXUTLPACK PACKAGE BODY

MAXUTLPACK PACKAGE

MOF_USR_APX_SP PROCEDURE

MOF_USR_AP_SP PROCEDURE

MOF_USR_BAL_SP PROCEDURE

MOF_USR_COA_SP PROCEDURE

MOF_USR_FC_SP PROCEDURE

MOF_USR_GLCOMP_SP PROCEDURE

MOF_USR_INV_SP PROCEDURE

MOF_USR_ISU_SP PROCEDURE

MOF_USR_ITM_SP PROCEDURE

MOF_USR_LC_PA_SP PROCEDURE

MOF_USR_LC_SP PROCEDURE

MOF_USR_PCX_SP PROCEDURE

MOF_USR_PC_SP PROCEDURE

MOF_USR_POLX_SP PROCEDURE

MOF_USR_POX_SP PROCEDURE

MOF_USR_PO_SP PROCEDURE

MOF_USR_PR_SP PROCEDURE

MOF_USR_RCVROT_SP PROCEDURE

MOF_USR_RCV_SP PROCEDURE

MOF_USR_VNDCONT_SP PROCEDURE

MOF_USR_VND_SP PROCEDURE

MO_GLOBAL SYNONYM

MTL_CATEGORY_SET_VALID_CATS SYNONYM

MTL_DEFAULT_CATEGORY_SETS SYNONYM

MTL_DEFAULT_SETS_VIEW SYNONYM

MTL_DEMAND SYNONYM

MAXORA Schema Table 59

 Object name Object type
MTL_ITEM_CATEGORIES SYNONYM

MTL_ITEM_LOCATIONS SYNONYM

MTL_MATERIAL_TRANSACTIONS SYNONYM

MTL_MATERIAL_TRANSACTIONS_S SYNONYM

MTL_ONHAND_QUANTITIES SYNONYM

MTL_PARAMETERS SYNONYM

MTL_PHYSICAL_ADJUSTMENTS SYNONYM

MTL_RESERVATIONS_INTERFACE SYNONYM

MTL_RESERVATIONS_INTERFACE_S SYNONYM

MTL_SECONDARY_INVENTORIES SYNONYM

MTL_SERIAL_NUMBERS_INTERFACE SYNONYM

MTL_SYSTEM_ITEMS SYNONYM

MTL_SYSTEM_ITEMS_INTERFACE SYNONYM

MTL_SYSTEM_ITEMS_TL SYNONYM

MTL_TRANSACTION_ACCOUNTS SYNONYM

MTL_TRANSACTION_LOTS_INTERFACE SYNONYM

MTL_TRANSACTION_LOT_NUMBERS SYNONYM

MTL_TXN_SOURCE_TYPES SYNONYM

MTL_UNITS_OF_MEASURE SYNONYM

MTL_UNIT_TRANSACTIONS SYNONYM

MTL_UOM_CLASSES SYNONYM

MTL_UOM_CONVERSIONS SYNONYM

MXCOA_IFACE TABLE

MXCOA_IFACE_NDX INDEX

MXCRAFT_IFACE TABLE

MXCRAFT_IFACE_NDX INDEX

MXE_AP_SP PROCEDURE

MXE_GL_SP PROCEDURE

MXE_INVRESERVE_SP PROCEDURE

MXE_INV_SP PROCEDURE

MXE_ITM_SP PROCEDURE

MXE_PA_ACT_SP PROCEDURE

MXE_PR_SP PROCEDURE

MXE_RCV_LOT_SP PROCEDURE

MXE_RCV_SER_SP PROCEDURE

60 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Object name Object type
MXE_RCV_SP PROCEDURE

MXE_USR_AP_SP PROCEDURE

MXE_USR_GLOUTX_SP PROCEDURE

MXE_USR_GL_SP PROCEDURE

MXE_USR_INVRESERVE_SP PROCEDURE

MXE_USR_INV_SP PROCEDURE

MXE_USR_ITM_SP PROCEDURE

MXE_USR_PA_ACT_SP PROCEDURE

MXE_USR_PC_SP PROCEDURE

MXE_USR_PO_SP PROCEDURE

MXE_USR_PRT_SP PROCEDURE

MXE_USR_PR_SP PROCEDURE

MXE_USR_RCV_LOT_SP PROCEDURE

MXE_USR_RCV_SER_SP PROCEDURE

MXE_USR_RCV_SP PROCEDURE

MXGLCOMP_IFACE TABLE

MXGLCOMP_IFACE_NDX INDEX

MXGLTXN_IFACE TABLE

MXGLTXN_IFACE_NDX INDEX

MXGLTXN_IFACE_TRG TRIGGER

MXINVBAL_IFACE TABLE

MXINVBAL_IFACE_NDX INDEX

MXINVENTORY_IFACE TABLE

MXINVENTORY_IFACE_TRG TRIGGER

MXINVISSUE_IFACE TABLE

MXINVOICE_IFACE TABLE

MXINVOICE_IFACE_TRG TRIGGER

MXINVRES_IFACE TABLE

MXINVRES_IFACE_NDX INDEX

MXINVRES_IFACE_TRG TRIGGER

MXIN_INTER_TRANS TABLE

MXITEM_IFACE TABLE

MXITEM_IFACE_NDX INDEX

MXITEM_IFACE_TRG TRIGGER

MXI_USR_GLINX_SP PROCEDURE

MAXORA Schema Table 61

 Object name Object type
MXLABOR_IFACE TABLE

MXLABOR_IFACE_NDX INDEX

MXOUT_INTER_NDX2 INDEX

MXOUT_INTER_TRANS TABLE

MXPC_IFACE TABLE

MXPC_IFACE_NDX INDEX

MXPC_IFACE_TRG TRIGGER

MXPO_IFACE TABLE

MXPO_IFACE_NDX INDEX

MXPO_IFACE_TRG TRIGGER

MXPROJTXN_IFACE TABLE

MXPROJTXN_IFACE_TRG TRIGGER

MXPROJ_IFACE TABLE

MXPROJ_IFACE_NDX INDEX

MXPR_IFACE TABLE

MXPR_IFACE_NDX INDEX

MXPR_IFACE_TRG TRIGGER

MXRCVROTITM_IFACE TABLE

MXRECEIPT_IFACE TABLE

MXRECEIPT_IFACE_TRG TRIGGER

MXVENDOR_IFACE TABLE

MXVENDOR_IFACE_NDX INDEX

MX_SQL PROCEDURE

NVENTORY_IFACE_NDX INDEX

OF_ID_PKG PACKAGE BODY

OF_ID_PKG PACKAGE

ORG_ORGANIZATION_DEFINITIONS SYNONYM

PA_ALL_ORGANIZATIONS SYNONYM

PA_BILL_RATES_ALL SYNONYM

PA_BUDGET_TYPES SYNONYM

PA_BUDGET_VERSIONS SYNONYM

PA_COMPENSATION_DETAILS_ALL SYNONYM

PA_IMPLEMENTATIONS SYNONYM

PA_NON_LABOR_RESOURCES SYNONYM

PA_PROJECTS_ALL SYNONYM

62 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Object name Object type
PA_PROJECT_ACCUM_ACTUALS SYNONYM

PA_PROJECT_ACCUM_BUDGETS SYNONYM

PA_PROJECT_ACCUM_COMMITMENTS SYNONYM

PA_PROJECT_ACCUM_HEADERS SYNONYM

PA_STD_BILL_RATE_SCHEDULES_ALL SYNONYM

PA_TASKS SYNONYM

PA_TRANSACTION_INTERFACE SYNONYM

PA_TRANSACTION_SOURCES SYNONYM

PER_ADDRESSES SYNONYM

PER_ALL_ASSIGNMENTS_F SYNONYM

PER_ALL_PEOPLE_F SYNONYM

PER_ASSIGNMENT_STATUS_TYPES SYNONYM

PER_BUSINESS_GROUPS SYNONYM

PER_JOBS SYNONYM

PER_PAY_BASES SYNONYM

PER_PAY_PROPOSALS SYNONYM

PO_ACTION_HISTORY SYNONYM

PO_AGENTS SYNONYM

PO_API_ERRORS_REC_TYPE SYNONYM

PO_CANCEL_IFACE TABLE

PO_CHANGE_API1_S SYNONYM

PO_DISTRIBUTIONS SYNONYM

PO_DISTRIBUTIONS_INTERFACE SYNONYM

PO_DISTRIBUTIONS_INTERFACE_S SYNONYM

PO_DISTRIBUTIONS_S SYNONYM

PO_DOCUMENT_CONTROL_PUB SYNONYM

PO_HAZARD_CLASSES SYNONYM

PO_HEADERS SYNONYM

PO_HEADERS_ALL SYNONYM

PO_HEADERS_INTERFACE SYNONYM

PO_HEADERS_INTERFACE_S SYNONYM

PO_HEADERS_S SYNONYM

PO_LINES SYNONYM

PO_LINES_ALL SYNONYM

PO_LINES_INTERFACE SYNONYM

MAXORA Schema Table 63

 Object name Object type
PO_LINES_INTERFACE_S SYNONYM

PO_LINES_S SYNONYM

PO_LINE_LOCATIONS SYNONYM

PO_LINE_LOCATIONS_ALL SYNONYM

PO_LINE_LOCATIONS_S SYNONYM

PO_LINE_TYPES SYNONYM

PO_LOOKUP_CODES SYNONYM

PO_RELEASES SYNONYM

PO_RELEASES_ALL SYNONYM

PO_RELEASES_S SYNONYM

PO_REQUISITIONS_INTERFACE SYNONYM

PO_REQUISITIONS_INTERFACE_ALL SYNONYM

PO_REQUISITION_HEADERS SYNONYM

PO_REQUISITION_HEADERS_ALL SYNONYM

PO_REQUISITION_LINES SYNONYM

PO_REQ_DISTRIBUTIONS SYNONYM

PO_SYSTEM_PARAMETERS_ALL SYNONYM

PO_UNIQUE_IDENTIFIER_CONTROL SYNONYM

PO_UN_NUMBERS SYNONYM

PO_UPDATE_IFACE TABLE

PUT_IN_LOG PROCEDURE

RCV_HEADERS_INTERFACE SYNONYM

RCV_HEADERS_INTERFACE_S SYNONYM

RCV_INTERFACE_GROUPS_S SYNONYM

RCV_ROUTING_HEADERS SYNONYM

RCV_SERIAL_TRANSACTIONS SYNONYM

RCV_SHIPMENT_HEADERS SYNONYM

RCV_SHIPMENT_LINES SYNONYM

RCV_TRANSACTIONS SYNONYM

RCV_TRANSACTIONS_INTERFACE SYNONYM

RCV_TRANSACTIONS_INTERFACE_S SYNONYM

RESP_ID_PKG PACKAGE

RESP_ID_PKG PACKAGE BODY

RETPROC PROCEDURE

RETPROCERROR FUNCTION

64 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Object name Object type
SET_OPERID_SP PROCEDURE

UT_INTER_TRANS_NDX INDEX

XINVOICE_IFACE_NDX INDEX

XPROJTXN_IFACE_NDX INDEX

XRECEIPT_IFACE_NDX INDEX

MAXORA Schema Table 65

66 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Request Sets and
Purchase Order Imports
B
You can create a POIMPORT request set and use this set to send PO updates from
the asset management system to the Oracle Applications E-Business Suite.

To register the POIMPORT procedure complete the following steps in the Oracle
Applications E-Business Suite:

1 Select Responsibility > System Administrator.

2 Select Concurrent > Program > Executable.

3 Enter the following:

Executable: POIMPORT

Short Name: POIMPORT

Application: Purchasing

Description: Import Asset Management System PO Updates

and Cancellations

Execution Method: PL/SQL Stored Procedure

Execution File Name: [Link]

The schema name, MAXORA, should be replaced by the schema name used in
your installation.

4 Click Save.

5 Close the form.

6 Select Concurrent > Program > Define.

© Copyright IBM Corp. 2008 67

 7 Enter the following values on screen:

Program: MAXORA: Import Asset Management System PO

Updates and Cancellations

Enable Select this check box

Short Name: POIMPORT

Application: Purchasing

Description: Import Asset Management System PO Updates and

Cancellations

Executable Name: POIMPORT

Executable Method: PL/SQL Stored Procedure

8 Click Save.

9 Click Incompatibilities.

10 In the Name field, select MAXORA: Import Asset Management System PO

Updates and Cancellations.

11 Click Save.

12 Close the form.

To provide access to Purchase Responsibility, you must complete the following

steps the Oracle Applications E-Business Suite:

1 Select Security > Responsibility > Request.

2 Press <F11> to enter the Query mode.

3 In the Group field, enter All Reports.

4 In the Application field, enter Purchasing.

5 Press <CTRL+F11> to execute the query.

6 Place the cursor on one of the rows in the Requests table and
select File > New.

7 Enter the following values on screen:

Type: Program

Name: MAXORA: Import Asset Management System PO Updates

and Cancellations

Application: Purchasing

8 Click Save.

68 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Submitting the Import Process
To submit the import process, you must complete the following steps in the
Oracle Applications E-Business Suite:

1 Select Responsibility > Purchasing.

2 Click OK.

3 Select Reports > Run.

4 Select the Single Request option and click OK.

5 Enter the name MAXORA: Import Asset Management System PO Updates

and Cancellations.

„ If you want to start importing the report for the current data,
click Submit.
„ If you want the report to run on the background for a given time interval
(for example, every 5 minutes), then continue with the steps below:

a Click Schedule.

b Select Periodically. Fill in the Start and End date fields.

c Select Run Every 5 Minute(s) from the drop-down menu, or any other
time interval you may need for the report to run.

d Select the Save this Schedule check box.

e Click OK.

The request now runs every five minutes for the period established
between the Start and End dates. The request also imports all the purchase
order updates from the interface tables.

Request Sets and Purchase Order Imports 69

70 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Asset Management
System Column Lengths
C
There are tables and columns that you must resize after you install the Oracle
Adapter or the integration with Oracle Project Accounting.

The asset management system table columns must be compatible with those in
Oracle Applications E-Business Suite. If columns are not compatible, the asset
management system cannot store the data it receives from the Oracle
Applications E-Business Suite.

Table columns shared by the two systems must have the following properties in
common:

T Data type
T Maximum column length (a length sufficient to contain the data)
T Null settings

© Copyright IBM Corp. 2008 71

Changes in the Database Configuration Application

Changes in the Database Configuration Application

You can use the asset management system Database Configuration application to
make the following table columns compatible with the columns in the Oracle
Applications E-Business Suite.

The size shown is a recommended size only.

Type Table Column Size

ALN ADDRESS ADDRESSCODE 60

ADDRESS ADDRESS1 240

CHARTOFACCOUNTS ACCOUNTNAME 240

COMPANIES ADDRESS1 240

COMPANIES ADDRESS3 150

COMPANIES BANKACCOUNT 55

COMPANIES COMPANY 57

COMPANIES CONTACT 52

COMPANIES CUSTOMERNUM 25

COMPANIES FAX 26

COMPANIES FOB 25

COMPANIES NAME 240

COMPANIES PAYMENTTERMS 50

COMPANIES PHONE 26

COMPANIES SHIPVIA 25

COMPANIES TYPE 30

COMPCONTACT POSITION 30

ALN CONTRACT CONTRACTNUM 20

CRAFT CRAFT 240

CRAFT DESCRIPTION 240

CURRENCY CURRENCYCODE 15

GLCOMPONENTS COMPTEXT 240

GLCOMPONENTS COMPVALUE 150

GLCOMPONENTS EXTERNALREFID 15

INVENTORY BINNUM 49

INVENTORY MODELNUM 25

INVLOT LOTNUM 30

INVOICE DESCRIPTION 240

72 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Changes in the Domains Application

Type Table Column Size

INVOICE DOCUMENTTYPE 25

INVOICE INVOICENUM 50

ITEM DESCRIPTION 240

ALN ITEM ITEMNUM 40

ITEM MSDSNUM 40

MATRECTRANS PACKINGSLIPNUM 25

MATRECTRANS REJECTCODE 30

ALN MEASUREUNIT MEASUREUNITID 25

ALN PO PONUM 20

PO POTYPE 25

PRLINE REMARK 240

Changes in the Domains Application

You can use the asset management system Domains application to make the
following change to the length of the COMPTYPE domain. For information about
the Domains application, see the IBM Maximo Asset Management System
Administrator Guide or the online help for the Domains application.

Domain New size

COMPTYPE 30

Post-Update Activities
After you reconfigure the asset management system database, you must perform
the following procedures:

T Create the asset management system interface tables in the Oracle

Applications E-Business Suite database.

T Install the Oracle Applications E-Business Suite database packages,

procedures, triggers, and other objects.

73
Post-Update Activities

74 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Oracle Applications
E-Business Suite
Configuration
D
When you setup and configure the Oracle Applications E-Business Suite for the
asset management system integration, you must create and configure the ship to
locations, general ledger accounts, and accounts payable capabilities. You can use
general ledger accounts to import journals from the asset management system.
You also can use the accounts payable capabilities to import invoices from the
asset management system.

For procedures, you must enter the key value in both the general ledger accounts
and accounts payable fields.

© Copyright IBM Corp. 2008 75

Creating a Ship to Location

Creating a Ship to Location

The ship to locations in the asset management system must be defined as ship to
locations in the Oracle Applications E-Business Suite. Purchase requisitions and
purchase orders use this information.

To define a ship to location, complete the following steps:

1 Sign on to the Oracle Applications E-Business Suite as a user with purchasing

responsibility.

2 In the Navigator window, double-click Setup.

3 Double-click Organizations.

4 Double-click Locations. The Location window opens.

5 In the Location window, enter a ship to location in the Name field and a
description in the Description field.

6 On the Address Details tab, tab to the Address Style field and click the value
list button [...]. The Address Styles dialog box opens.

7 Select United States and click OK. The Location Address window opens.

8 Enter values in the Address Line 1, City, State, Zip Code and County fields.

9 Click OK.

10 On the Shipping Details tab, enter values in the Contact and Ship-To Location
fields, and select the Ship-To Site check box. Select or clear other check boxes
as needed.

11 On the Other Details tab, tab to the Inventory Organization field, and click the
value list button [...]. The Inventory Organizations dialog box opens.

12 Select the applicable inventory organization, and click OK.

13 Click the Save icon.

Setting Up a General Ledger to Import Journals from

the Asset Management System
When you set up a general ledger, you must ensure that the financial periods are
open for the test journal import. You also must ensure that you only import a
transaction in the asset management system that falls within any open periods in
the Oracle Applications E-Business Suite general ledger.

76 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Setting Up a General Ledger to Import Journals from the Asset Management System

To set up general ledger to import journal entries from the asset management
system, complete the following steps.

An asterisk (*) next to a field name means you must enter or select the value
shown.

1 Sign on to the Oracle Applications E-Business Suite as a user with general

ledger responsibility.

2 Double-click Setup.

3 Double-click Journal.

4 Double-click Sources. The Journal Sources window opens.

5 In the Journal Sources window, enter the following values:

Field Value

Source* MAXIMO

Description Asset Management System

Journal Import

Import Journal References Yes [selected]

6 Click the Save icon.

7 Close the Journal Sources window.

8 In the Navigator window, double-click Categories. The Journal Categories

window opens.

9 Enter the following values:

Field Value

Category Use the asset management system Cross

Reference Controls (JECATXREF) to
configure journal categories (Go To >
Integration > External Systems >
Integration Controls).

Description Asset Management System Journal Entry

10 Click the Save icon.

Oracle Applications E-Business Suite Configuration 77

Setting Up Accounts Payable to Import Invoices from the Asset Management System

Setting Up Accounts Payable to Import Invoices

from the Asset Management System
To set up the accounts payable to import invoices from the asset management
system, complete the following steps.

An asterisk (*) next to a field name means you must enter or select the value
shown.

1 Sign on to the Oracle Applications E-Business Suite as a user with Payables

responsibility.

2 In the Navigator window, double-click Setup.

3 Double-click Lookups.

4 Double-click Payables. The Oracle Public Sector Payables Lookups window

opens.

5 On the menu bar, click View > Query by Example > Enter.

6 Enter Source in the Type field.

7 On the menu bar, click View > Query by Example > Run.

8 Click the New icon.

9 In the new row, enter the following values:

Field Value

Code* MAXIMO

Enabled Yes [Selected]

10 Click the Save icon.

78 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 E
oo

Oracle Project
Accounting
Configurations
When you install and configure the integration between the asset management
system and Oracle Project Accounting (the Projects integration), you must be
familiar with the installation prerequisites and the configuration activities.

ATTENTION You must completely install and configure the Maximo Enterprise Adapter for
Oracle Applications before you install the Projects integration.

To complete these procedures, you need the following documentation:

T IBM Maximo Enterprise Adapter System Administrator Guide for Oracle

Applications 12 Adapter

T The most recent Maximo Enterprise Adapter for Oracle Applications 12

patch release notes

© Copyright IBM Corp. 2008 79

Configuration Prerequisites

Configuration Prerequisites
Before you configure the Projects integration, you must define the following
values. You might already have performed much of this configuration when you
installed the Maximo Enterprise Adapter for Oracle Applications.

T Budget entry methods

T Budget types
T Expenditure categories
T Expenditure types
T Labor and craft (as Oracle employees)
T Non-labor resources
T Project templates
T Project types
T Resource lists
T Transaction sources

For information about these values, refer to your Oracle Applications E-Business
Suite documentation.

Configuration Activities
Depending on the combination of processes that you perform (installing the
Oracle Adapter, installing the Projects integration, installing patches, and
applying manual updates), there may be some overlap in the required activities. If
you encounter the same activity a second time, perform it a second time. Skipping
a duplicate procedure might cause errors.

Configuring the Projects integration involves the activities shown in the following
table. All the activities may not apply to you.

Configuration activity

[ ] Update database column lengths.

[ ] Enable new publish channels, enterprise services and integration event

listener.

[ ] Configure the Projects-specific asset management system integration

controls.

[ ] Add fields to user interfaces.

[ ] Enable the financial control concurrent extract manager.

[ ] Provide access to the financial control concurrent extract manager.

[ ] Synchronize the Oracle employees and the asset management system

labor codes.

80 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Update Database Column Lengths

Use the Asset Management System Database Configuration application to resize
the following columns in the Asset Management System database tables.

Table Column Change type Size

CRAFT CRAFT ALN 240

CRAFT DESCRIPTION ALN 240

Enable New Publish Channels, Enterprise Services, and the

Integration Event Listener
The Projects integration adds the following enterprise service and publish
channel:

T MXPROJ_FROA12
T MXPROJTXN_TOOA12

The Projects integration also uses the MXGLTXN_OA12 publish channel.

To enable the new publish channels and enterprise services see the enabling
publish channels and enterprise services information.

Configure Projects-specific Asset Management System

Integration Controls
The Projects integration uses the following Projects-specific asset management
system integration controls:

T CHARGEORG
T EXPENDITEM
T EXPENDLABOR
T EXPENDTOOL
T FCSTATUSXREF
T NLRORG
T PROJAP
T PROJPO
T PROJPR
T PROJSEND
T RESLEVELITEM
T RESLEVELLABOR
T RESLEVELTOOL
T SRCTIM
T SRCUSE

The Projects integration also uses the PROJPAY Oracle processing control to
determine whether to extract cost rates from Oracle Human Resources (value 0)
or Oracle Project Accounting (value 1). The default value of the control is 1 when
the Projects integration is installed.

Oracle Project Accounting Configurations 81

Configuration Activities

For details about these controls, see the Projects Accounting information in the
IBM Maximo Enterprise Adapter System Administrator Guide for Oracle Applications
12 Adapter.

For information on configuring the Asset Management System integration

controls, see the IBM Maximo Asset Management Integration Guide or the online
help for the External Systems application.

Add Fields to User Interfaces

The following table lists hidden fields that you might need to add to the user
interfaces in the asset management system work order, purchasing, inventory,
and cost management applications. In some cases adding the field is optional,
depending on your business practices.

You add these fields through the Application Designer application in the Asset
management system configuration module.

Application Page Field Required or

optional

Work Order Tracking Work Order tab Project ID Required

Task ID

Labor subtab of Actuals tab Expenditure type See text

Materials subtab of Actuals tab Expenditure type See text

Charge organization
Non-labor charge organization

Tools subtab of Actuals tab Expenditure type See text

Charge organization
Non-labor charge organization

Services subtab of Actuals tab Expenditure type See text

Charge organization
Non-labor charge organization

Note: On the Services subtab,

the fields are display only

Purchase Requisitions PR Lines tab Expenditure type See text

Charge organization

Purchase Orders PO Lines tab Expenditure type See text

Charge organization

Receipts Material receipts tab Expenditure type See text

Charge organization
Non-labor charge organization

Service Receipts tab Expenditure type See text

Charge organization
Non-labor charge organization

Invoices Invoice Lines tab Expenditure type See text

Charge organization

82 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Application Page Field Required or

optional

Issues and Transfers Issue Expenditure type See text

Charge organization
Non-labor charge organization

Cost Management Project tab Budget Cost Optional

Burdened Cost
Committed Cost
Remaining Cost

Expenditure type fields You do not have to add the expenditure type field if your business does one of the
following:

T Uses a single expenditure type for items, a single expenditure type for
labor, and a single expenditure type for tools

T Uses item number, labor code, and tool code as expenditure types

In these cases, transactions that require these values use the default values in the
EXPENDITEM, EXPENDLABOR, and EXPENDTIOOL integration controls,
respectively.

In all other cases, add the expenditure type field to the applicable user interfaces.

Charge organization and You do not need to add the charge organization and non-labor resource
non-labor resource organization fields if your business uses a single charge organization and a single
organization fields non-labor resource organization for all transactions. Transactions that require
these values will use the default values in the CHARGEORG and NLRORG
integration controls, respectively.

If your business uses multiple charge or non-labor resource organizations, add

the two fields to the applicable user interfaces.

Adding Fields to the Work Order Tracking Application

The following procedures add the required and optional Work Order Tracking
fields. If you do not want to add an optional field, skip the corresponding
procedure. You must add the project ID and task ID fields to the Work Order tab.

To add the project ID and task ID fields to the Work Order tab, complete the
following steps:

1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Work Order subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

Add project ID to the 4 Drag the Textbox in the Controls dialog box below the Is Task field.
Work Order tab
Do not close the Controls dialog box until you finish this procedure.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

Oracle Project Accounting Configurations 83

Configuration Activities

6 In the Attribute field, enter FCPROJECTID.

7 In the Lookup field, enter PARENTPROJECT.

8 Move the cursor to the next field in the Textbox Properties dialog box. Do not
close the Textbox Properties dialog box until you finish this procedure.

Add task ID to the Work 9 Drag the Textbox in the Controls dialog box to the space below the new
Order tab Project ID field.

10 Ensure that the new textbox field is highlighted, then enter FCTASKID in the
Attribute field of the Textbox Properties dialog box.

11 In the Lookup field, enter PARENTTASK.

12 Move the cursor to the next field in the Textbox Properties dialog box.

13 Close the Controls dialog box and the Textbox Properties dialog box.

14 Click the Save Application Definition.

Add expenditure type to To add the expenditure type field to the Labor [Actuals] subtab, complete the
the Labor [Actuals] following steps:
Subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Labor subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Labor
subtab where you want the expenditure type field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_EXPENDTYPE (object LABTRANS).

8 Move the cursor to the next field in the Textbox Properties dialog box, then
close the dialog box.

9 Click the Save Application Definition.

Add expenditure type to To add the expenditure type field to the Materials [Actuals] subtab, complete the
the Materials [Actuals] following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Materials subtab.

84 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Materials
subtab where you want the expenditure type field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_EXPENDTYPE (object MATUSETRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Add charge organization To add the charge organization field to the Materials [Actuals] subtab, complete
to the Materials [Actuals] the following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Materials subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Materials
subtab where you want the charge organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_CHARGE_ORG (object MATUSETRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Oracle Project Accounting Configurations 85

Configuration Activities

Add non-labor resource To add the non-labor resource organization field to the Materials [Actuals]
organization to the subtab, complete the following steps:
Materials [Actuals]
subtab 1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Materials subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Materials
subtab where you want the non-labor resource organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_NLR_ORG (object MATUSETRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Add expenditure type to To add the expenditure type field to the Services [Actuals] subtab, complete the
the Services [Actuals] following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Services subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Services
subtab where you want the expenditure type field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_EXPENDTYPE (object SERVRECTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

86 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Add charge organization To add the charge organization field to the Services [Actuals] subtab, complete the
to the Service [Actuals] following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Services subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Services
subtab where you want the charge organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_CHARGE_ORG (object SERVRECTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Add non-labor resource To add the non-labor resource organization field to the Services [Actuals] subtab,
organization to the complete the following steps:
Services [Actuals]
subtab 1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Services subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Services
subtab where you want the non-labor resource organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_NLR_ORG (object SERVRECTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Oracle Project Accounting Configurations 87

Configuration Activities

Add expenditure type to To add the expenditure type field to the Tools [Actuals] subtab, complete the
the Tools [Actuals] following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Tools subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Tools subtab
where you want the expenditure type field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_EXPENDTYPE (object TOOLTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Add charge organization To add the charge organization field to the Tools [Actuals] subtab, complete the
to the Tools [Actuals] following steps:
subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Tools subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Tools subtab
where you want the charge organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_CHARGE_ORG (object TOOLTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

88 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Add non-labor resource To add the non-labor resource organization field to the Tools [Actuals] subtab,
organization to the Tools complete the following steps:
[Actuals] subtab
1 On the Applications tab in the Application Designer, select WOTRACK.

2 On the Workspace tab, click the Actuals subtab.

3 On the Actuals subtab, click the Tools subtab.

4 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

5 Drag the Textbox in the Controls dialog box to the location on the Tools subtab
where you want the non-labor resource organization field to appear.

6 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

7 In the Attribute field, select OA_NLR_ORG (object TOOLTRANS).

8 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

9 Click the Save Application Definition.

Adding Fields to Purchase Requisition Application

The following procedures add the optional purchase requisition fields. If you do
not want to add a field, skip the corresponding procedure.

Add expenditure type to To add the expenditure type field to the purchase requisition (PR) application,
the PR Lines tab complete the following steps:

1 On the Applications tab in the Application Designer, select PR.

2 On the Workspace tab, click the PR Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object PRLINE)

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Oracle Project Accounting Configurations 89

Configuration Activities

Add charge organization To add the charge organization field to the purchase requisition (PR) application,
to the PR Lines tab complete the following steps:

1 On the Applications tab in the Application Designer, select PR.

2 On the Workspace tab, click the PR Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object PRLINE).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Adding Fields to the Purchase Order Application

The following procedures add the optional purchase order fields. If you do not
want to add a field, skip the corresponding procedure.

Add expenditure type to To add the expenditure type field to the purchase order (PO) application,
the PO Lines tab complete the following steps:

1 On the Applications tab in the Application Designer, select PO.

2 On the Workspace tab, click the PO Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object POLINE).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

90 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Add charge organization To add the charge organization field to the purchase order (PO) application,
to the PO Lines tab complete the following steps:

1 On the Applications tab in the Application Designer, select PO.

2 On the Workspace tab, click the PO Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object POLINE).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Adding Fields to the Invoice Application

The following procedures add the optional invoice fields. If you do not want to
add a field, skip the corresponding procedure.

Add expenditure type to To add the expenditure type field to the Invoice application, complete the
the Invoice Lines tab following steps:

1 On the Applications tab in the Application Designer, select INVOICE.

2 On the Workspace tab, click the Invoice Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object INVOICELINE)

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Oracle Project Accounting Configurations 91

Configuration Activities

Add charge organization To add the charge organization field to the Invoice application, complete the
to the Invoice Lines tab following steps:

1 On the Applications tab in the Application Designer, select INVOICE.

2 On the Workspace tab, click the Invoice Lines subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object INVOICELINE).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Adding Fields to the Receipts Application

The following procedures add the optional receipts fields. If you do not want to
add a field, skip the corresponding procedure.

Add expenditure type to To add the expenditure type field to the Material Receipts tab, complete the
the Material Receipts tab following steps:

1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Material Receipts subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object MATRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

92 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Add charge organization To add the charge organization field to the Material Receipts tab, complete the
to the Material Receipts following steps:
tab
1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Material Receipts subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object MATRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add non-labor resource To add the non-labor resource organization field to the Material Receipts tab,
organization to the complete the following steps:
Material Receipts tab
1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Material Receipts subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the non-labor resource organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_NLR_ORG (object MATRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add expenditure type to To add the expenditure type field to the Service receipts tab, complete the
the Service Receipts tab following steps:

1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Service receipts subtab.

Oracle Project Accounting Configurations 93

Configuration Activities

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location on where you want
the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object SERVRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add charge organization To add the charge organization field to the Service Receipts tab, complete the
to the Service Receipts following steps:
tab
1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Service Receipts subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object SERVRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add non-labor resource To add the non-labor resource organization field to the Service Receipts tab,
organization to the complete the following steps:
Service Receipts tab
1 On the Applications tab in the Application Designer, select RECEIPTS.

2 On the Workspace tab, click the Service Receipts subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the non-labor resource organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

94 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

6 In the Attribute field, select OA_NLR_ORG (object SERVRECTRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Adding Fields to the Issues and Transfers Application

The following procedures add the optional issue fields. If you do not want to add
a field, skip the corresponding procedure.

Add expenditure type to To add the expenditure type field to the Issue subtab, complete the following
the Issue subtab steps:

1 On the Applications tab in the Application Designer, select INVISSUE.

2 On the Workspace tab, click the Issue subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location on the Issue subtab
where you want the expenditure type field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_EXPENDTYPE (object MATUSETRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add charge organization To add the charge organization field to the Issue subtab, complete the following
to the Issue subtab steps:

1 On the Applications tab in the Application Designer, select INVISSUE.

2 On the Workspace tab, click the Issue subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location on the Issue subtab
where you want the charge organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_CHARGE_ORG (object MATUSETRANS).

Oracle Project Accounting Configurations 95

Configuration Activities

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add non-labor resource To add the non-labor resource organization field to the Issue subtab, complete the
organization to the Issue following steps:
subtab
1 On the Applications tab in the Application Designer, select INVISSUE.

2 On the Workspace tab, click the Issue subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location on the Issue subtab
where you want the non-labor resource organization field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select OA_NLR_ORG (object MATUSETRANS).

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Adding Fields to the Cost Management Application

You can add budget, burdened, committed, and remaining cost fields to the Cost
Management application. These optional fields display the rolled-up project costs
transferred from Oracle PA to Asset Management System.

Add budget cost To add the budget cost field to the Cost Management (FINCNTRL) application,
complete the following steps:

1 On the Applications tab in the Application Designer, select FINCNTRL.

2 On the Workspace tab, click the Project subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the budget cost field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select BUDGETCOST (object FINCNTRL)

96 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add burdened cost To add the burdened cost field to the Cost Management application, complete the
following steps:

1 On the Applications tab in the Application Designer, select FINCNTRL.

2 On the Workspace tab, click the Project subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the burdened cost field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select BURDENEDCOST (object FINCNTRL)

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Add committed cost To add the committed cost field to the Cost Management application, complete
the following steps:

1 On the Applications tab in the Application Designer, select FINCNTRL.

2 On the Workspace tab, click the Project subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the committed cost field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select COMMITTEDCOST (object FINCNTRL)

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

Oracle Project Accounting Configurations 97

Configuration Activities

Add remaining cost To add the remaining cost field to the Cost Management application, complete the
following steps:

1 On the Applications tab in the Application Designer, select FINCNTRL.

2 On the Workspace tab, click the Project subtab.

3 Click the Control Palette icon on the task bar. The Controls dialog box
appears.

4 Drag the Textbox in the Controls dialog box to the location where you want
the remaining cost field to appear.

5 Ensure that the new textbox field is highlighted, then click the Control
Properties icon on the task bar. The Textbox Properties dialog box appears.

6 In the Attribute field, select REMAININGCOST (object FINCNTRL)

7 Move the cursor to the next field in Textbox Properties dialog box, then close
the dialog box.

8 Click the Save Application Definition.

For more information about all listed fields, see the Projects Accounting
information in the IBM Maximo Enterprise Adapter System Administrator Guide for
Oracle Applications 12 Adapter.

Enable the Financial Control Concurrent Extract Manager

The financial control concurrent extract manager (MAXFCEXP) initiates the
transfer of project and task summary information from Oracle Project Accounting
to the asset management system Cost Management application.

To register procedure MAXFCEXP as a concurrent process, complete the

following steps in Oracle Applications E-Business Suite:

1 In Oracle, select Responsibility: System Administrator.

2 Select Concurrent | Program | Executable.

3 Enter the following values:

Field Value

Executable MAXFCEXP [case-sensitive]

Short Name MAXFCEXP

Application* Projects

Description Financial Control Updates to the asset

management system

Execution Method PL/SQL Stored procedure

Execution File Name** maxora.extract_fc_data

98 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

* Some users might want to set up a custom application and group outside of
Oracle PA.

** Replace the schema name (in this case, maxora) with the schema name used
in your installation.

4 Save the data and close the form.

5 Select Concurrent | Program | Define.

6 Enter the following values:

Field Value

Program PRC: Asset Management System Financial

Control Update from Oracle

Enable [Select this check box]

Short Name FCEXTRACT

Application Name Projects

Description Financial Control Updates to Asset

Management System

Executable Name MAXFCEXP

Executable Method PL/SQL Stored Procedure

7 Save the data.

8 Click INCOMPATIBILITIES.

9 In the Name field, select PRC: Asset Management System Financial Control
Update from Oracle.

10 Save the data and close the form.

11 Click Parameters.

12 Enter the following values:

Field Value

Seq 10

Parameter Operating Unit ID

Description Operating Unit ID

Value Set 10/Number

Default Type Profile

Default Value ORG_ID

Display [Select this check box]

Oracle Project Accounting Configurations 99

Configuration Activities

13 Move the cursor to the next Seq line and enter the following values:

Field Value

Seq 20

Parameter Project Number

Description Project Number

Value Set PA_SRS_PROJECT_NUMBER

Display [Select this check box]

14 Move the cursor to the next Seq line and enter the following values:

Field Value

Seq 30

Parameter Budget Type

Description Budget Type

Value Set PA_SRS_BUDGET_TYPE_COST

Display [Select this check box]

15 Move the cursor to the next Seq line and enter the following values:

Field Value

Seq 40

Parameter Start Date

Description Retrieve all records modified on or after this

date

Value Set FND_STANDARD_DATETIME

Default Type SQL Statement

Default Value* select [Link]

('FCEXTRACTDATE') from dual

Display [Select this check box]

* Replace the schema name (in this case, MAXORA) with the schema name
used in your installation.

16 Save the data and close the form.

100 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Configuration Activities

Provide Access to the Financial Control Concurrent Extract

Manager
To provide access to this program to Projects Responsibility in the Oracle
Applications E-Business Suite, complete the following steps:

1 In Oracle, select Responsibility: System Administrator.

2 Select Security | Responsibility | Request.

3 Select View | Query by Example | Enter.

4 In the Group field, select All Project Programs.

5 Select View | Query by Example | Run.

6 Place the cursor on a row in the Requests table and Select File | New.

7 Enter the following values:

Field Value

Type Program

Name PRC: Asset Management System Financial

Control Update from Oracle

Application Projects

8 Save the data.

Synchronize Oracle Employees and Asset Management System

Labor Codes
To synchronize the labor and craft to update the asset management system with
cost rates from Oracle Project Accounting, see the synchronizing Oracle
employees and asset management system labor codes information.

Oracle Project Accounting Configurations 101

Configuration Activities

102 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Notices

This information was developed for products and services offered in the U.S.A.

IBM may not offer the products, services, or features discussed in this document
in other countries. Consult your local IBM representative for information on the
products and services currently available in your area. Any reference to an IBM
product, program, or service is not intended to state or imply that only that IBM
product, program, or service may be used. Any functionally equivalent product,
program, or service that does not infringe any IBM intellectual property right
may be used instead. However, it is the user's responsibility to evaluate and verify
the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter
described in this document. The furnishing of this document does not grant you
any license to these patents. You can send license inquiries, in writing, to:

IBM Director of Licensing

IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM
Intellectual Property Department in your country or send inquiries, in writing, to:

IBM World Trade Asia Corporation

Licensing
2-31 Roppongi 3-chome, Minato-ku
Tokyo 106-0032, Japan

The following paragraph does not apply to the United Kingdom or any other
country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS
PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS
FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express
or implied warranties in certain transactions, therefore, this statement may not
apply to you.

This information could include technical inaccuracies or typographical errors.

Changes are periodically made to the information herein; these changes will be
incorporated in new editions of the publication. IBM may make improvements
and/or changes in the product(s) and/or the program(s) described in this
publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for
convenience only and do not in any manner serve as an endorsement of those
Web sites. The materials at those Web sites are not part of the materials for this
IBM product and use of those Web sites is at your own risk.

© Copyright IBM Corp. 2008 103

 IBM may use or distribute any of the information you supply in any way it
believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose
of enabling: (i) the exchange of information between independently created
programs and other programs (including this one) and (ii) the mutual use of the
information which has been exchanged, should contact:

IBM Corporation
2Z4A/101
11400 Burnet Road
Austin, TX 78758 U.S.A.

Such information may be available, subject to appropriate terms and conditions,

including in some cases, payment of a fee.

The licensed program described in this document and all licensed material
available for it are provided by IBM under terms of the IBM Customer
Agreement, IBM International Program License Agreement or any equivalent
agreement between us.

Information concerning non-IBM products was obtained from the suppliers of

those products, their published announcements or other publicly available
sources. IBM has not tested those products and cannot confirm the accuracy of
performance, compatibility or any other claims related to non-IBM products.
Questions on the capabilities of non-IBM products should be addressed to the
suppliers of those products.

All statements regarding IBM's future direction or intent are subject to change or
withdrawal without notice, and represent goals and objectives only.

This information contains examples of data and reports used in daily business
operations. To illustrate them as completely as possible, the examples include the
names of individuals, companies, brands, and products. All of these names are
fictitious and any similarity to the names and addresses used by an actual
business enterprise is entirely coincidental.

If you are viewing this information softcopy, the photographs and color
illustrations may not appear.

104 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
Trademarks
IBM, the IBM logo, and [Link] are trademarks or registered trademarks of
International Business Machines Corporation in the United States, other
countries, or both. If these and other IBM trademarked terms are marked on their
first occurrence in this information with a trademark symbol (® or ™), these
symbols indicate U.S. registered or common law trademarks owned by IBM at the
time this information was published. Such trademarks may also be registered or
common law trademarks in other countries. A current list of IBM trademarks is
available on the Web at “Copyright and trademark information” at
[Link]/legal/[Link]

Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered
trademarks or trademarks of Adobe Systems Incorporated in the United States,
and/or other countries.

Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo,
Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or
registered trademarks of Intel Corporation or its subsidiaries in the United States
and other countries.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of
Microsoft Corporation in the United States, other countries, or both.

Java and all Java-based trademarks and logos are trademarks of Sun
Microsystems, Inc. in the United States, other countries, or both.

Linux is a registered trademark of Linus Torvalds in the United States, other

countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other
countries.

Other company, product, or service names may be trademarks or service marks of

others.

105
106 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Index

A conversion factors
coordinating 35
defining in asset management system 47
coordination
accounts payable, configuring in Oracle to import invoices from
conversion factors 35
asset management system 78
address codes, synchronizing with Oracle organizations 41 general ledger accounts 35
tax rates 35
APIN control 34
user names 35
APITRANS control 32
APITRG control 32 cost management hidden fields 96
cron task
asset management system
activating for interface table polling 36
application server software requirements 2
changing column lengths 20, 81 activating for sequential queues 18
setting up schedule for interface table polling 19
changing GL account formats 20, 81
currency codes
companies master set, inserting Oracle vendors 22
companies, synchronizing with Oracle vendors 44 defining Oracle codes in asset management system 44
synchronizing Oracle and asset management system 43
company ID, updating with RBNI and suspense account 45
currency, base 35
creating interface tables in the Oracle database 29
data, synchronizing with Oracle 35
GL account format, reconfiguring to match Oracle 20
how to configure the Oracle Adapter 9
importing POs into Oracle
asset management system 67
D
item status, active 23
objects created in the MAXORA schema 55
database columns, resizing after installation 71, 81
synchronizing storeroom locations, Oracle organizations 46
duplicate processes 80
tables, changing column lengths 71

B E

endpoint, configuring 10, 11

base currency 35 enterprise services
Oracle Project Accounting integration 81
enterprise services, enabling for Oracle Project Accounting
integration 81
C EXCEPTIONTOEXT control 32
EXCEPTIONTOMAX control 33
expenditure type 83
exporting POs to Oracle 67
calendars, financial 35
charge organization field 83 EXTSYS control 33
chart of accounts, synchronizing Oracle and asset management
system 40
checklist, Oracle Project Accounting installation 80
COAIN control 34
column lengths, changing in asset management system 20
F
column lengths, changing, asset management system 81
COMIN control 34
financial calendars 35
[Link] 22
financial control concurrent extract manager
configuring accessing 101
Oracle Adapter endpoint 10, 11
enabling 98
Oracle Adapter in asset management system 9
Oracle Adapter installation parameters 27
Oracle Adapter integration controls 14
Oracle Applications for integration with asset management
system 75
Oracle-specific integration controls 35

© Copyright IBM Corp. 2008 107

Index

G L

general ledger labor codes, synchronizing with Oracle employees 41

account coordination 35 LCIN control 34
account format, changing in asset management system 20 LOGLEVEL control 34
account format, changing, asset management system 81
components, synchronizing 39
configuring in Oracle to import journals from asset
management system 76
structure M
changing asset management system to match Oracle 20
GLSOBID2 control 33
mapping
asset management system bill to company to Oracle
organization 42
asset management system bill to contact to Oracle employee 42
H asset management system ship to company, employee to Oracle
location 42
Oracle organizations and locations to asset management system
hardware configuration requirements 2 address codes 42
MAXFCEXP. see financial control concurrent extract manager
MAXORA schema 26, 55
MAXORACTLS controls
APIN 34
I APITRANS 32
APITRG 32
COAIN 34
importing COMIN 34
POs into Oracle 67 EXCEPTIONTOEXT 32
importing asset management system POs into Oracle 67 EXCEPTIONTOMAX 33
[Link] 30, 31 EXTSYS 33
installation GLSOBID2 33
checking [Link] for errors 31 integration control table in the Oracle database 31
Oracle adapter in Windows 5 INVBALIN 34
Oracle adapter requirements 1 ISUIN 34
packages, procedures, and triggers 30 ITEMIN 34
PL/SQL objects to the Oracle Applications database 25 ITMBALXFRIN 34
prerequisites for the Oracle adapter 5 LCIN 34
required skills and qualifications 1 LOGLEVEL 34
software required for Oracle adapter install 2 MEAORAVER 33
integration controls PCIN 34
configuring for the Oracle Adapter 14 POIN 34
Oracle Project Accounting integration 81 PROJPAY 34, 81
setting up 81 RCVIN 34
setting up Oracle-specific values in asset management system MEAORAVER control 33
37 measure, units of 35
integration schema, creating in Oracle Applications database 26
interface tables
creating using the asset management system integration 29
enable polling with a cron task 36
polling with a cron task 19 N
INVBALIN control 34
invoice application hidden fields 91
issue application hidden fields 95 names, user, coordinating 35
ISUIN control 34 non-labor resource organization 83
item balances
synchronizing in Oracle and asset management system 52
transferring from Oracle to asset management system 52
verifying in asset management system 53
ITEMIN control 34 O
items, synchronizing Oracle and asset management system values 49
ITMBALXFRIN control 34
OA12 external system 36
Oracle adapter
checking for installation errors 31
configuring in asset management system 9
installation overview 1
installing in Windows 5
name and location of PL/SQL files 26

108 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter
 Index

path to [Link] configuration file 27

[Link] configuration file 27
R
Oracle Applications
configuring for asset management system integration 75
RBNI, adding to asset management system company ID 45
currency codes, generating with showcurr 43
RCVIN control 34
data, synchronizing with asset management system 35 receipts applications hidden fields 92
database, creating the integration schema 26
database, installing PL/SQL objects for the Oracle adapter 25
item balances, transferring to asset management system 52
locations, generating with showaddr 42
order units S
generating with showtax 48
generating with showuom 47
organizations, generating with showaddr 42 sequential queues, activating with a cron task 18
organizations, generating with showids 46 server configuration recommended hardware 2
server software requirements 2 [Link] 27
setting up accounts payable to import invoices from asset setup, Oracle Applications for asset management system integration
management system 78 75
setting up general ledger to import journals from asset showaddr, generating a list of Oracle organizations and locations 42
management system 76 [Link] file, generating 37
vendors, adding to the asset management system companies showcurr, generating a list of Oracle currency codes 43
master set 22 showids, generating a list of Oracle organizations 46
Oracle database [Link] file 38
configuring the MAXORACTLS integration controls table 31 showtax, generating a list of Oracle tax codes 48
installing packages, procedures, and triggers 30 showuom, generating a list of Oracle order units 47
Oracle external system (OA12), enabling 36 software
Oracle Project Accounting integration 79–101 asset management system application server requirements 2
checklist 80 Oracle Application server requirements 2
database column lengths 81 required for Oracle adapter install 2
enabling publish channels, enterprise services 81 [Link] file 6
financial control concurrent extract manager 98, 101 storeroom, creating in asset management system 46
hidden fields 82 suspense account, adding to asset management system company ID
integration controls 81 45
integration event listener 81 synchronizing
prerequisites 6, 80 Oracle and asset management system chart of accounts 40
publish channels, enterprise services 81 Oracle and asset management system currency codes 43
user interfaces 82 Oracle and asset management system data 35
ORACLEAPIS directory 26 Oracle and asset management system GL components 39
output file Oracle and asset management system item balances 52
generating [Link] 37 Oracle and asset management system items 49
generating [Link] 38 Oracle employees and asset management system labor codes
41, 101
Oracle order units and asset management system units of
measure 47
Oracle organizations and asset management system storeroom
P locations 46
Oracle organizations and locations and asset management
system address codes 41
PCIN control 34
Oracle vendors and asset management system companies 22,
PL/SQL files 26 44
PL/SQL objects, installing to Oracle Applications database 25
POIN control 34
prerequisites
Oracle Adapter installation 5
Oracle Project Accounting integration 80 T
Projects integration. see Oracle Project Accounting integration
PROJPAY control 34, 81
publish channels tax codes
Oracle Project Accounting integration 81 adding in asset management system 48
publish channels, enabling for Oracle Project Accounting integration defining in asset management system 48
81 tax rates, coordination 35
purchase order application hidden fields 90 triggers 32
purchase orders, importing into Oracle 67
purchase requisition application hidden fields 89

units of measure 35

109
Index

defining in asset management system 47

synchronizing with Oracle order units 47
user interface
charge organization field 83
cost management application 96
expenditure type field 83
invoice application 91
issue application 95
non-labor resource organization field 83
Oracle Project Accounting integration 82
purchase order application 90
purchase requisition application 89
receipt applications 92
work order tracking application 83
user names, coordinating 35

Windows, installing Oracle adapter 5

work order tracking application hidden fields 83

110 IBM Maximo Enterprise Adapter: Installation Guide for Oracle Applications 12 Adapter