| Oracle Assets Automatic Number Questions [message #95211] |
Fri, 07 March 2003 09:09  |
k
Messages: 12
Registered: July 1999
|
Junior Member |
|
|
Hi,
I am currently working in Fixed Assets 11.0.3.
Is it possible to disable the automatic asset numbering once it has been enabled and assets have been created? If possible, where and how can this be done. If not, is there a work-around?
Is it possible to re-set the "Starting Asset Number"? If so where can this be done and what implications will this have?
Thanks in advance for your help.
|
|
|
|
| Re: Oracle Assets Automatic Number Questions [message #95215 is a reply to message #95211] |
Mon, 10 March 2003 22:31  |
Rajesh Bhandari
Messages: 2
Registered: March 2003
|
Junior Member |
|
|
|
Assets Numbering works in the following way: 1. Once asset numbering is implemented Navigate Setup System Options, then there is no way of ammending the asset numbering start point through this form. 2. If you leave the asset number field blank while adding an asset and then commit, Assets will automatically generate the asset number for you. If you need to use some other numbering convention, then simply populate the asset number field (this could be alphanumeric). 3. Whenever Assets generates a number for you automatically, the asset_number will be equal to the asset_id, ie: the last sequence number generated. This will be displayed back to you in Navigate Setup System Options as the last number used. 4. When implementing Assets, set the Starting number to the required value, sequence FA_ADDITIONS_S will be automatically created to start from this number. FA_ADDITIONS_S is used to generate the asset_id whether you manually input an asset number or not, in either of the additions forms. 5. It therefore follows that even though your Starting number is 'x', if you add two assets manually numbering the first, and leaving the second asset's number field blank, the manaully numbered asset_id would be x+1 whilst the asset_id for the second asset would be x+2. 6. If for any reason you need to change the starting number sequence then you will need to do the following: *** NEVER CHANGE TO A NUMBER LOWER THAN THE HIGHEST VALUE ALREADY IN USE *** *** CONSULT YOUR DBA/SYSADMIN BEFORE MAKING ANY CHANGES TO THE SYSTEM *** *** UNAUTHORIZED SQL CHANGES TO THE SYSTEM ARE NOT SUPPORTED *** drop sequence FA_ADDITIONS_S create sequence FA_ADDITIONS_S increment by 1 start with <new number - This must be higher than last asset_id used> cache 20 order nocycle 7. To check that the sequence is functioning:- select FA_ADDITIONS_S.nextval from system.dual
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
