Auto Numbering
Auto Numbering
Auto Number is an import feature of Service Contracts. It lays out the rules how the contract number will be generated. Contract numbers can be sequential number or a combination of defined prefix and suffix that can alpha-numeric.
There are number of attribute provided by Oracle that can be used in different combinations to achieve a numbering sequence. These are:
- Site - The rule can be setup at Site level that impact the entire site. All contracts created under that site even of different business group / Operating Unit / Class will follow as numbering sequence.
- User Function - You can write you own pl/sql to generate the numbering sequence. Till now what ever I worked I haven't seen using function to generate contract numbers.
- Business Group - If setup at this level all contract under the business group use the same number sequence unless a specific Class or Category is chosen. If it further dependent on Class / Category then it will unique numbers with the specified combination.
- Operating Unit - Same goes with Operating Unit. All contract under same Operating Unit will have same numbering sequence unless is further classified based on Class / Category.
- Class - If set only at Class, all contract created for a particular class have same sequence. Contract Class is like Service Agreement, Project Contract etc.
- Category - If set at Category level, all contract for a particular category will have same numbering sequence. Contract categories are like Service Agreement, Warranty and Extended Warranty, Subscription Agreement etc...