ATT Oracle E-Business Suite Interface

Overview

The ATT Oracle E-Business Suite interface exchanges information with the Oracle E-Business Suite database.

The information that is extracted from the Oracle E-Business Suite is the asset data that can be viewed by navigating to Application->Fixed Assets Manager->Assets->Asset Workbench. The user must have access to the fixed asset module of Oracle E-Business Suite Applications in order to view this data as illustrated in the diagram at the bottom of this page.

Oracle E-Business Suite Tables

Data is extracted from the Oracle E-Business Suite based on various aspects and selection criteria. Assets will not be included in the selection if they have a value in the "ineffective date" fields in the Oracle E-Business Suite tables “FA.distribution_history” and “FA.FA_Books”.

Features of the ATT Oracle E-Business Suite interface:

It uses the Oracle Call Interface (OCI) API to extract information from the underlying Oracle Database. Similarly, it will deliver information to the underlying Oracle Database. There is no communication with the Oracle E-Business Suite Application;
It extracts information from the following tables when receiving item data:

FA_ADDITIONS_B;
FA_ADDITIONS_TL;
FA_DISTRIBUTION_HISTORY;
FA_CATEGORIES_B;
FA_LOCATIONS; and
FA_BOOKS.

It delivers information to the following tables when sending item data:

FA_INVENTORY; and
FA_INV_INTERFACE

ATT "Get Assets"

As there may be many thousands of assets within a host system, it is not typically desirable that all of the assets be extracted. Usually, only limited sections or types of asset data is required. Therefore, ATT limits the asset selection based on various selection criteria.

The selection criteria that ATT supports with the Oracle E-Business Suite when choosing assets includes:

Book Type;
Category; and
Location.

The information displayed in the three selection windows of the ATT "Get Assets" windows is abbreviated. This is because the full description will not fit within the selection box. The full description of each Book Type, Category and Location, may be viewed in the text file called “select.list” which is typically located in the “/home/dcsi/assets” directory of the transfer PC. This file may be in a different location if the installation of the ATT occurred in a directory other than the default.

ATT "Send Assets"

The ATT interface updates two tables in the Oracle E-Business Suite database. These are:

FA_INVENTORY –The header for the data; and
FA_INV_INTERFACE – The data from ATT.

Two fields of the FA_INV_INTERFACE table are modified by the ATT interface in accordance with the Oracle E-Business Suite. These are:

Number of units; and
Location.

The date of the inventory count is set to the system date of the transfer PC when the user successfully performs a "Send Assets".

Field Mapping

The field mapping details between the Oracle host and the ATT data is displayed in the table below.

Oracle Host Field	Type	Length	ATT Field	Type	Length
Book Type Code	CHAR	15	inventorynote	CHAR	15
Asset ID	CHAR	22	spare8	CHAR	20
Asset number	CHAR	15	assetnum	CHAR	12
Description	CHAR	80	description	CHAR	50
Location	CHAR	15	location	CHAR	10
Current Units	CHAR	22	functionalloc	CHAR	30
Category ID	CHAR	22	spare7	CHAR	20
Category Code	CHAR	210	spare10	CHAR	50
Serial Number	CHAR	35	serialno	CHAR	18
Tag Number	CHAR	15	inventorynum	CHAR	25
Model Number	CHAR	40	maintext	CHAR	50
In Use Flag	CHAR	3	status	CHAR	4
Asset Type	CHAR	11	internalorder	CHAR	12
Manufacturer Name	CHAR	30	controllertext	CHAR	30
Property Type Code	CHAR	10	spare4	CHAR	10
Last Update By	CHAR	15	userid	CHAR	20
Inventorial	CHAR	3	spare2	CHAR	5
Asset Key CCID	CHAR	15	equipmentnum	CHAR	18
Last Update Date	CHAR	8	laststocktake	CHAR	8
Last Update Time	CHAR	6	time	CHAR	6