item number auto generation
Posted: 25 April 2009 06:21 PM
Newbie
Rank
Total Posts:  2
Joined  2009-04-25

Hi gurus, I would like to know if I can create automatically the Item Number based on the Item Category and then selecting the last sequence in that.At least suggesting that in the Item Master Number field.Can you advie how to do this customization?thanks in advance

Profile
 
Posted: 13 May 2009 09:32 PM   [ # 1 ]
Newbie
Rank
Total Posts:  3
Joined  2008-11-14

yeah,  you can do this using forms personalisation.

you’ll have to use one of the post triggers which fires after item category is populated

Profile
 
Posted: 11 July 2009 11:15 PM   [ # 2 ]
Newbie
Avatar
Rank
Total Posts:  3
Joined  2009-07-04

Hi,

We can write a piece of pl/sql code to generate the Item number sequence and map that code to a function created in Oracle EBS. we do have an option in Item catalog category definition page to map a function for item number generation. There you can map this function which will generate item numbers automatically.

Cheers,
Chaitanya Kr.

 Signature 

Cheers,
Chaitanya Kr

Profile