FAQ: Automatic Asset Numbering (Doc ID 469359.1)

Last updated on MARCH 28, 2025

Applies to:

Oracle Assets - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Oracle Assets - Version 12.2.4 and later
Information in this document applies to any platform.

Purpose

This document clarifies the way Automatic Asset Numbering works, explains how gaps can appear in it, and when and how these can be prevented.

The automatic numbers are setup in the System Control window (FAXSUSTL). An asset number is either manually entered or only automatically generated. When a new asset does not have a manually-entered number, an automatic one is generated by the system. The manual numbers may not fall in the range defined for automatic numbering.

Note: Even if you choose to manually number all your assets, you still need the automatic numbering as this numbering generates the asset_id used internally in Oracle Fixed Assets. The asset number, from a functional perspective, is the manually-entered one when entered manually or the automatically-generated one when not entered manually. In both cases ,the automatic generated internal asset_id is used.

Here is the screenshot form the System Control window (FAXSUSTL)