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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: Project Accounting
Next Topic: Need help on Custom.pll
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 10 02:08:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.