My Oracle Support Banner

FAQ: Automatic Asset Numbering (Doc ID 469359.1)

Last updated on JANUARY 29, 2021

Applies to:

Oracle Assets - Version 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.


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)

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 What mechanism uses Automatic Asset Numbering?
 Is the Automatic Asset Numbering sequential for each corporate book?
 Can Automatic Asset Numbering be set to have no gaps for an instance?
 Can Automatic Asset Numbering skip numbers even if it is pinned?
 Can an asset number be reused?
 If an asset number is assigned manually, what number will receive next assigned asset?
 When does Post Mass Additions process assigns asset numbers?
 How to manually revert to the auto-assigned asset number when an incorrect asset number was assigned to it by mistake?
 Can you have the same asset number in a different corporate book?
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.