Home » Applications » Oracle Fusion Apps & E-Business Suite » How to make new item code automatically (11.5.10)
How to make new item code automatically [message #447658] Wed, 17 March 2010 02:36 Go to next message
baonam
Messages: 5
Registered: February 2010
Location: Incharge
Junior Member

Dear all,

I want to make new item code automatically.
Please guide me the way to make it.

Thanks you so much.
Kha Han.
Re: How to make new item code automatically [message #448571 is a reply to message #447658] Wed, 24 March 2010 02:08 Go to previous messageGo to next message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member

hi,
you can defince a sequence and automatically create the new item code on save the data first
Re: How to make new item code automatically [message #448593 is a reply to message #448571] Wed, 24 March 2010 03:21 Go to previous messageGo to next message
baonam
Messages: 5
Registered: February 2010
Location: Incharge
Junior Member

Hi!
Thanks you for your replay.
But I don't know how to do it?
Could you please giude me the steps to make it?

Thanks and Best Regards,
baonam
Re: How to make new item code automatically [message #448704 is a reply to message #448593] Wed, 24 March 2010 20:51 Go to previous messageGo to next message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member

first :define a item code rule ,the item codes combined with sequence and characters.

second:you open the item define form ,open the form-level trigger
'POST-DATABASE-COMMIT',in there to add your custom code

eg: select xxx_seq.next_val||'item code rule'
into XXXX.XXXX FROM DUAL
Re: How to make new item code automatically [message #448708 is a reply to message #448704] Wed, 24 March 2010 21:53 Go to previous messageGo to next message
baonam
Messages: 5
Registered: February 2010
Location: Incharge
Junior Member

Hi,

Thanks you for you reply.
To make new item code, we have a form to make it.
But, now, every day, I have to make 100 items/day by using a form make new item code. It take many time.
So, I want to write a program which I can make many item as the same time.
I have the begin data to make item (catagory, catalog, UOM, item type, organization_id...), but Idon't know the process of data to make item
Please help me.
Thanks
baonam.
icon7.gif  Re: How to make new item code automatically [message #448931 is a reply to message #448708] Thu, 25 March 2010 20:43 Go to previous message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member

hi,

do you want to create new item auto?


my msn is:ltp200567@hotmail.com

maybe we can discuss it
Previous Topic: Project Accounting
Next Topic: Need help on Custom.pll
Goto Forum:
  


Current Time: Sat Sep 24 23:09:53 CDT 2016

Total time taken to generate the page: 0.04796 seconds