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