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.
The diagram below displays the components involved in the communication between Oracle E-Business Suite and the ATT software.
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”.
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:
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.
The ATT interface updates two tables in the Oracle E-Business Suite database. These are:
Two fields of the FA_INV_INTERFACE table are modified by the ATT interface in accordance with the Oracle E-Business Suite. These are:
The date of the inventory count is set to the system date of the transfer PC when the user successfully performs a "Send Assets".
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|
|In Use Flag||CHAR||3||status||CHAR||4|
|Property Type Code||CHAR||10||spare4||CHAR||10|
|Last Update By||CHAR||15||userid||CHAR||20|
|Asset Key CCID||CHAR||15||equipmentnum||CHAR||18|
|Last Update Date||CHAR||8||laststocktake||CHAR||8|
|Last Update Time||CHAR||6||time||CHAR||6|