Asset Tracking

Oracle E-Business Suite Plugin

Anything's possible.

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.

Diagram

The diagram below displays the components involved in the communication between Oracle E-Business Suite and the ATT software.

Oracle EBS Diagram

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 plugin:
  • 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
    • FA_BOOKS
  • It delivers information to the following tables when sending item data:
    • FA_INVENTORY
    • 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
  • 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 a text file.

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.
  • 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
  • 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